sqlamazon-s3snowflake-cloud-data-platformattunitysnowflake-schema

Is there a best way to get data from snowflake to s3


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.


Solution

  • 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.