Executes SQL code in a Firebolt database

View on GitHub

Last Updated: Feb. 1, 2023

Access Instructions

Install the Firebolt provider package into your Airflow environment.

Import the module into your DAG file and instantiate it with your desired params.


firebolt_conn_idstrFirebolt connection id
sqlCan receive a str representing a sql statement, a list of str (sql statements), or reference to a template file. Template reference are recognized by str ending in ‘.sql’the sql code to be executed. (templated)
autocommitboolif True, each command is automatically committed. Currently firebolt doesn’t support autocommit feature. (default value: False)
parametersdict or iterable(optional) the parameters to render the SQL query with.
databasestrname of database (will overwrite database defined in connection)
engine_namestrname of engine (will overwrite engine_name defined in connection)


Executes SQL code in a Firebolt database

Was this page helpful?