Setting up Firebolt as a target

info

This connector is currently in Alpha stage.

Create an S3 bucket for Firebolt external tables and set up the required credentials for using Firebolt with Data Integration.

Prerequisite

A valid Firebolt account. If you do not have a valid Firebolt account, create one.

Creating a Firebolt connection

1. Log into Data Integration.
2. Create a new connection for your Firebolt instance:
   • Go to Connections.
   • Select New Connection
   • From the source list, choose Firebolt.

3. Enter the credentials information that you created in Firebolt’s connection details:
   • Firebolt Username
   • Firebolt Password
   • The correct Engine name you want to run on,
   • The correct Database Name

warning

(Engine selection) Ensure the engine you selected is an ingestion/general-purpose engine and not an analytics engine, as Data Integration needs to read and write data to FIrebolt. If you do not select an engine Data Integration tries to run on the default engine set for the database chosen.

warning

(Database Region) If you are using Data Integration default file zone, ensure your database is located at us-east-2; other locations do not work. If you have an existing database that is not located at us-east-2, you should use the custom file zone instead.

4. (Optional) Set your custom file zone to save the data in your own S3 bucket.
5. You can test your connection by clicking the Test Connection.
6. Give your connection a name, and click Save.
   You can now pipe data to Firebolt by leveraging this connection in any river!

Known issues

• Due to the current Firebolt design and to ensure maximum data availability, loading times can be delayed on average by 5 minutes when working with small files. This behavior will be improved soon by Firebolt.

• Due to a temporary Firebolt behavior, using expressions in append mode is currently disabled; this behavior should be changed soon by Firebolt