I have a SQL to run on three Snowflake tables hosted on AWS account. I would like to stream any new records based on the output of my SQL to an S3 bucket using possibly Kafka or any other streaming service. What are my options to implement this?
1 Answers
You can unload data directly into an S3 bucket :
- Create storage integration.
- Create stage or specify bucket url directly in the query.
copy into s3://mybucket/unload/ from mytable storage_integration = s3_int;
Ref : https://docs.snowflake.com/en/user-guide/data-unload-considerations.html
Related