Advanced Analytica Advanced Analytica: IBOM
← All connectors
Firebolt logo

Source connector

Firebolt

Set up Firebolt as a source and move its data into your chosen destination.

Version 2.0.39 community alpha

Firebolt

Overview

Sync your data from Firebolt with the Firebolt source. It currently supports Full refresh only.

The connector uses a pure Python firebolt-sdk and requires no additional dependencies.

Resulting schema

The Firebolt source preserves your database schema. However, the connected destination may alter the resulting schema. See the destination’s documentation for details.

Features

FeatureSupported?(Yes/No)Notes
Full Refresh SyncYes
Incremental - Append SyncNo

Get started

Requirements

  1. An existing AWS account

Set up Firebolt

  1. Sign up for Firebolt by following the guide.

  2. Follow the getting started tutorial to set up a database.

  3. Create a service account.

  4. Load data.

Check your setup

You should now have:

  1. An existing Firebolt account
  2. Your connection parameters ready
    1. Service account id
    2. Service account password
    3. Account name
    4. Host (Optional)
    5. Engine (Optional)
  3. A running engine. You can’t connect while an engine is stopped or starting.
  4. Your data in either Fact or Dimension tables.

You can now use the Airbyte Firebolt source.

IP allow list

If you use Airbyte Cloud and restrict access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Changelog

Expand to review
VersionDatePull RequestSubject
2.0.392025-10-1468068Update dependencies
2.0.382025-10-0767315Update dependencies
2.0.372025-09-3066779Update dependencies
2.0.362025-09-2466165Update dependencies
2.0.352025-09-0965804Update dependencies
2.0.342025-08-2365289Update dependencies
2.0.332025-08-1665019Update dependencies
2.0.322025-08-0964742Update dependencies
2.0.312025-08-0264374Update dependencies
2.0.302025-07-2663969Update dependencies
2.0.292025-07-1963563Update dependencies
2.0.282025-07-1262984Update dependencies
2.0.272025-07-0562754Update dependencies
2.0.262025-06-2862434Update dependencies
2.0.252025-06-2248657Update dependencies
2.0.242024-11-0448154Update dependencies
2.0.232024-10-2847109Update dependencies
2.0.222024-10-1246826Update dependencies
2.0.212024-10-0546471Update dependencies
2.0.202024-09-2846210Update dependencies
2.0.192024-09-2145765Update dependencies
2.0.182024-09-1445572Update dependencies
2.0.172024-09-0745211Update dependencies
2.0.162024-08-3145030Update dependencies
2.0.152024-08-2444715Update dependencies
2.0.142024-08-1744212Update dependencies
2.0.132024-08-1243774Update dependencies
2.0.122024-08-1043535Update dependencies
2.0.112024-08-0343268Update dependencies
2.0.102024-07-2042159Update dependencies
2.0.92024-07-1341744Update dependencies
2.0.82024-07-1041575Update dependencies
2.0.72024-07-0941151Update dependencies
2.0.62024-07-0640979Update dependencies
2.0.52024-06-2540438Update dependencies
2.0.42024-06-2240199Update dependencies
2.0.32024-06-0639183[autopull] Upgrade base image to v1.2.2
2.0.22024-06-0338892Replace AirbyteLogger with logging.Logger
2.0.12024-06-0338892Replace AirbyteLogger with logging.Logger
2.0.02024-06-0136349Service account authentication support
1.0.02023-07-2021842PGDate, TimestampTZ, TimestampNTZ and Boolean column support
0.2.12022-05-1025965Fix DATETIME conversion to Airbyte date-time type
0.2.02022-09-0916583Reading from views
0.1.02022-04-2813874Create Firebolt source
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.