Enterprise docs

What is cataloged

For databases, the information gathered includes

  • The number of tables and columns ,

  • The names of the tables and columns,

  • Key information

  • The data types used

Depending on your data source, additional things might be cataloged. What is cataloged also changes as we release new versions of the collectors. Detailed information about what is collected--as we have it--follows.

JDBC data sources

When the DWCC is run against a JDBC data source the following metadata is collected:

  • database name

  • connection information

  • schema name

  • table and view names by schema

  • column names

  • column data types

  • column length

  • column precision (as appropriate)

  • table and column descriptions (if they exist)

Primary and foreign key information is also collected by the DWCC, but it is not currently displayed in the platform.

JDBC sources include:

  • Databricks

  • DB2

  • Denodo

  • Dremio

  • Hive

  • Infor ION

  • MySQL*

  • Oracle

  • PostgreSQL

  • Presto

  • Redshift

  • Snowflake

  • SQL Anywhere

  • SQL Server

  • Vertica

Note

* For MS SQL Server, table and column descriptions are not cataloged, even if they exist.

Collected from Tableau Server
  • Workbook name

  • Dashboard name

  • Dashboard title

  • Project a dashboard is in

  • Non-dashboard views

  • Number of dashboard views

  • Tags for objects that have them

  • Relationships between views/dashboards and workbooks

  • Number of dashboard favorites