About Tableau Catalogue
Data is increasing in volume, formats and importance leading to more complex environments. With the rapid pace that data changes, it can be hard to keep track of that data and how it's being used in such complex environments. At the same time, more users need to access more of that data in more places, and it’s difficult for users to find the right data. Ultimately, this causes a lack of trust in the data because people question whether they’re using the right source or if the source is up to date.
Tableau Catalogue integrates features like lineage, impact analysis, data dictionary, data quality warnings and search into your Tableau applications, helping solve these problems differently from a stand-alone catalogue. It focuses on both IT and the end user so that everyone using Tableau Server or Tableau Online has more trust in and visibility into the data, while also enabling more discoverability. Tableau Catalogue builds a catalogue out of the Tableau content being used by your organisation, enabling comprehensive functionality like the following:
Impact analysis and lineage.
- You can see the workbooks and other Tableau content that depend on particular columns or fields from tables or data sources you manage. When you need to make changes to your data, you can notify the impacted Tableau authors using email.
- As a workbook author, you can use lineage to trace the fields that your workbook depends on.
- As a user, when you use a Tableau visualisation, you can see where the data came from that was used to create the view.
- Curation and trust. As a data steward, you can add helpful metadata, like descriptions and certification, so that users find the right data. You can set data quality warnings, view data details on the Data Details pane, certify assets and remove assets from the catalogue.
- Data discovery. You can use Tableau Catalogue to search for databases, tables and data sources to analyse in Tableau and connect to them from the search results.
Starting in 2019.3, Tableau Catalogue is available in the Data Management Add-on to Tableau Server and Tableau Online. When the product key is active and enabled, the catalogue features described above are integrated into the product you're using, so you can work with the data where you find it.
How Tableau Catalogue works
Tableau Catalogue discovers and indexes all the content on your site – workbooks, metrics, data sources, sheets and flows – to gather metadata about the content. From the metadata, databases and tables (also referred to as external assets) are identified. Knowing the relationships between the content and the external assets enables Tableau to display the lineage of the content and external assets. Tableau Catalogue also enables users to connect to external assets using Tableau Server or Tableau Online.
For information about how you can use Tableau Catalogue to support data governance in your organisation, see Governance in Tableau(Link opens in a new window) in the Tableau Blueprint Help.
Key Tableau Catalogue terms
- Metadata. Information about the data.
- Tableau content. Content created in Tableau such as workbooks, data sources and flows.
- External assets. The metadata about the databases and tables used by the Tableau content published to Tableau Server or Tableau Online.
Licence Tableau Catalogue
Tableau Catalogue is licensed through the Data Management Add-on. For information about how Data Management Add-on licensing works, see Licence the Data Management Add-on.
Enable Tableau Catalogue
After Tableau Server or Tableau Online is licensed with the Data Management Add-on, you can enable Tableau Catalogue by doing one of the following tasks:
- For Tableau Online, no action necessary. Tableau Catalogue is on by default, configured to use derived permissions and ready to use. For more information about derived permissions, see the Permissions on metadata topic.
For Tableau Server, the Server admin must first enable the Tableau Metadata API using the
tsm maintenance metadata-servicescommand. For more information, see Enable Tableau Catalogue.
After the Metadata API is enabled, Tableau Catalogue is on by default, configured to use derived permissions and ready to use. For more information about derived permissions, see the Permissions on metadata topic.
Features and functionality
To learn more about the features you can use with Tableau Catalogue, see the following Help articles:
- In the Connect pane on Tableau Desktop, under Search for Data select Tableau Server to connect to data using Tableau Server or Tableau Online(Link opens in a new window). When Tableau Catalogue is enabled, in addition to searching for published data sources to connect to, you can now search for and connect to the specific databases and tables used by published data sources and workbooks on your Tableau Server or your Tableau Online site.
- Search is expanded to include results based on fields, columns, databases and tables when Tableau Catalogue is enabled.
- If you author in the web, you can also connect to databases and tables, as well as published data sources, from Tableau Server(Link opens in a new window) and Tableau Online(Link opens in a new window).
Curation and trust
- Certify your data assets(Link opens in a new window) to help users find trusted and recommended data.
- Set data quality warnings to alert users to data quality issues, such as stale or deprecated data.
- Categorise items on Tableau Server and Tableau Online using tags(Link opens in a new window) to help users filter external assets.
- Better understand published visualisations by using the Data Details tab to see information about the data used.
- Add descriptions to databases, tables and columns to help users find the data they're looking for.
Lineage and impact analysis
- Use lineage(Link opens in a new window) to trace the source of your data and to analyse the impact of changes to your data and identify which users might be impacted.
- Email owners(Link opens in a new window) of a workbook, data source or flow or contacts for a database or table about data-related updates.
You can use metadata methods in the Tableau REST API to programmatically update certain metadata. For more information about the metadata methods, see Metadata Methods in the Tableau Server REST API.
In addition to the REST API, you can use the Tableau Metadata API(Link opens in a new window) to programmatically query metadata from the content published to Tableau Server or Tableau Online. The Metadata API is fast and flexible and is best when you are looking to find out specific information about the relationship between metadata and its structures. Explore and test queries against the Metadata API using an interactive in-browser tool called GraphiQL(Link opens in a new window).
Note: The Data Management Add-on is not required to use the Metadata API or GraphiQL.