How to load S3 data to Redshift | Create Redshift table from CSV file in 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

[@shakthimaan007]

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

[@AllAboutDataTechnology]

good short tutorial, Thanks!

[@karthikeyan1921]

Its been long time you upload videos 😊

[@AWS-Made-Easy]

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

[@SpiritOfIndiaaa]

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

[@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..

[@soso2413]

Please, where is the employee_data.csv file?

[@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.

[@Andhra-Player]

What if My data is in sub folders ?