Which BI tools let agents trace a number's sources?

Quoted from Databricks’s docsFor lineage history beyond one year, use Catalog Explorer or the lineage API, which indefinitely retain lineage captured after September 1, 2024.

Quoted from Snowflake’s docsGiven a Snowflake object, returns data lineage information upstream or downstream from that object.

Quoted from Omni’s docsdimensions and measures - These blocks contain a sql property that defines which database columns are used for that field

Quoted from Hex’s docsBefore deletion, the agent inspects cell lineage to understand which other cells depend on the cell being removed, including variable references, dataframe dependencies, and input parameter usage.

Quoted from Sigma’s docsAlso fires for usage of the Sigma MCP describe tool to view the schema / DDL of a data model or workbook.

Quoted from BigQuery’s docsVIEW: A virtual table defined by a SQL query.

Quoted from Looker’s docsReturns the contents of a LookML file.

Quoted from Tableau’s docsFor example, you can use upstreamTablesConnection to query the tables used by a data source, use downstreamSheetsConnection to query sheets used by a workbook, or upstreamLinkedFlows and downstreamLinkedFlows to query flows that are directly upstream or downstream of one another.

Quoted from Power BI’s docsWhether to return lineage info (upstream dataflows, tiles, data source IDs)

Quoted from Metabase’s docsmb logs in to a Metabase instance and lets you or an AI agent read and write content over the Metabase API: questions, dashboards, collections, transforms, and more.

Quoted from Alteryx’s docsCalculates trend behavior for selected measures. Returns a source link back to the underlying data, but the link doesn't include forecast-verification detail.

Quoted from MotherDuck’s docsList views in database: SELECT database_name, schema_name, view_name, comment, sql FROM duckdb_views() WHERE database_name = 'your_database';

Quoted from Mode’s docsYou can use the queries resource to manage, update, or retrieve information about a SQL query in a given report.

Quoted from Redshift’s docsShows the definition of a view, including for materialized views and late-binding views.