Skip to content

Database Connectors Cloud Databases

Jump to bottom
Ephrim Stanley edited this page Oct 7, 2022 · 1 revision

Support for various cloud databases/dataservices is being gradually added to Legend.

Supported Databases

GCP / BigQuery

Legend can connect to BigQuery using GCP Application Default Credentials.

Usage Notes

  • 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.

AWS / Redshift

Legend can connect to Redshift using a user/password sourced from a "credential" vault.

Usage Notes

  • The Redshift connector does not use SSL as yet. This will be added in a subsequent release.

Databricks

Legend can connect to Databricks using an API token.

Usage Notes

  • Legend uses the Simba JDBC Driver which is not open source. Legend users will have to include this driver in the CLASSPATH at runtime.

Snowflake

Legend can connect to Snowflake using a private keys sourced from a "credential" vault.

Supported Features

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 :

Clone this wiki locally