Remove 2003 Remove Data Architecture Remove Data Lake
article thumbnail

Simplify data ingestion from Amazon S3 to Amazon Redshift using auto-copy

AWS Big Data

All new sales transactions for 2003-01-01 are automatically ingested, which can be verified by running the following query: SELECT ss_sold_date_sk, count(1) FROM store_sales GROUP BY ss_sold_date_sk; Automate ingestion from multiple data sources We can also load an Amazon Redshift table from multiple data sources.