Skip to main content
Feedback

Setting up Firebolt as a target

info

This connector is currently in Alpha Stage.

Overview

Getting started with Data Integration and Firebolt:

This guide will show you how to create an S3 bucket for Firebolt external tables while also setting the required credentials for using Firebolt with Data Integration.

Before you use this guide, ensure you have a valid Firebolt account.

If you don't have any valid Firebolt account, create one here.

Create a Firebolt connection

Next, setup Data Integration for use with Firebolt.

  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.

  1. Now, enter the credentials information that you’ve 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've 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 don't select an engine Data Integration will try to run on the default engine set for the database you've chosen

    warning

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

  2. (Optional) Set your custom file zone to save the data in your own S3 bucket.

  3. You can test your connection by clicking the Test Connection.

  4. 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 current Firebolt design and in order to ensure maximum data availability, loading times can be delayed on average 5 minutes when working with small files. This behavior would be improved soon by Firebolt.

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

On this Page