A full script can be found at the bottom of this page.It is best practice to create a separate role for the Datafold integration (e.g.,
DATAFOLDROLE
):
Note: More results may be returned than shown in the screenshots below if you have granted access to multiple roles/usersExample Placeholders:
<database_name>
= DEV
<warehouse_name>
= DEMO
Field Name | Description |
---|---|
Name | A name given to the data connection within Datafold |
Account identifier | The Org name-Account name pair for your Snowflake account. This can be found in the browser address string. It may look like https://orgname-accountname.snowflakecomputing.com or https://app.snowflake.com/orgname/accountname. In the setup form, enter <orgname>-<accountname>. |
User | The username set in the Setup password-based authentication section |
Password | The password set in the Setup password-based authentication section |
Key Pair file | The key file generated in the Use key-pair authentication section |
Warehouse | The Snowflake warehouse name |
Schema for temporary tables | The schema name you created with our script (<database_name>.DATAFOLD_TMP) |
Role | The role you created for Datafold (Typically DATAFOLDROLE) |
Default DB | A database the role above can access. If more than one database was added, whichever you prefer to be the default |
Note: Please review the documentation for the account name. Datafold uses Format 1 (Preferred): https://docs.snowflake.com/en/user-guide/admin-account-identifier#using-an-account-locator-as-an-identifierClick Create. Your data connection is ready!