Data sources

Data Notebook connects to your data through Edge connections. This topic lists the data sources, drivers, and authentication methods that Data Notebook supports, and explains how Data Notebook identifies its queries in your data source logs.

Supported data sources and drivers

The following table lists the data sources that Data Notebook supports, along with their supported drivers and authentication methods.

Data source (target) Supported driver Service account Personal credentials SAML/OAuth flow
Amazon Athena (in preview) cdata.jdbc.amazonathena.AmazonAthenaDriver Green check icon Yes Green check icon Yes Not planned
BigQuery cdata.jdbc.googlebigquery.GoogleBigQueryDriver Green check icon Yes Not applicable Green check icon Yes, Google SSO
Databricks com.databricks.client.jdbc.Driver Green check icon Yes Green check icon Yes Green check icon Yes, Microsoft Entra ID

Microsoft SQL Server

cdata.jdbc.sql.SQLDriver

com.microsoft.sqlserver.jdbc.SQLServerDriver

 Green check icon Yes Green check icon Yes

Not planned
Oracle

oracle.jdbc.OracleDriver

oracle.jdbc.driver.OracleDriver

 Green check icon Yes Green check icon Yes

Not planned
PostgreSQL

cdata.jdbc.postgresql.PostgreSQLDriver

org.postgresql.Drive

 Green check icon Yes Green check icon Yes

Not planned
Redshift cdata.jdbc.redshift.RedshiftDriver Green check icon Yes Green check icon Yes Not planned
Snowflake net.snowflake.client.jdbc.SnowflakeDriver Green check icon Yes Green check icon Yes

Green check icon Yes

Note You can't use the Snowflake OAuth authentication method when connecting from a virtual private cloud (VPC).
Teradata

cdata.jdbc.teradata.TeradataDriver

com.teradata.jdbc.TeraDriver

 Green check icon Yes Green check icon Yes Not planned

Note If you need a data source provider or driver that is not listed in the table, or if you need SAML/OAuth flow for a data source, add an idea on the Collibra Ideation Platform.

Query logging

Queries logged in your data source that originate from Data Notebook include comments for distinction. The comments contain the following information.

Comment field Description
ApplicationName

Identifies the originating application. This is always Collibra (Data Notebook).
Action

The action performed in Data Notebook.

  • ingest: Data source was synchronized. This is applicable to service accounts.
  • list-roles: Roles were listed. This is applicable to Snowflake using Snowflake authentication.
  • run-all-queries: All queries in a notebook were run at once.
  • run-query: Single query in a notebook was run.
ClientUser The user ID of the Collibra user who ran the query.