Reading data from S3 and loading it into Redshift for the transformation we have to use dbt core

Help
,
1

I have requirements like reading data from S3 and loading it into Redshift for the transformation we have to use dbt core. Please help me with this.

2

Please anyone help me for this

3

Are you using airflow , if so , you can use copy command to copy the raw data from s3 to redshift table and then use dbt for the transformation to the final target table

4

@dhanasekaran2023 , did you get any solution to read data from S3 using dbt