website logo
⌘K
Getting Started 🚀
What is DataLakeHouse.io?
Our Business-Value Focus
Learn the Basic Concepts
Connectors
Operations Applications
Google Sheets
Aloha POS
Bill.com
Ceridian Dayforce
DoorDash for Work
Facebook Ads
Google Analytics 4
Harvest
Hubspot
Jira
McLeod Transportation
NetSuite (Oracle NetSuite)
Optimum HRIS
QuickBooks Online
Salesforce
Shopify
Square
Square Marketplace
Stripe
Workday HCM
Xero
Databases
SQL Transformations
Terraform: Reverse Terraforming
DBT Cloud Transformations
Sync Bridge (Data Pipelines)
Create a Sync Bridge
Deleting a Sync Bridge
Analytics
Access Analytics
FAQ (about syncing data)
How are new columns are added to the target Data Warehouse?
....
Data Catalog
Create the Catalog
Populate the Catalog
Access the Catalog
Data Warehousing
Snowflake
Open Source DW Models
Alerts & Notifications
Integrations (Slack, etc.)
Logs & Monitoring
Security
Release Notes
April 2022
July 2022
Community Overview
Contributor Agreements
Code Contribution Guide
About
Our
License
Viewpoint
Docs powered by archbee 
11min

Populate the Catalog

Once the Data Catalog has been created it is now time to add defintions, details, descriptions, etc.

Data Catalog

In the navigation menu click Data Catalog

Select a Schema that you'd like to add helpful information to for your user community:

List of Schemas and Tables/Entities
List of Schemas and Tables/Entities

You can view the Tables/Entities within each Schema by clicking the arrow on the right. A list of the Tables/Entities within the Schema selected will expand below the Schema.

List of Tables/Entities in Expanded Schema View
List of Tables/Entities in Expanded Schema View

Click the Table/Entity that you want to start with.

A new screen will be presented with tiles that include Data Preview and README sections (pictured below on the left), as well as sections for Columns and Glossary Terms (pictured below on the right).

Data Catalog Table/Entity View
Data Catalog Table/Entity View

README Section

Click within the "Enter a description" text box in the README section to to enter a description of the Table/Entity. The description should be meangingful to an analyst type or to a developer to communicate the purpose of the table/entity and any potential unique notes about the table/entity. This description will be saved automatically, once you've clicked anywhere outside of the box on the page. You may also choose to click the blue Save button for peace of mind!

*Please understand that your description will not autosave if you click the back button without clicking somewhere else on the page outside of the description box first.

README Section to Enter a Description
README Section to Enter a Description

Columns Section

Enter a description or calcuation for each column by clicking on the blue pencil icon. The description should be meangingful to an analyst type or to an end user. Instead of placing this information in a spreadsheet or in a seperate tool, your Data Catalog is a core component to DataLakeHouse. After you've entered a description and click somewhere else on the page or the back within the platform, the description will be saved automatically.

*Your description will not save automatically if you click the back arrow on your browser before clicking somewhere else on the page first.

The more columns that are updated with helpful information, the more powerful your Data Catalog will be.

Column Description Box
Column Description Box

Glossary Terms

Add tags to make it easier to find this table in the Data Catalog. Enter a Term as individual value and click the plus (+) to add more Terms.

Glossary Terms Section
Glossary Terms Section

Attributes/Columns

At the top of the page is the option to further define Attributes/Columns within the Table/Entity.

Document image

For those that are deep in the technical details, each Term is added to the table as a tag within the Data Cloud. This makes searching across databases objects (schemas, tables, columns, etc) easier to locate. To be clear, the Data Catalog will not search for the term within a row of data in a table.

Here you are free to add even more meaningful details around purpose, source details, business logic and responsibility.

The README is the same info from the Table page, just duplicated for sanity purposes!

Data Catalog Attributes/Columns View
Data Catalog Attributes/Columns View

Glossary Terms

Add tags to make it easier to find this column within the Data Catalog. Enter a Term as an individual value and click the plus (+) to add more Terms.

For those that are deep in the technical details, each Term is added to the column as a tag within the Data Cloud. This makes searching across databases objects (schemas, tables, columns, etc) easier to locate. To be clear, the Data Catalog will not search for the term within a row of data in a table.

Classifications

Add tags to make it easier to find this table in the Data Catalog. Enter a Classification as an individual value and click the plus (+) to add more Classifications.

Next >>> Learn how to Access your Data Catalog to continue working on it or for future reference

Updated 08 Sep 2022
Did this page help you?
Yes
No
UP NEXT
Access the Catalog
Docs powered by archbee 
TABLE OF CONTENTS
Data Catalog
README Section
Columns Section
Glossary Terms
Attributes/Columns
Glossary Terms
Classifications