The following table shows the supported data sources in Tableau that have been tested, and whether or not technical lineage and stitching is supported for the data source. We cannot guarantee that stitching works as expected for other data sources or versions.
- Live Connection and Extract are both supported.
- If you use custom SQL that is not supported by the Tableau metadata API, the technical lineage might not be complete. For complete information, see the Tableau documentation on Tableau Catalog support for custom SQL and Tableau Lineage and custom SQL connections.
- If you use stored procedures, lineage is shown between the Tableau Data Source and the Tableau Worksheet, but the database information is missing, so stitching cannot be achieved.
|
Data source |
Version |
Support for technical lineage |
Support for stitching |
|---|---|---|---|
|
Amazon Redshift |
1.2.34.1058 and newer |
Yes | Yes |
|
Azure SQL server |
Newest version |
Yes | Yes |
|
Azure SQL Data Warehouse |
Newest version |
Yes | Yes |
|
Azure Synapse Analytics |
Newest version |
Yes | Yes |
| Databricks | Newest version | Yes | Yes |
| Dremio | 20.0.0 | Yes | Yes |
| Google BigQuery |
Newest version |
Yes | Yes |
|
Greenplum |
6.10 and newer |
Yes | Yes |
|
HiveQL (SQL-like statements) |
2.3.5 and newer |
Yes | Yes |
|
IBM DB2 |
11.5 and newer |
Yes | Yes |
|
Oracle |
11g, 12c and newer |
Yes | Yes |
|
PostgreSQL |
9.4, 9.5 and newer |
Yes | Yes |
|
Microsoft SQL Server |
2014, 2016 and newer |
Yes | Yes |
|
MySQL |
5.7, 8 and newer |
Yes | Yes |
|
Netezza |
7.2.1.0 and newer |
Yes | Yes |
| Salesforce Data Cloud | Newest version | Yes |
Yes Important See the Salesforce section below this table for an important requirement. |
|
SAP HANA |
2.00.40 and newer |
Yes | Yes |
| Snowflake |
Newest version |
Yes | Yes |
|
Spark SQL |
2.4.3 and newer |
Yes | Yes |
|
Sybase Adaptive Server Enterprise |
16.0 SP02 and newer |
Yes | Yes |
|
Teradata |
15.0, 16.20.07.01 and newer |
Yes | Yes |
Salesforce Data Cloud requirement
The Tableau API does not automatically share the host name for Salesforce Data Cloud. Because this name is missing, there is nothing to match with the system name in Data Catalog, to achieve stitching. Collibra Data Lineage can generate lineage for Salesforce Data Cloud, but there is a specific technical step you must follow to achieve stitching.
In the Source configuration field in your Edge technical lineage capability, include a hostnameMapping section, as shown in the following example configuration. Use an asterisk (*) for found_hostname . This tells Collibra Data Lineage to ignore the missing name from Tableau and use your manual map instead.
"hostnameMapping": {
"found_dbname=databasename1;found_hostname=*;found_schema=test": {
"dbname": "mssql-database-name",
"schema": "mssql-schema-name",
"dialect": "mssql",
"collibraSystemName": "mssql-system-name"
}
}For Salesforce Data Cloud, extracts are also not returned by the Tableau APIs; only live connections.
For complete information, see the Salesforce documentation on connecting to Tableau in Data Cloud.