JDBC Catalog
Fields
JDBCSchema
Examples
MySQL
{
"name": "jdbc_mysql",
"type": "mysql",
"jdbc": {
"username": "<username>",
"password": "<password>",
"jdbcUri": "jdbc:mysql://<host>",
"driverClass": "com.mysql.cj.jdbc.Driver",
"driverUrl": "https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.28/mysql-connector-java-8.0.28.jar"
}
}
PostgreSQL
{
"name": "jdbc_postgres",
"type": "postgresql",
"jdbc": {
"username": "<username>",
"password": "<password>",
"jdbcUri": "jdbc:postgresql://<host>/postgres",
"driverClass": "org.postgresql.Driver",
"driverUrl": "https://repo1.maven.org/maven2/org/postgresql/postgresql/42.3.3/postgresql-42.3.3.jar"
}
}
DuckDB
{
"name": "jdbc_duckdb",
"type": "duckdb",
"jdbc": {
"jdbcUri": "jdbc:duckdb:/home/share/test.db",
"driverClass": "org.duckdb.DuckDBDriver",
"driverUrl": "https://repo1.maven.org/maven2/org/duckdb/duckdb_jdbc/0.9.1/duckdb_jdbc-0.9.1.jar"
}
}
BigQuery
{
"name": "jdbc_bigquery",
"type": "bigquery",
"jdbc": {
"jdbcUri": "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=pjid;OAuthType=0;OAuthServiceAcctEmail=sa@pjid.iam.gserviceaccount.com;OAuthPvtKeyPath=/temp/pjid.json;EnableSession=1;",
"driverClass": "com.simba.googlebigquery.jdbc.Driver"
}
}
Redshift
{
"name": "jdbc_redshift",
"type": "redshift",
"jdbc": {
"username": "<username>",
"password": "<password>",
"jdbcUri": "jdbc:redshift://[host]:[port]/[db_name]",
"driverClass": "com.amazon.redshift.Driver"
}
}
Last updated