Export data from Snowflake

You can use Snowflake SQL queries , or you can export data from Snowflake via  SQL queries that access semi-structured data using special operators and functions. The following example describes how to retrieve JSON data from Snowflake:

select
value:first_name::string as "first name",
value:last_name::string as "last name",
value:city::string as "city",
value:zip::string as "zip"
from shopify_customer,
    lateral flatten(input => properties:addresses);

{
  "page_of_records": [
    {
      "record": {
         "first name": "Test",
         "last name": "Smith",
         "city": "Springfield",
         "zip": "55555"
       }
     ]
   }
}

If you already use S3 buckets for storing and managing your data files, you can use your existing buckets and folder paths when unloading data from Snowflake tables, and then retrieve that data with your Amazon S3 connection for use in a flow.

If you have configured your Snowflake account to use Amazon S3 storage, enter the following command in the Query field to automatically copy Snowflake data to Amazon S3:

COPY INTO @my_ext_unload_stage/dl_file_prefix 
from Shopify_customer 
OVERWRITE = TRUE 
file_format = (format_name ='mycsvformat' compression='NONE');

The Grouping option allows you to manage your flow’s files by grouping records by field. This feature allows you to aggregate your data based on your chosen field(s).