article thumbnail

Speed up queries with the cost-based optimizer in Amazon Athena

AWS Big Data

You can analyze data or build applications from an Amazon Simple Storage Service (Amazon S3) data lake and 30 data sources, including on-premises data sources or other cloud systems using SQL or Python. Let’s discuss some of the cost-based optimization techniques that contributed to improved query performance.

article thumbnail

Use Amazon Athena with Spark SQL for your open-source transactional table formats

AWS Big Data

AWS-powered data lakes, supported by the unmatched availability of Amazon Simple Storage Service (Amazon S3), can handle the scale, agility, and flexibility required to combine different data and analytics approaches. The timestamp clause lets us travel back without altering current data.

Snapshot 103
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Chipotle’s recipe for digital transformation: Cloud plus AI

CIO Business Intelligence

When Curt Garner became Chipotle’s first CIO in 2015, the only technology used for online restaurant ordering was, “believe it or not,” a fax machine, he says. The system provides “demand-based cooking and ingredient preparation forecasts to optimize throughput and freshness while minimizing food waste,” according to the company.

article thumbnail

Moving Enterprise Data From Anywhere to Any System Made Easy

Cloudera

Since 2015, the Cloudera DataFlow team has been helping the largest enterprise organizations in the world adopt Apache NiFi as their enterprise standard data movement tool. Every organization on the hybrid cloud journey needs the ability to take control of their data flows from origination through all points of consumption.

article thumbnail

Moving Enterprise Data From Anywhere to Any System Made Easy

CIO Business Intelligence

Since 2015, the Cloudera DataFlow team has been helping the largest enterprise organizations in the world adopt Apache NiFi as their enterprise standard data movement tool. Every organization on the hybrid cloud journey needs the ability to take control of their data flows from origination through all points of consumption.

article thumbnail

How SumUp made digital analytics more accessible using AWS Glue

AWS Big Data

In this post we showcase how we used AWS Glue to move siloed digital analytics data, with inconsistent arrival times, to AWS S3 (our Data Lake) and our central data warehouse (DWH), Snowflake. AWS Glue gave us a cost-efficient option to migrate the data and we further optimized storage cost by pruning cold data.

article thumbnail

Extend your data mesh with Amazon Athena and federated views

AWS Big Data

Recently, Athena added support for creating and querying views on federated data sources to bring greater flexibility and ease of use to use cases such as interactive analysis and business intelligence reporting. Big Data Architect on Amazon Athena. Let’s dive into the solution. Pathik Shah is a Sr.