Tableau - Lineage

This article outlines the lineage coverage, configuration requirements, supported components, transformation support, supported use cases, partial or limited coverage, unsupported scenarios, and current functional status for lineage extraction in Tableau.

The Tableau connector provides automated lineage extraction across Tableau Workbooks, Dashboards, Worksheets, Datasources, and source systems. It provides end-to-end visibility from source tables, files, and SQL queries through Tableau Datasources and Workbooks to Worksheets, Dashboards, and other visualizations. The connector also supports column-level lineage and calculated-field lineage to provide visibility into data flow and supported transformations.

Lineage Configuration Requirements

Successful lineage extraction depends on access to Tableau Workbook metadata and the availability of source metadata in OvalEdge. The following requirements apply to Tableau lineage extraction.

Configuration Requirements Table

Configuration	Required Detail
Tableau Workbook XML	Access to Tableau Workbook XML files stored in the SourceCode table is required for lineage extraction.
Source Database Metadata	Source databases must be crawled in OvalEdge before lineage is built so that source tables and columns can be matched with Tableau metadata.
Source Column Metadata	Source table and column metadata must be available for column-level lineage and source-to-target matching.
SQL Metadata	SQL definitions available in Tableau Workbook metadata must be accessible for SQL parsing and lineage mapping.
File Datasource Metadata	Excel and CSV datasource metadata must be available for file-to-worksheet lineage where applicable.

Missing Tableau Workbook XML, unavailable source metadata, or incomplete source table and column metadata may result in incomplete lineage generation or unresolved source-to-Tableau relationships.

Lineage Components

The following table identifies the Tableau components and lineage features supported by the connector.

Component / Feature	Supported
Workbooks	✅
Dashboards	✅
Worksheets / Views	✅
Datasources	✅
Direct Table Connections	✅
Custom SQL Queries	✅
Calculated Fields	✅
Nested Calculations	✅
File Datasources (Excel/CSV)	✅
Columns (Direct Mapping)	✅
Column Metadata Mapping	✅
Story Points	✅
Chart-to-Chart Lineage	✅
Table-to-Chart Lineage	✅
Column-to-Column Lineage	✅
File-to-Chart Lineage	✅
Multi-Connection Filtering	✅
Hyper Datasources	⚠️
SQL Proxy Connections	⚠️
Parameters	⚠️
Context Filters	⚠️
Level of Detail (LOD) Expressions	⚠️
Relationships	⚠️
Hierarchies	⚠️
Extract Datasources	❌

The ⚠️ icon indicates partially supported functionality where lineage coverage depends on metadata availability, calculation complexity, connection configuration, or the specific Tableau implementation.

Column Creation Support

This section outlines lineage support for columns created through expressions, aggregations, calculated fields, renamed columns, SQL queries, and metadata mappings.

Column Creation from Lineage

Transformation Type	Supported
Expressions	✅
Aggregations	✅
Calculated Fields	✅
Renamed Columns	✅
Temp Columns (from SQL Queries)	✅
Semantic Columns (Metadata Mapped)	✅
Parameter-Driven Columns	⚠️
Extract Columns	❌

The ⚠️ icon indicates partial lineage coverage for parameter-driven columns. The resulting lineage depends on the availability of parameter and transformation metadata.

Supported Use Cases

The Tableau connector supports lineage extraction across Tableau Workbooks, Dashboards, Worksheets, Datasources, source tables, SQL queries, and supported file datasources.

Supported Lineage Scenarios

Supported Scenario	Details
Dashboard → Worksheet Lineage	Lineage between Tableau Dashboards and associated Worksheets or Views.
Chart → ChartChild Lineage	Lineage across Dashboard and Worksheet child relationships represented through the Tableau reporting hierarchy.
Datasource Table → Worksheet Lineage	Lineage from source tables referenced by Tableau Datasources to Worksheets.
Datasource → Dashboard Lineage	Lineage from Tableau Datasources through Worksheets to Dashboards.
Workbook SQL Lineage	SQL parsing and mapping from SQL definitions available in Tableau Workbook metadata.
Extract / Published Datasource → Workbook Lineage	Lineage from supported Extract or Published Datasource references to Tableau Workbooks where the required metadata is available.
CSV / Excel File → Worksheet Lineage	Lineage from supported CSV and Excel file datasources to Tableau Worksheets.
Column Rename Lineage	Lineage for columns that are renamed within supported Tableau transformations.
Column Calculation Lineage	Lineage for calculated columns and supported calculation expressions.
Column Aggregation Lineage	Lineage for supported aggregation transformations.
Datasource Field → Worksheet Field Lineage	Column-level lineage from Tableau Datasource fields to corresponding Worksheet fields.
Table-to-Chart Lineage	Lineage from source tables to Tableau charts or visualizations.
Column-to-Column Lineage	Lineage between source columns and corresponding Tableau fields.
File-to-Chart Lineage	Lineage from supported Excel and CSV file sources through Tableau objects to charts.

Lineage extraction depends on Tableau Workbook XML metadata, available source metadata, SQL parsing, and the ability to match Tableau fields with crawled source tables and columns.

Partial or Limited Coverage

Certain Tableau scenarios provide partial lineage coverage because calculation complexity, runtime parameters, multiple source relationships, or datasource metadata can limit the ability to resolve complete lineage.

Scenarios

Scenario	Limitation Description	Recommendation / Workaround
Complex Calculated Fields	Complex or nested calculations, particularly calculations that use LOD expressions, may not fully resolve into individual lineage relationships.	Validate lineage manually for complex calculated fields where detailed transformation-level lineage is required.
Aggregations	Functions such as SUM, COUNT, and AVG may not always be captured as distinct transformation steps in the lineage flow.	Validate aggregation logic manually where expression-level lineage is required.
Blended Data Sources	Lineage visibility is limited across multiple joined or blended data sources.	Validate relationships across blended sources manually where required.
Dynamic Parameters	Parameter-driven filters and calculations may not be fully resolved during lineage extraction.	Validate parameter-dependent lineage manually where required.
Custom SQL	Complex or multi-query Custom SQL statements may provide partial parsing and lineage mapping.	Use supported SQL structures where possible and validate complex SQL lineage manually.
Published Datasources	Backtracking from Published Datasources to the original physical data sources may be limited.	Validate physical source dependencies separately where complete backtracking is required.
Extract Connections	Incremental refresh lineage may not appear in the resulting lineage relationships.	Validate extract refresh dependencies separately where required.
Derived Worksheets or Dashboards	Dataset lineage status may indicate incomplete lineage for Worksheets or Dashboards derived from complex datasource relationships.	Review affected lineage paths and validate derived dependencies manually.
Hyper Datasources	Lineage coverage is partial for Hyper Datasources.	Validate Hyper datasource dependencies manually where complete lineage is required.
SQL Proxy Connections	Lineage resolution may be limited for SQL Proxy Connections.	Ensure the required source metadata is available and validate affected lineage paths manually.
Context Filters	Context filter dependencies may not be fully represented in lineage.	Validate filter dependencies separately where required.
Relationships	Tableau relationships may not provide complete relationship-level lineage coverage.	Validate source relationships manually where detailed relationship lineage is required.
Hierarchies	Hierarchy dependencies may not be fully represented in lineage.	Validate hierarchy relationships separately where required.

Complex calculations, LOD expressions, dynamic parameters, blended data sources, complex Custom SQL, Published Datasources, Extract Connections, and incomplete source metadata may reduce lineage completeness and column-level accuracy.

Unsupported Scenarios

The connector does not support lineage extraction for certain Tableau scenarios that require runtime resolution, unsupported source metadata, or transformation details that are not available through the supported lineage extraction process.

Unsupported Lineage

Not Supported	Description	Recommendation / Workaround
Cross-database Joins and Federated Queries	Lineage cannot be fully resolved for cross-database joins and federated query scenarios.	Validate cross-database dependencies manually where required.
Hierarchies within Dashboards or Workbooks	Hierarchy-level dependencies are not fully supported for lineage extraction.	Validate hierarchy relationships separately where required.
Filter-only Fields Not Visualized	Fields used only for filtering and not represented in visualized output are not fully captured as lineage relationships.	Review filter dependencies separately where required.
Dynamic Parameters and Context Filters	Dynamic parameter and context-filter dependencies are not resolved as complete lineage relationships.	Validate parameter and filter dependencies manually.
Cross-dashboard Dependencies	Dependencies that span dashboards are not fully supported for lineage extraction.	Document or validate cross-dashboard dependencies separately where required.
Custom SQL with Nested or Procedural Logic	Custom SQL containing nested or procedural logic cannot be fully parsed for lineage extraction.	Simplify SQL where possible or validate the affected lineage manually.
Tableau Prep Flow Lineage Beyond Published Datasources	Lineage for Tableau Prep flows beyond published datasources is not supported.	Validate Tableau Prep dependencies separately where required.
Non-SQL Sources	Sources such as Google Sheets and Web Data Connectors are not supported for complete lineage extraction.	Use supported source connections or document affected lineage manually.
Extract Datasources	Extract Datasources are not supported for complete lineage extraction.	Validate extract dependencies separately where required.
Extract Columns	Columns created or represented within unsupported Extract Datasources are not supported for lineage creation.	Validate extract column dependencies manually where required.

Unsupported scenarios do not generate complete lineage and may result in missing or disconnected lineage relationships within lineage visualization.

Current Functional Status

This section outlines the current lineage capabilities and coverage of the Tableau connector.

Status Area	Details
Overall Coverage	Intermediate coverage across Tableau Workbooks, Dashboards, Worksheets, Datasources, source tables, SQL queries, and supported file datasources.
Lineage Depth	Table-level, chart-level, and column-level lineage across supported Tableau components and source connections.
Supported Inputs	Workbooks, Dashboards, Worksheets / Views, Datasources, direct table connections, Custom SQL Queries, calculated fields, supported Excel and CSV file datasources, and related Tableau metadata.
Functional Scope	End-to-end lineage from supported source systems and queries through Tableau Datasources and Workbooks to Worksheets and Dashboards, including column-level tracing.
Transformation Support	Expressions, aggregations, calculated fields, renamed columns, temporary columns from SQL queries, and metadata-mapped semantic columns are supported.
Limitation Areas	Complex calculated fields, nested calculations, LOD expressions, dynamic parameters, context filters, blended data sources, complex Custom SQL, Published Datasources, Extract Connections, Hyper Datasources, SQL Proxy Connections, relationships, and hierarchies have partial or unsupported coverage.
Resulting Output	Extensive lineage coverage across standard Tableau reporting and datasource scenarios, with column-level tracing and SQL parsing. Advanced scenarios involving complex calculations, dynamic parameters, non-SQL sources, cross-database relationships, and unsupported Extract Datasources may require manual validation.

The Tableau connector provides extensive lineage coverage across Workbooks, Dashboards, Worksheets, Datasources, direct table connections, Custom SQL Queries, supported file datasources, and column-level relationships. The connector supports calculated fields, nested calculations, expressions, aggregations, renamed columns, and metadata-mapped semantic columns. Advanced scenarios involving complex calculations, LOD expressions, dynamic parameters, context filters, blended data sources, cross-database joins, complex Custom SQL, Tableau Prep flows, non-SQL sources, and Extract Datasources have partial or unsupported coverage and may require manual validation.

---

Copyright © 2026, OvalEdge LLC, Peachtree Corners GA USA