Firebolt

Firebolt is a cloud-based data storage and analytics service built over AWS that you can set up as a Destination in Hevo.

Databases in Firebolt are attached with computing resources called engines that provide isolated, assured compute and storage capacity for different workloads and queries. These engines help you run perform SQL queries on your data.

You can attach any number of engines to a database. Read Engines for more information. The cost of each engine varies according to your selected configurations.

The ingested data from your Hevo Pipeline is first staged in your Amazon S3 Bucket and then transferred to your Firebolt database.


Destination Considerations

  • Tables once created in the Firebolt database cannot be altered. This means that you cannot add or remove columns, as Firebolt does not currently support this. You must drop the table from the Schema Mapper page or the Workbench page and create a new one.

  • If performance optimization configurations such as indexes, table types, partition keys, and non-nullable columns are not set according to your query patterns, the queries will be inefficient, and you will have to drop and create the tables again with correct configurations.

  • Partition definition occurs during table creation. Check the queries you plan to run on your data, in particular, the WHERE clauses. Make sure that either the table’s primary index or primary key includes the created partitions to enjoy maximum data pruning.

  • The partition key cannot be composed of nullable columns.

  • Currently, Firebolt only supports Append-Only queries. Due to this, the Pipeline does not deduplicate the Events.



See Also


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Sep-08-2021 1.71 New document.
Last updated on 28 Oct 2022

Tell us what went wrong