Smart Ingest lets you pull data stored in Firebolt into Iterable for use in campaigns and workflows.
NOTE
Contact your Iterable customer success manager to discuss adding Smart Ingest to your plan.
Smart Ingest can only import data from Firebolt.
In this article
Connection requirements
Before you can connect Smart Ingest to Firebolt, you need to do the following:
Allowing Smart Ingest IPs in Firebolt
Before you connect Smart Ingest to Firebolt, make sure to allow Smart Ingest IPs in your server.
Firebolt connection details
To connect with Smart Ingest, you need the following items from Firebolt:
Username - This can be your personal Firebolt login, or a dedicated user for Smart Ingest. The user should, at minimum, have permission to read the tables you want to sync.
Password - The password for the user specified above.
Database - The name of the database you want to sync.
Engine - The Firebolt engine you want to use. This can be either a general purpose engine, or an analytics engine.
Warming up the connection
When you connect to Firebolt, you can choose to start the Firebolt engine before Smart Ingest begins executing queries. This can result in faster query performance.
To do this, select Automatically Start the Engine Before Executing Queries in the Smart Ingest connection settings.
Connecting Firebolt to Smart Ingest
To connect your Firebolt server 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 Firebolt and click Continue.
-
Enter your connection details:
- Username
- Password
- Database
- Engine
(Optional) Select whether to Automatically Start the Engine Before Executing Queries.
Click Continue. Smart Ingest automatically tests the connection.
-
When the connection test is successful, click Continue.
If there are problems connecting, click Back and review the connection details for accuracy, then try again.
Add a name for your data source. This is for display in Iterable.
Click Finish.
Next steps
You've now connected Firebolt to Smart Ingest. The next thing you can do is create a sync.