Amazon Athena vs. Azure Data Lake Analytics

Best suited for analyzing huge amounts of data by just querying on Amazon Athena. Amazon Athena is also best to integrate with Amazon Quickight for visualization and reporting of data. Easy to work with CSV, JSON, and columnar data formats like Parquet, and ORC. Less appropriate to work with AVRO data format and also stored procedures are not supported in Amazon Athena. The size of a single row is also limited to 32 MB.

Incentivized

For us we have an enterprise of SQL users at all skill levels, and this product is very SQL friendly and extremely fast in creation of data aggregates and analysis. If you are an Azure storage user, considering using Lake Analytics over top of your blob or any other storage just adds complementary services and functions native to your existing architecture.

Incentivized

• Load Balance traffic analysis
• Big data report generation
• Micro services pattern query analysis

Incentivized

• It combines big data.
• Monitors and alerts are helpful.
• Report visualization relies on analytics.
• It is compatible with Power BI services for report generation.

Incentivized

• Every dialect of SQL has some missing functions. I wish there was automated GROUP BY options here.
• There are connection problems back to Power BI occasionally.
• If you don't watch certain queries, it's possible that it takes a long time to run and charges you a lot of money.

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

Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.

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

Azure Data Lake simplifies extensive data analysis. It runs Hadoop, HDInsight, and Data Lakes, and even complex queries run smoothly and quickly. We write queries to transform data and extract insights instead of configuring hardware. It can handle any size job by adjusting the power. Azure's servers, networking, and data entry are fantastic. It provides security and assured data access.

Incentivized

• It's easy to store and query data on S3. Multiple teams can query the same data to generate their reports. It removes the need for a full-fledged data warehouse for a startup. Saves costs.
• Improved team efficiency on monitoring user activities by easy logging and reporting.
• As the dataset gets heavier on S3, one needs to understand partitioning and that leads to the requirement of expertise.

Incentivized

• Since we have implemented this solution, we have been more able to follow what is going on in our process and sells.
• We are also sparing some money by comparing the costs now against the costs we had on-premise.

Incentivized