Amazon Athena vs. Azure Data Lake Analytics

If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.

Incentivized

Azure Data Lake Analytics services are beneficial when working with a lot of data. It can process enormous amounts of data extremely quickly. Service is secure and easy to set up, build, scale, and run on Azure. Regarding big data analytics and reporting, parallel processing has a significant impact. It consolidated our analytics from multiple systems and increased our analysis productivity. This tool has excellent support for reporting tools like Power BI and is very quick when performing analytics.

Incentivized

• Nested Schemas like JSON data structure
• Ability to adapt the data model to fit your queries better
• Performance Improvement

Incentivized

• Process large data transformation jobs using pretty much any language needed.
• Native integration with Azure storage.
• Top notch security that fulfills all audit needs.
• Easy to consolidate enterprise data under one location - Single source of truth.

Incentivized

• Query manager can incoperate GUI based query designer
• Auto-completion engine sometimes overwrite the query
• Time range selection should be implicit

Incentivized

• There's a bit of bias towards cloud with ADL Analytics. Depending upon a company's infra strategy and investment plans, there are some challenges with migration and integeration.
• Not worth the time/effort/money if the organization doesn't have "Volume" of data. Cost effective only when daily loads exceed around 1million.
• While training materials are available online, Adoption rate - Yet to pick up.

Incentivized

Amazon Athena, a product from Amazon, competes with offerings from Google and Microsoft. Overall, I think your database choice depends on some of the other applications you are running at your company. For example, if you are using Microsoft Power BI for reporting needs, you might want to consider going the Azure route.

Incentivized

We did some research about Alibaba Cloud Data Lake Analytics and even being cheaper than Azure Data Lake Analytics, we decided to go for the second one once we noticed they have more features and better documentation. Another thing we considered during this process was the fact that we have more people that already have Azure Cloud knowledge.

Incentivized

• Easy to query terabytes of data with faster response
• Pricing model is also cheap
• No indexing and partitioning

Incentivized

• It lets us manage and scan data, making our work easy and efficient.
• It helped me manage real-time data, process it, and send it to reporting.
• Data centralization or data warehousing projects are being implemented with its help.

Incentivized