Domo Governance Datasets
Hello everyone,
Just found out this amazing Domo Governance Dataset connector. I was looking through it and wanted to see if this connector can answer the below question.
Is it possible to see all the datasets which has a particular segment(adobe) or metric. Please let me know if any one have tried this.
TIA
Best Answer
-
The Domo_Gov datasets don't analyze data values rather provide metadata about the domo object.
DG_Datsets for example has one row per dataset and attributes of the dataset
DG_DatasetSchema will have one row per dataset per column and the attributes of the column. (it will NOT tell you what's contained in the column).
You can "search for all google analytics datasets that have a column called "metric" or have a column called "segment" or "date".
Unless you build a data profiling dataset, https://www.sqlservercentral.com/articles/data-profiling-with-t-sql this link is for t-sql but you could adapt for Magic or MySql.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Answers
-
The Domo_Gov datasets don't analyze data values rather provide metadata about the domo object.
DG_Datsets for example has one row per dataset and attributes of the dataset
DG_DatasetSchema will have one row per dataset per column and the attributes of the column. (it will NOT tell you what's contained in the column).
You can "search for all google analytics datasets that have a column called "metric" or have a column called "segment" or "date".
Unless you build a data profiling dataset, https://www.sqlservercentral.com/articles/data-profiling-with-t-sql this link is for t-sql but you could adapt for Magic or MySql.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 -
Hello Jae Wilson,
Thank you for the clarification.
0
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 779 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 412 Distribute
- 120 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive