Pipe Data from Snowflake, to an S3 bucket, and then to Airfold
Sources
and click on Create new Source
. Alternatively, click on the +
next to Sources
in the left-hand tool bar.
S3 from Snowflake
User
and assigned it the necessary permissions.Access Key
and a Secret Access Key
for the new User.< >
<stage_name>
is what you will name your stage.<bucket-name>
is the name that you gave the bucket that you just created in AWS.<path>
is the directory (also called a prefix) in your bucket where you want the data to land. If you don’t specify a path, Snowflake will write to the root of the bucket by default.<key-id>
and <secret-id>
are the values for the keys that you generated in steps 7 - 10.s3://<bucket-name>/<path>/export_date_=2025-05-29/
WHERE
clause uses: