How to connect and sync Snowflake tables to Airfold
Sources
and click on Create new Source
. Alternatively, click on the +
next to Sources
in the left-hand tool bar.
Snowflake
Account
field requires the following format:
<your_account_id>.<your-snowflake-region>.<your_cloud_provider>
(e.g., lh10221.us-central1.gcp)
Run the following query in a Snowflake SQL worksheet to generate the correct account string:
Account
would be `gu81828.us-east-2.aws’
Username
This is the username that you use to log in to your Snowflake account. You can obtain this by running the following query:
COMPUTE_WH
PUBLIC
Source
for each table and then join the data using a downstream Pipe
.
Role
and a User
and then grant permissions for those new resources to the database that you are syncing data from.
Mark as Done
checkbox and then Next
.
Engine
type and the Primary Key
, are critical for optimal query performance - Take care at this stage to ensure your Source is optimally configured.