Database Connectors Cloud Databases
Ephrim Stanley edited this page Oct 7, 2022
·
1 revision
Support for various cloud databases/dataservices is being gradually added to Legend.
Legend can connect to BigQuery using GCP Application Default Credentials.
- The use of GCP Application Default Credentials requires that the Legend server (or code that uses Legend) runs in a GCP environment.
- Legend uses the Simba JDBC Driver which is not open source. Legend users will have to include this driver in the CLASSPATH at runtime.
Legend can connect to Redshift using a user/password sourced from a "credential" vault.
- The Redshift connector does not use SSL as yet. This will be added in a subsequent release.
Legend can connect to Databricks using an API token.
- Legend uses the Simba JDBC Driver which is not open source. Legend users will have to include this driver in the CLASSPATH at runtime.
Legend can connect to Snowflake using a private keys sourced from a "credential" vault.
Not all Legend features are supported on all the supported databases. This is due to differences in SQL dialects, features supported by the database etc.
Consult the following dashboards for supported features :
- Connectivity / Authentication : https://github.com/finos/legend/wiki/Database-Integration-Tests-Dashboard
- Legend Database Feature Support : TODO - Coming soon (@pratekgarg-gs)
- For Legend Users
- For Legend Maintainers