SqliteOperator

SQLite

Executes sql code in a specific Sqlite database

View on GitHub

Last Updated: May. 7, 2021

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

sqlRequiredstr or list[str]the 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_idstrreference to a specific sqlite database
parametersdict or iterable(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?