website logo
⌘K
Getting Started 🚀
What is DataLakeHouse.io?
Our Business-Value Focus
Learn the Basic Concepts
Connectors
Operations Applications
Toast
Asana
Aloha POS
BILL
Bloom Growth
Bullhorn
Ceridian Dayforce
ConnectWise
Facebook Ads
Food Delivery Service Connector
Google Analytics 4
Harvest
Hubspot
Jira
MailChimp
McLeod Transportation
NetSuite (Oracle NetSuite)
Optimum HRIS
Oracle EBS
Oracle PeopleSoft
QuickBooks Online
Salesforce
Shopify
Square
Square Marketplace
Stripe
TriNet
Verizon Wireless Business
Workday HCM
Xero
Zoom
Databases
Files & Object Storage
SSH Tunnel Setup for Hosted Database Systems
Databases FAQ
SQL Transformations
Terraform: Reverse Terraforming
DBT Cloud Transformations
Sync Bridge (Data Pipelines)
Create a Sync Bridge
Manually Run a Sync Bridge
Deleting a Sync Bridge
Historical Re-sync
Analytics
Access Analytics
Snowflake Usage Analytics
Data Catalog
Create the Catalog
Populate the Catalog
Access the Catalog
Data Warehouse Clouds
Snowflake
Open Source DW Models
Alerts & Notifications
Slack Notifications
Untitled doc
Logs & Monitoring
Security
Callback Links
Service Level Agreement (SLA)
Release Notes
May 2023
April 2023
Q3 2022
Q4 2022
Community Overview
Contributor Agreements
Code Contribution Guide
About
License
Viewpoint
Docs powered by archbee 

Populate the Catalog

11min

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 03 Mar 2023
Did this page help you?
Yes
No
PREVIOUS
Create the Catalog
NEXT
Access the Catalog
Docs powered by archbee 
TABLE OF CONTENTS
Data Catalog
README Section
Columns Section
Glossary Terms
Attributes/Columns
Glossary Terms
Classifications