Tableau Integration Discovered Resources

Tableau Integration Discovered Resources

The Tableau integration discovers the following resources:

• Tableau workbooks

• Tableau data sources

  • Published

  • Embedded

• Tableau custom sql

• Tableau view

• Tableau dashboards

• Tableau Fields

  • Fields of type measure

  • Fields of type dimension

• Table

Tableau Workbooks

Property	Value
name	The name of the workbook.
description	Stores the description of the workbook from the native application.
native_id	The ID of the folder in Tableau's API
parent	The parent folder of this folder. Null if the folder has no parent folder.
created at	Stores the date the resource was created within the native application.
created by	Stores the email of the user who created the resource within the native application.
tableau_extract_refresh_frequency	The scheduled refresh frequency when there are extracts (*see Limitations section regarding suspended extracts).

Tableau Custom SQL

Although custom SQL in Tableau is part of the data source, Euno observes it as an individual resource with both upstream and downstream connections to the data source it belongs to.

Property	Value
name	The name of the resource within the native application.
type	tableau_custom_sql
parent_container	The data source the custom sql is found within.
is_identity_transformation	If the custom SQL is a basic SELECT * statement, the property is set to true; otherwise, it is set to false.

Tableau Data Sources

Property	Value	Applicable to
name	The name of the resource within the native application.	published data source, embedded data source
description	Stores the description of the resource from the native application.	published data source, embedded data source
owner	Stores the users email who is designated the owner of the resource within the native application	published data source, embedded data source
type	tableau_published_datasource, tableau_embedded_datasource	tableau_published_data, tableau_embedded_datasource, tableau_views, tableau_dashboards
native_id	The ID of the resource within Tableau	published data source, embedded data source
browse_path	Stores the entire path of the resource of where the resource is located in the source, such as folders within folders.	published data source, embedded data source
parent_container	For an embedded data source, the parent is the Tableau workbook; for a published data source, the parent is the Tableau project.	published data source, embedded data source
tableau_project	The property stores the project information for the tableau project the resource is directly found in.	published data source, embedded data source
tableau_has_extracts	The property stores whether the resource has an extract or not.	published data source, embedded data source
tableau_extract_refresh_frequency	The scheduled refresh frequency when there are extracts (*see Limitations section regarding suspended extracts).	published data source
total_queries_14d/30d/60d	The total number of queries the resource found within over the last 14/30/60 days. This information is taken from the query log of snowflake (see Snowflake integration). In addition, this information is only available for LIVE data sources, as extracts, including the reload of the extract, are not tagged by Tableau.	published data source, embedded data source
distinct_users_14d/30d/60d	The number of distinct users who triggered the query the resource is found within over the last 14/30/60 days. This information is taken from the query log of snowflake. Only available for LIVE data sources.	published data source, embedded data source
total_impressions_14d/30d/60d	The number of impressions the resource is found within over the last 14/30/60 days. This information is taken from the Tableau impression data pulled directly from the application. Unlike usage this data is found for both LIVE and EXTRACTED data sources.	published data source, embedded data source
distinct_impressions_users_14d/30d/60d	The number of distinct users who triggered the impressions of the resource over the last 14/30/60 days. This information is taken from the Tableau impression data. Available for both LIVE and EXTRACTED data sources.	published data source, embedded data source
tableau_workbook	The property stores the tableau workbook the resource is found within.	embedded data source
is_proxy_to_published_datasource	Identifies if the resource proxies an upstream published data source.	embedded data source
native_last_data_update	The timestamp indicating the most recent update to the data source.	published data source, embedded data source

Tableau Visualizations

Property	Value	Applicable to
name	The name of the resource within the native application	views, dashboards
description	Stores the description of the resource from the native application.	views, dashboards
owner	Stores the users email who is designated the owner of the resource within the native application	views, dashboards
type	tableau_view, tableau_dashboard	views, dashboards
native_id	The ID of the resource within Tableau	views, dashboards
browse_path	Stores the entire path of the resource of where the resource is located in the source.	views, dashboards
parent_container	For views and dashboards, the parent is the Tableau workbook.	views, dashboards
tableau_project	The property stores the project information for the tableau project the resource is directly found in.	views, dashboards
total_queries_14d/30d/60d	The total number of queries over the last 14/30/60 days. Only available for LIVE data sources.	views, dashboards
distinct_users_14d/30d/60d	The number of distinct users who triggered queries over the last 14/30/60 days. Only available for LIVE data sources.	views, dashboards
total_impressions_14d/30d/60d	The number of impressions over the last 14/30/60 days. Available for both LIVE and EXTRACTED data sources.	views, dashboards
distinct_impressions_users_14d/30d/60d	The number of distinct users who triggered impressions over the last 14/30/60 days. Available for both LIVE and EXTRACTED data sources.	views, dashboards
tableau_workbook	The property stores the tableau workbook the resource is found within.	views, dashboards

Tableau Fields

For the fields found within the above resources, Euno discovers the following properties.

Property	Value
name	The name of the field
type	tableau_measure or tableau_dimension
parent_container	The URI of the visualization or data source where the custom field is defined
is_calculated	If the field is a calculated field then true otherwise false
is_identity_transformation	If the field is a calculated field then false otherwise true
total_queries_14d/30d/60d	The total number of queries over the last 14/30/60 days. Only available for LIVE data sources.
distinct_users_14d/30d/60d	The number of distinct users who triggered queries over the last 14/30/60 days. Only available for LIVE data sources.
total_impressions_14d/30d/60d	The number of impressions over the last 14/30/60 days. Available for both LIVE and EXTRACTED data sources.
distinct_impressions_users_14d/30d/60d	The number of distinct users who triggered impressions over the last 14/30/60 days. Available for both LIVE and EXTRACTED data sources.

Table

The Tableau Integration will discover resources of type Table when it identifies a published data source or Tableau extract referring to a database table. For example, if a data source is using a table from the data warehouse, which is not connected to dbt, the Tableau source will discover this table.

To determine the exact location of the referred data source or extract, the Tableau Integration utilizes the project and data source properties specified in the Tableau metadata API. The Looker Connection usually has all the metadata required for Euno to uniquely determine the URI of the referred table.

In the case of cloud-hosted extracts, the Tableau Integration may encounter limitations in handling credentials or region-specific configurations. For instance, API calls might lack sufficient detail to automatically distinguish between regions or accounts, requiring manual intervention to map these attributes correctly. In this case, Euno defaults to using the aws account id default_aws_account.us_central1 . If you have multiple AWS accounts and you need to distinguish between them, set up manual "connection mapping".

Property	Value
name	The name of the table.
database_technology	The technology of the database, based on the dialect of the connection
database	The name of the database
schema	The name of the schema

Tableau Prep Flows

Tableau Prep Flows are data preparation workflows that can be used to clean and transform data before analysis. The Tableau integration discovers flows and their dependencies.

Property	Value
name	The name of the flow
description	The description of the flow
created_at	The timestamp when the flow was created
updated_at	The timestamp when the flow was last modified
native_owners	List of users who own the flow, containing their email addresses
table_dependencies	List of URIs representing the input tables used by the flow
external_links	Contains a link to open the flow in Tableau
thumbnail	Base64 encoded PNG image of the flow diagram (if available and under 1MB)

Flow Dependencies

The integration discovers both input and output dependencies of flows:

Input Tables

Input tables are discovered from LoadSql nodes in the flow. For each input table, the following properties are captured:

Property	Value
name	The name of the table
database	The database name
schema	The schema name
database_technology	The database technology (e.g. snowflake, mysql)
type	table

Output Resources

Flows can output to:

1. Database Tables

2. Published Data Sources

The integration maintains the lineage between flows and their inputs/outputs, allowing you to track data transformations through your Tableau Prep workflows.

Limitations

Extract Refresh Status

Due to Tableau API limitations, the tableau_extract_refresh_frequency property may not reflect correctly if an extract refresh has been suspended due to inactivity. Tableau automatically suspends extract refreshes for workbooks and data sources after a period of inactivity. When a schedule is suspended, Euno still considers it active and reflects the original frequency in this field. For more information about this Tableau feature, see the Tableau documentation on automatic extract suspension.