Configuring your Snowflake Account as a Data Destination
In this article
Overview
You can configure a new Snowflake account in Fast Data Loader (FDL) by using the user credentials from your existing account in Snowflake.
Prerequisites
Login credentials and access to the Snowflake account. Contact your administrator, if you do not have access or settings details.
For more information on the Snowflake account configuration, see Snowflake documentation.
To know more about Snowflake, see Snowflake documentation.Access to Snowflake Snap Pack in SnapLogic’s Intelligence Integration Platform.
Supported Version
The Fast Data Loader is tested and supported against the JDBC jar version 3.12.3 and may be compatible with later versions.
Account Settings
Parameter Name | Data Type | Description | Example |
---|---|---|---|
Create new connection tag | String | Required. Enter a name that will help identify your Oracle account in FDL. | FDL_SW_Account |
Host name | String | Required. Enter the hostname of the Snowflake database to connect. | 54.98.196.248 |
Port Number | String | Required. Enter the Port Number of the Snowflake database server to which the application should connect. | 443 |
Username | String | Required. Enter the username that you have configured for your Snowflake account. The username must be valid to set up the destination endpoint. | FDL_Snowflake_User |
Password | String | Required. Enter The password used to connect to the destination endpoint. | N/A |
Database name | String | Required. Enter the database name to which the application must connect. | MYDB |
Warehouse name | String | Required. Enter the warehouse name into which you want to load your data. | Sw_Sales_data_wh |
Salesforce to Snowflake Integration might fail while loading complex data types.
Troubleshooting
You might encounter the following errors when you validate and save your integration:
Error | Reason | Resolution |
---|---|---|
Asset conflict error. | You cannot have another account in FDL with the same name. If you enter the existing account name, the Asset conflict error message is displayed. | Ensure that the account name is unique. You can click Overwrite to overwrite the existing account with the new one, or click Cancel and enter a unique name for your account. |
Failed to validate account. | You might have entered invalid username and password. Multiple attempts with invalid credentials may lock your account. | Ensure that you enter valid Snowflake account credentials. |
Contact FDL customer support at fdl-support@snaplogic.com for further assistance.
What to do next: Set up and Verify your integration, see https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2006486040.
See Also
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2006486040
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1942159838
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.