SqlTask supports all databases that have a SqlAlchemy dialect and driver. The following engines have dedicated support for the following insert modes:
+-------------+--------+----------+------+----------+ | | | Insert mode | | + +--------+----------+------+----------+ | Database | 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.