Is there a best way to get data from snowflake to s3. ? the data snowflake shows will be in s3, but we don’t have access to that bucket. And we only need to get the specific tables from Snowflake not the entire data.
Advertisement
Answer
you will want the unloading into Amazon S3 documentation.
you can ether choose a table with the
copy into s3://mybucket/unload/ from mytable storage_integration = myint file_format = (format_name = my_csv_format);
or choose from a select, which is mostly how I export data.
copy into @my_stage from ( select * from orderstiny limit 5 );
again the COPY INTO doc’s are helpful here.