Supported Engines¶
SqlTask supports all databases that have a SqlAlchemy dialect and driver. The following engines have dedicated support for the following insert modes:
Database |
Insert mode |
|||
|---|---|---|---|---|
Single |
Multirow |
CSV |
Parquet |
|
BigQuery |
Yes |
Yes |
Yes |
|
Postgres |
Yes |
Yes |
Yes |
|
Snowflake |
Yes |
Yes |
Yes |
|
Sql Server |
Yes |
Yes |
||
Sqlite |
Yes |
Yes |
||
Engines not listed above will default to using multirow inserts if supported, falling back to single row inserts as a last resort.