> For the complete documentation index, see [llms.txt](https://docs.ovaledge.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ovaledge.com/release8.1/connectors/connector-repositories/reporting-tool/amazon-quicksight/amazon-quicksight-lineage.md).

# Amazon QuickSight - Lineage

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

The Amazon QuickSight connector provides end-to-end lineage across source databases and S3 files through QuickSight Datasets and Analyses to Dashboards, Sheets, and Visuals. The connector supports direct relational sources and Custom SQL datasets, with table-level, report-level, and column-level lineage relationships.

## Lineage Configuration Requirements

Successful lineage extraction depends on valid Amazon QuickSight API access, complete metadata, correctly configured source connections, and the availability of required lineage configuration properties. The following requirements apply to QuickSight lineage extraction.

### Configuration Requirements Table

<table data-search="false"><thead><tr><th width="241">Configuration</th><th>Required Detail</th></tr></thead><tbody><tr><td>Amazon QuickSight API Access</td><td>Valid Amazon QuickSight API credentials and Region must be available for metadata extraction.</td></tr><tr><td>QuickSight Metadata</td><td>Dashboard, Analysis, and Dataset metadata must be crawled before lineage is built.</td></tr><tr><td>Reference Database Connections</td><td>Reference database connections should be crawled so that source tables and columns can be resolved during lineage extraction.</td></tr><tr><td>SQL Dialects</td><td><code>supportingDialects</code> must be configured for Custom SQL parsing.</td></tr><tr><td>Connection Priority</td><td><code>connectionsPriorityForLineage</code> must be configured when the same table or schema exists across multiple source connections.</td></tr><tr><td>S3 Metadata</td><td>S3 datasets should include manifest or file-location/folder metadata to provide the most complete lineage coverage.</td></tr><tr><td>Dataset and Analysis References</td><td><code>dataSetId</code> and <code>analysisId</code> references in QuickSight metadata must match the corresponding crawled catalog objects.</td></tr></tbody></table>

{% hint style="warning" %}
Missing metadata, unavailable source connections, incomplete S3 file or folder metadata, invalid API credentials, or unmatched Dataset and Analysis references may result in incomplete lineage generation.
{% endhint %}

## Lineage Components

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

<table data-search="false"><thead><tr><th>Component / Feature</th><th align="center">Supported</th></tr></thead><tbody><tr><td>Dashboards</td><td align="center">✅</td></tr><tr><td>Analyses</td><td align="center">✅</td></tr><tr><td>Datasets</td><td align="center">✅</td></tr><tr><td>Sheets</td><td align="center">✅</td></tr><tr><td>Visuals / Child Reports</td><td align="center">✅</td></tr><tr><td><code>CUSTOM_SQL</code> Sources</td><td align="center">✅</td></tr><tr><td><code>RELATIONAL_TABLE</code> Sources</td><td align="center">✅</td></tr><tr><td><code>S3_SOURCE</code></td><td align="center">✅ / ⚠️</td></tr><tr><td>Table → Report Lineage</td><td align="center">✅</td></tr><tr><td>Report → Report Lineage</td><td align="center">✅</td></tr><tr><td>Column-level Lineage</td><td align="center">✅</td></tr><tr><td>Multi-Dataset Analysis</td><td align="center">✅</td></tr><tr><td>Cross-Dataset Join Semantics</td><td align="center">⚠️</td></tr><tr><td>Calculated / Derived Visual Fields</td><td align="center">⚠️</td></tr><tr><td>Dynamic SQL / Parameter-driven Queries</td><td align="center">❌ / ⚠️</td></tr></tbody></table>

{% hint style="info" %}
The ⚠️ icon indicates partially supported functionality where lineage coverage depends on metadata availability, transformation complexity, or the specific QuickSight configuration.
{% endhint %}

## Column Creation Support

This section outlines lineage support for columns created through direct source mappings, aliases, derived fields, expressions, and cross-dataset transformations.

### Column Creation from Lineage

<table data-search="false"><thead><tr><th>Transformation Type</th><th align="center">Supported</th></tr></thead><tbody><tr><td>Direct Relational Column → Report Column</td><td align="center">✅</td></tr><tr><td>Qualified Column Name Matching (<code>table.column</code> → <code>column</code>)</td><td align="center">✅</td></tr><tr><td>Custom SQL Alias Mapping</td><td align="center">✅</td></tr><tr><td>Derived / Calculated Fields</td><td align="center">⚠️</td></tr><tr><td>Visual-level Custom Expressions / Parameters</td><td align="center">❌</td></tr><tr><td>Cross-Dataset Derived / Join Columns</td><td align="center">⚠️ / ❌</td></tr></tbody></table>

{% hint style="info" %}
The ⚠️ icon indicates partial lineage coverage. The resulting lineage depends on the availability of transformation metadata and the complexity of the calculated, derived, or cross-dataset expression.
{% endhint %}

## Supported Use Cases

The Amazon QuickSight connector supports lineage extraction across QuickSight dashboards, analyses, datasets, reporting hierarchies, relational sources, Custom SQL sources, and supported S3 sources.

### Supported Lineage Scenarios

<table data-search="false"><thead><tr><th width="299">Supported Scenario</th><th>Details</th></tr></thead><tbody><tr><td>Source Table → Dataset → Analysis → Dashboard Lineage</td><td>End-to-end lineage from source tables through QuickSight datasets and analyses to dashboards.</td></tr><tr><td>Dashboard → Sheet → Visual Hierarchy</td><td>Lineage and reporting hierarchy across dashboards, sheets, and visuals.</td></tr><tr><td>Custom SQL Dataset Lineage</td><td>Lineage extraction from Custom SQL datasets using dialect-aware SQL parsing.</td></tr><tr><td>Direct Relational-table Dataset Lineage</td><td>Lineage from relational source tables to QuickSight datasets.</td></tr><tr><td>S3-source Lineage</td><td>Lineage from S3 sources when manifest, file-location, or folder metadata is available.</td></tr><tr><td>Multi-dataset Analyses</td><td>Lineage across analyses that reference multiple datasets.</td></tr><tr><td>Source-column → Report-column Matching</td><td>Automatic lineage based on matching source-column and report-column names.</td></tr><tr><td>Qualified Column Name Matching</td><td>Lineage resolution for qualified column names such as <code>table.column</code>.</td></tr><tr><td>Custom SQL Alias → Destination Column Mapping</td><td>Lineage between Custom SQL aliases and destination report columns.</td></tr><tr><td>Table-to-report Lineage</td><td>Lineage between source tables and QuickSight reports.</td></tr><tr><td>Report-to-report Lineage</td><td>Lineage relationships between related QuickSight reports.</td></tr></tbody></table>

{% hint style="info" %}
Lineage extraction depends on QuickSight metadata, source connection availability, SQL parsing support, and the completeness of the crawled catalog objects.
{% endhint %}

## Partial or Limited Coverage

Certain QuickSight scenarios provide partial lineage coverage because the required source metadata may be incomplete, transformations may not be fully represented in dataset metadata, or runtime behavior may prevent complete static lineage resolution.

### Scenarios

<table data-search="false"><thead><tr><th width="202">Scenario</th><th width="362">Limitation Description</th><th width="337">Recommendation / Workaround</th></tr></thead><tbody><tr><td>S3-source Lineage</td><td>Lineage quality depends on the availability and completeness of manifest, file-location, or folder metadata.</td><td>Ensure relevant S3 manifest and file-location/folder metadata is available before lineage extraction.</td></tr><tr><td>Derived / Calculated Fields</td><td>Derived or calculated fields may be represented only when the required information is available in dataset metadata. Complex transformations are not always decomposed into individual lineage relationships.</td><td>Validate lineage manually for complex calculated or derived fields where required.</td></tr><tr><td>Cross-Dataset Joins</td><td>Lineage can represent the participating datasets, but detailed join-expression semantics have limited coverage.</td><td>Validate detailed join relationships manually where join-expression-level lineage is required.</td></tr><tr><td>Missing Dataset References</td><td>Missing dataset references can prevent the affected lineage paths from being resolved.</td><td>Ensure referenced datasets are crawled and available in the catalog.</td></tr><tr><td>Blank Table or Schema Metadata</td><td>Blank table or schema metadata can cause affected lineage paths to be skipped.</td><td>Ensure complete table and schema metadata is available from the source connection.</td></tr><tr><td>Cross-account / Cross-region Sources</td><td>Source resolution depends on correctly configured reference connections and connection priorities.</td><td>Configure the required reference connections and <code>connectionsPriorityForLineage</code> values.</td></tr></tbody></table>

{% hint style="info" %}
Incomplete source metadata, unresolved dataset references, complex calculated fields, cross-dataset joins, and incorrectly configured reference connections may reduce lineage completeness and column-level accuracy.
{% endhint %}

## Unsupported Scenarios

The connector does not support complete lineage extraction for runtime-generated queries, visual-level expressions, parameter propagation, and transformation scenarios that cannot be statically resolved from available QuickSight metadata.

### Unsupported Lineage

<table><thead><tr><th width="178">Not Supported</th><th width="399">Description</th><th width="302">Recommendation / Workaround</th></tr></thead><tbody><tr><td>Dynamic / Runtime-generated SQL</td><td>Lineage cannot be fully generated when SQL is created dynamically at runtime and cannot be statically parsed.</td><td>Use statically available SQL definitions where possible and validate affected lineage manually.</td></tr><tr><td>Visual-level Custom Expression Parsing</td><td>Custom expressions defined at the visual level are not parsed for lineage extraction.</td><td>Validate visual-level dependencies manually where required.</td></tr><tr><td>Parameter / Variable Propagation</td><td>Parameters and variables are not propagated through lineage relationships.</td><td>Validate parameter-dependent data flows separately where required.</td></tr><tr><td>Complex Calculated Fields</td><td>Complete expression-level lineage is not available for complex calculated fields when the required transformation details are not represented in the source metadata or SQL parser.</td><td>Validate calculated-field lineage manually where required.</td></tr><tr><td>Detailed Aggregate Semantics</td><td>Aggregate operations such as <code>SUM</code>, <code>AVG</code>, and <code>COUNT</code> are not represented as transformation expressions when the source SQL parser does not expose the required semantics.</td><td>Validate aggregate transformation logic separately where detailed expression-level lineage is required.</td></tr></tbody></table>

{% hint style="info" %}
Unsupported scenarios do not generate complete lineage and may result in missing or disconnected lineage relationships within lineage visualization.
{% endhint %}

## Current Functional Status

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

<table data-search="false"><thead><tr><th width="190">Status Area</th><th>Details</th></tr></thead><tbody><tr><td>Overall Coverage</td><td>Production-ready coverage across core QuickSight Dashboards, Analyses, Datasets, relational-table sources, Custom SQL sources, and column-level lineage.</td></tr><tr><td>Lineage Depth</td><td>Table-level, report-level, and column-level lineage across supported QuickSight components and source connections.</td></tr><tr><td>Supported Inputs</td><td>Dashboards, Analyses, Datasets, Sheets, Visuals / Child Reports, relational-table sources, Custom SQL sources, and supported S3 sources.</td></tr><tr><td>Functional Scope</td><td>End-to-end lineage from source databases and S3 files through QuickSight Datasets and Analyses to Dashboards, Sheets, and Visuals.</td></tr><tr><td>Transformation Support</td><td>Direct relational column mappings, qualified column name matching, and Custom SQL alias mapping are supported. Derived and calculated fields have partial coverage.</td></tr><tr><td>Limitation Areas</td><td>S3 metadata dependencies, cross-dataset join semantics, derived/calculated fields, dynamic SQL, parameter-driven queries, visual-level custom expressions, and incomplete source metadata.</td></tr><tr><td>Resulting Output</td><td>Reliable lineage for core QuickSight workloads, with metadata-dependent and partial coverage for advanced transformation, S3, dynamic SQL, parameter, and cross-dataset scenarios.</td></tr></tbody></table>

{% hint style="warning" %}
The Amazon QuickSight connector provides production-ready lineage coverage across core QuickSight Dashboards, Analyses, Datasets, relational-table sources, Custom SQL sources, and column-level relationships. S3 lineage depends on the availability of manifest or file-location/folder metadata. Advanced scenarios involving dynamic SQL, parameters, visual-level expressions, complex calculated fields, cross-dataset join semantics, and incomplete source metadata have partial or unsupported coverage and may require manual validation.
{% endhint %}

***

Copyright © 2026, OvalEdge LLC, Peachtree Corners, GA, USA.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.ovaledge.com/release8.1/connectors/connector-repositories/reporting-tool/amazon-quicksight/amazon-quicksight-lineage.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.