SqliteOperator

SQLite

Executes sql code in a specific Sqlite database

View on GitHub

Last Updated: Oct. 23, 2022

Access Instructions

Install the SQLite provider package into your Airflow environment.

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

Parameters

sqlthe sql code to be executed. Can 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’ (templated)
sqlite_conn_idreference to a specific sqlite database
parameters(optional) the parameters to render the SQL query with.

Documentation

Executes sql code in a specific Sqlite database

See also

For more information on how to use this operator, take a look at the guide: SqliteOperator

Was this page helpful?