Queries logged in your data source that originate from Data Notebook include comments for distinction. The comments contain the following information:
- ApplicationName: This is always Collibra (Data Notebook).
- Action: Action performed in Data Notebook. This can be one of the following:
- 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: User ID of the Collibra user who ran the query.
The following table serves as a compatibility chart, containing the data sources supported by Data Notebook, along with the drivers and the authentication methods they support.
| Data source (target) | Supported driver | Service account | Personal credentials | SAML/OAuth flow |
|---|---|---|---|---|
| Amazon Athena (beta) | cdata.jdbc.amazonathena.AmazonAthenaDriver | Yes | Yes | Not planned |
| BigQuery | cdata.jdbc.googlebigquery.GoogleBigQueryDriver | Yes | Not applicable | Yes, Google SSO |
| Databricks | com.databricks.client.jdbc.Driver | Yes | Yes | Yes, Microsoft Entra ID |
|
Microsoft SQL Server |
cdata.jdbc.sql.SQLDriver com.microsoft.sqlserver.jdbc.SQLServerDriver |
Yes | Yes |
Not planned |
| Oracle |
oracle.jdbc.OracleDriver oracle.jdbc.driver.OracleDriver |
Yes | Yes |
Not planned |
| PostgreSQL |
cdata.jdbc.postgresql.PostgreSQLDriver org.postgresql.Drive |
Yes | Yes |
Not planned |
| Redshift | cdata.jdbc.redshift.RedshiftDriver | Yes | Yes | Not planned |
| Snowflake | net.snowflake.client.jdbc.SnowflakeDriver | Yes | Yes |
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 |
Yes | 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, you can add an idea on the Collibra Ideation Platform.