Tableau supported data sources
Tableau is business intelligence software that can integrate with various data sources. When you ingest Tableau metadata, Collibra Data Lineage tries to automatically stitch the metadata to data sources registered in Data Catalog. It also creates a technical lineage that shows where metadata is used and how it transforms.
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.
- 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.
Tip For stitching, you must correctly prepare the Data Catalog physical data layer.
|
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 |
| 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 |
|
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 |