Overview¶

The following database engines are supported:

Function support matrix¶

Shows which functions are supported with which database engine:

Configuration class	Querying	Write STDOUT	Read STDIN	DB-API 2.0	UI schema support
PostgreSQLDB	Yes	Yes	Yes	Yes	Yes
RedshiftDB	Yes	Yes	Yes	Yes	Yes
BigQueryDB	Yes	Yes	Yes	Yes	no foreign key support by engine
DatabricksDB	Yes	Yes	-	Yes
MysqlDB	Yes	Yes	-	Yes	Yes
SQLServerDB	Yes	Yes	Yes	Yes	Yes
OracleDB	Yes	Yes	-	-
SnowflakeDB	Yes	Yes	-	-
SQLiteDB	Yes	Yes	-	Yes

Write STDOUT gives the possibility to write a query to STDOUT

Read STDIN gives the possiblity to read a file to a predefined SQL table

Shows the formats supported per database engine

Configuration class	CSV	JsonL	Avro	Parquet	ORC
PostgreSQLDB	Yes	Yes	-	-	-
RedshiftDB	Yes	Yes	-	-	-
BigQueryDB	Yes	Yes	Yes	Yes	Yes
SQLServerDB	Yes	-	-	-	-

Configuration class	CSV	JsonL	Avro	Parquet	ORC
PostgreSQLDB	Yes	-	-	-	-
RedshiftDB	Yes	-	-	-	-
BigQueryDB	Yes	-	-	-	-
DatabricksDB	Yes	-	-	-	-
MysqlDB	Yes	-	-	-	-
SQLServerDB	Yes	-	-	-	-
OracleDB	Yes	-	-	-	-
SnowflakeDB	Yes	-	-	-	-
SQLiteDB	Yes	-	-	-	-

Shows which copy operations are implemented by default.

from / to	PostgreSQLDB	RedshiftDB	BigQueryDB	DatabricksDB	MysqlDB	SQLServerDB	OracleDB	SnowflakeDB	SQLiteDB
PostgreSQLDB	Yes	Yes	Yes	-	-	-	-	-	-
RedshiftDB	Yes	Yes	Yes	-	-	-	-	-	-
BigQueryDB	Yes	Yes	-	-	-	-	-	-	-
DatabricksDB	-	-	-	-	-	-	-	-	-
MysqlDB	Yes	Yes	Yes	-	-	-	-	-	-
SQLServerDB	Yes	Yes	Yes	-	-	-	-	-	-
OracleDB	Yes	Yes	Yes	-	-	-	-	-	-
SnowflakeDB	-	-	-	-	-	-	-	-	-
SQLiteDB	Yes	Yes	Yes	-	-	-	-	-	-