Creating a Simple ETL Data Pipeline using Amazon Redshift and DataGrip [Part2]
In this lab we will show you how to perform the following tasks that will help you in creating a simple data pipeline on AWS using redshift.
1: Create stack using cloud formation
2: Download sample dataset
3: Upload dataset into s3 buckets
4: Download and Install DataGrip
5: Connect data grip with S2 bucket
6: Create schema and tables via SQL
7: load data from s3 bucket into redshift tables
Please visit out websites datanerds.io and skillcurb.com for more free tutorials on cloud technologies.
#cloudformation #s3 #redshift #sqlqueries #datapipeline