On our team, we typically load data into Redshift directly from S3 using the SQL COPY statement.Īnd manage all our ETL using the excellent Apache Airflow tool. When possible prefer DROP TABLE or TRUNCATE to DELETE to avoid ghost rows INSERT INTO deep_dive SELECT * FROM staging
0 Comments
Leave a Reply. |