How to load S3 data to Redshift | Create Redshift table from CSV file in S3

In this demo, I show you how to load your data from S3 to Redshift and create a table from CSV data.
#aws #redshift #s3

[@ahmetalperenyildirim6184]

Thanks a lot, I was searching and it was the first time I saw IAM S3 bucket role with you. Thank you for sharing, keep up good work!

[@AWS-Made-Easy]

Thank you!

[@kachiobasi7253]

really great. can i achieve this this table process and loading data from my vscode without going through console?

[@AWS-Made-Easy]

@@kachiobasi7253 you can! Please explore boto3 , you will find relevant methods to do the same

[@karthikeyan1921]

Its been long time you upload videos 😊

[@AWS-Made-Easy]

😊 yes Karthikeyan! Hoping to post more often going forward!

[@AllAboutDataTechnology]

good short tutorial, Thanks!

[@SpiritOfIndiaaa]

thanks a lot , can we query live data ?? i mean CDC data ??

[@shakthimaan007]

But how can we do this for PROD use case and not manually?

[@Andhra-Player]

What if My data is in sub folders ?

[@anitadesai8582]

Will it automatically update data from S3 to redshift? Or do we need to schedule it for automation?

[@AWS-Made-Easy]

It won’t automatically load the data, you will have to implement an automation.

[@soso2413]

Please, where is the employee_data.csv file?

[@ramachandrans6349]

Hi sir, what is the difference between redshift sleeveless data loading and cluster data loading

[@AWS-Made-Easy]

The process of loading data is pretty much similar. Difference lies in the way redshift cluster and serverless work. With serverless you only pay when you run the queries, for cluster you pay a fixed cost for the compute capacity of the cluster irrespective of the usage

[@ramachandrans6349]

Thank you​@@AWS-Made-Easy

[@TEACHDATASCIENCE]

Thank you..