# 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`. |
| total\_impressions\_14d/30d/60d | The number of impressions over the last 14/30/60 days. This data is aggregated from the impressions of fields within the Custom SQL, ensuring counts are not duplicated when multiple fields are viewed together.
Note: The distinct user count does support a user-level breakdown, which you can access via the Euno Assistant or from the resource side panel. However, this breakdown is not available via an EQL query.
|
#### 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](https://docs.euno.ai/sources/data-warehouses/snowflake-integration) 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.
Note: Unlike the distinct-users property available in BI tools (see impressions) with native usage tracking, this distinct-user count from the warehouse does not provide a user breakdown.
| 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.
Note: The distinct user count does support a user-level breakdown, which you can access via the Euno Assistant or from the resource side panel. However, this breakdown is not available via an EQL query.
| 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 |
| luid | The Tableau LUID (Locally Unique Identifier) | published 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.
Note: Unlike the distinct-users property available in BI tools (see impressions) with native usage tracking, this distinct-user count from the warehouse does not provide a user breakdown.
| 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.
Note: The distinct user count does support a user-level breakdown, which you can access via the Euno Assistant or from the resource side panel. However, this breakdown is not available via an EQL query.
| views, dashboards |
| tableau\_workbook | The property stores the tableau workbook the resource is found within. | views, dashboards |
| hidden\_sheet | A boolean value of whether or not the sheet is hidden | views, dashboards |
| luid | The Tableau LUID (Locally Unique Identifier) | dashboards, workbooks |
#### 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_field` |
| parent\_container | The URI of the visualization or data source where the custom field is defined |
| parent\_container\_name | The name of the visualization or data source where the custom field is defined |
| parent\_type | The parent resource's type |
| 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.
Note: Unlike the distinct-users property available in BI tools (see impressions) with native usage tracking, this distinct-user count from the warehouse does not provide a user breakdown.
|
| 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.
Note: The distinct user count does support a user-level breakdown, which you can access via the Euno Assistant or from the resource side panel. However, this breakdown is not available via an EQL query.
|
| tableau\_workbook | The property stores the tableau workbook the resource is found within. |
## 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.
**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.
## Tableau Pulse Metric Definitions
Tableau Pulse Metric Definitions are high-level metric definitions discovered from Tableau Pulse. Each definition may have one or more associated metrics.
| Property | Value |
| --------------- | ----------------------------------------------------------------------------------- |
| name | The name of the metric definition as defined in Tableau Pulse. |
| description | The description of the metric definition. |
| type | `tableau_metric_definition` |
| native\_id | The ID of the metric definition in Tableau Pulse. |
| external\_links | List of links to open the metric definition in Tableau Pulse and any related links. |
| updated\_at | The timestamp when the metric definition was last modified. |
| updated\_by | The username of the user who last modified the metric definition, if available. |
**Lineage**: Each `metric definition` has an `upstream` relationship with the Published Datasource it depends on, and an `upstream_fields` relationship with each of the fields it is using in it.
## Tableau Pulse Metrics
Tableau Pulse Metrics are the concrete metrics associated with a metric definition in Tableau Pulse.
| Property | Value |
| --------------------- | --------------------------------------------------------- |
| name | The name of the metric (currently: 'metric based on '). |
| type | `tableau_metric` |
| native\_id | The ID of the metric in Tableau Pulse. |
| native\_raw\_object | The full raw object as returned by the Tableau Pulse API. |
| number\_of\_followers | The number of users following this metric |
**Lineage**: Each `metric` has an `upstream` relationship with the metric definition it is based on
## Warehouse Tables and Columns
#### Table
The Tableau Integration will discover resources of type Table when it identifies a published data source, flow 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.
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. |
| type | 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 |
#### Column
The Tableau integration will discover resources of type `column` when it identifies a dataset referring to a database column.
| Property | Description |
| -------------------- | ---------------------------------------------------------------------- |
| name | The name of the column. |
| type | column |
| 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 |
## 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](https://help.tableau.com/current/online/en-us/extract_auto_suspend.htm).