Data Dictionary

What is Data Dictionary?

The Data Dictionary in Masthead is a comprehensive list of all assets within the connected Google BigQuery and Looker environments. It's a handy collection of metadata, enabling users to easily search for datasets, tables, columns, Looker dashboards, or looks.

For BigQuery tables, the dictionary provides essential information like the creation date, last update, size, and first-level upstream and downstream dependencies. It also includes any available descriptions from BigQuery.

Upon deployment, you'll see a list of tables, views, and external tables (sourced form Google Spreadsheets or Cloud Storage) in the connected Google Cloud projects.

Tables dictionary

For columns, the dictionary allows users to search any term across the entire warehouse agnostically, providing details about the column type, its location, and description.

Columns dictionary

For BI assets, the dictionary offers visibility into all existing dashboards and reports. It includes their IDs with direct links to Looker, dashboard elements, upstream dependencies in Google BigQuery, and information on the dashboard's creation and last update dates.

Looker assets dictionary

The Data Dictionary offers centralized access to metadata, significantly simplifying data exploration and analysis, thereby boosting efficiency when using Google BigQuery and Looker. It benefits both data and business teams by providing an intuitive UI to easily understand, locate, and interact with available data assets, data products, and its dependencies within the data platform.

Last updated