3 ms·
One of the big wins we get from AWS is that you can do things like load structured data files (csv, parquet) from S3 directly in Redshift using SQL queries. ht
by tootie 3y ago
One of the big wins we get from AWS is that you can do things like load structured data files (csv, parquet) from S3 directly in Redshift using SQL queries.
https://docs.aws.amazon.com/redshift/latest/dg/t_loading-tables-from-s3.html https://docs.aws.amazon.com/redshift/latest/dg/t_loading-tab...
- inian 3y agoThis is indeed pretty cool. They also have the `aws_s3` extension [1] for doing the same thing inside Postgres. Unfortunately, the extension isn't open source. [1]: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_...
- kiwicopple 3y agowe might be able to achieve the same thing now with our S3 Wrapper: https://supabase.github.io/wrappers/s3/ https://supabase.github.io/wrappers/s3/