Drivers

Supported drivers.

To use another JDBC driver, add the driver’s JAR to atoti.Session()’s extra_jars parameter.

For instance JARs to connect to Google BigQuery can be found on BigQuery documentation. Once added to the extra JARs, driver="com.simba.googlebigquery.jdbc.Driver" can be used.

atoti_sql.drivers.H2 = 'org.h2.Driver'

H2 driver.

atoti_sql.drivers.IBM_DB2 = 'com.ibm.db2.jcc.DB2Driver'

IBM DB2 driver.

atoti_sql.drivers.MARIADB = 'org.mariadb.jdbc.Driver'

MariaDB driver.

atoti_sql.drivers.MICROSOFT_SQL_SERVER = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'

Microsoft SQL Server driver.

atoti_sql.drivers.MYSQL = 'com.mysql.cj.jdbc.Driver'

MySQL driver.

atoti_sql.drivers.ORACLE = 'oracle.jdbc.OracleDriver'

Oracle driver.

atoti_sql.drivers.POSTGRESQL = 'org.postgresql.Driver'

PostgreSQL driver.