atoti_sql.drivers module¶
Supported SQL 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.