Simplify data ingestion from Amazon S3 to Amazon Redshift using auto-copy
AWS Big Data
OCTOBER 30, 2024
Now upload the files for transaction sold on 2002-12-31. Let’s run a query to get the daily total of sales transactions across all the stores in the US: SELECT ss_sold_date_sk, count(1) FROM store_sales GROUP BY ss_sold_date_sk; The output shown comes from the transactions sold on 2002-12-31.
Let's personalize your content