Snowflake is a highly reliable and highly available cloud data warehouse. Now, with Smart Ingest, you can bring your data from Snowflake into Iterable.
NOTE
Contact your Iterable customer success manager to discuss adding Smart Ingest to your plan.
Smart Ingest can only import data from Snowflake. To export your Iterable data to Snowflake, Iterable has a separate integration available.
In this article
Connection requirements
You need your Snowflake account information to connect Smart Ingest to Iterable.
-
Snowflake account details:
- Account identifier (help from Snowflake)—Note that this is not the same as the URL to your Snowflake account, but it is contained in the URL.
- Warehouse name
- Database name
-
Snowflake user credentials:
- Username
- Role (optional)
- Password or RSA key pair (whichever applies)
- Minimum user permissions vary depending on your sync engine (learn more)
Connecting Snowflake to Smart Ingest
To connect Snowflake to Smart Ingest:
Log in to Iterable as a user with the Manage Integrations project permission and open the project you’re working on.
Go to Integrations > Smart Ingest.
Click Connect a New Source.
Select Snowflake, then click Continue.
In Step 1, enter your connection details: Account identifier, Warehouse name, and Database name
-
In Step 2, choose from the Lightning or Basic sync engine. Lightning is faster and more efficient, but requires the database user to have write access. Basic is slower and less efficient, but doesn’t require write access.
To view the additional permissions required for the database user, select the Lightning sync engine. These permissions are necessary for Smart Ingest to create and manage the sync schema, and are customized based on the other inputs you provide in the source setup form.
To learn more about sync engines, read Optimizing Smart Ingest Sync Performance.
NOTE
Smart Ingest is co-developed by Iterable and Hightouch. Hightouch is a data processor for this feature. Smart Ingest data operations and schemas may contain the Hightouch name, but the feature is fully supported by Iterable.
In Step 3, enter your Snowflake user credentials: Username, Role (optional), andPassword or RSA key pair (whichever applies)
Click Continue. Smart Ingest will automatically test the connection.
When the connection test is successful, click Continue. (If there are problems connecting, click Back and review the connection details for accuracy.)
Add a name for your data source. This is for display in Iterable.
Click Finish.
Next steps
You've now connected your data warehouse to Smart Ingest. The next thing you can do is create a sync.
Troubleshooting Snowflake
Connection timeout
When initially testing your connection, you may receive a connection timeout error. Once a connection is established, subsequent API requests should happen more quickly, so it's best to retry the tests if they fail the first time. You can do this by clicking Test Again.
Network error: Could not reach Snowflake
You may receive this error if the input for Account Identifier is invalid.
Instead of using the complete Snowflake URL, for example,
https://<YOUR-ACCOUNT-IDENTIFIER>.snowflakecomputing.com
, ensure that you're
only using the account identifier portion of the URL. For example,
companyname-xu12345
or companyname-xu12345.us-east-1
.