Data Governance Datasets Joines

We need to join the following datasets.
1) Data Governance Card
2) Data Governance Pages and Cards
3) Data Governance Pages and Users
4)Data Governance Users
Can any one help to find out the joining key between them.
Thanks,
Shobhit
Comments
-
The name of the dataset implies the granularity. That said @DataMaven has seen that not all DomoGovernance datasets have the expected cardinality.
If I were using a DG dataset, I would enforce a GROUP BY clause to the data BEFORE JOINing it to another table to guarantee granularity.
For Cards and Pages, I would
1) GROUP BY the respective ID columns
2) Remove any columns that violate 3NF (https://www.google.com/search?q=3nf&rlz=1C1CHBF_en-GBGB896GB896&sxsrf=ALeKk03VjLpKmne8NdduxuFJHUrQdI_eSA:1593595988080&tbm=isch&source=iu&ictx=1&fir=hkPjDYPQfqeZOM%252CdmBtnH4lW3c_rM%252C%252Fm%252F01cs9w&vet=1&usg=AI4_-kSf2mDdYZOQm9EJ2xSN-KoB3jnq4Q&sa=X&ved=2ahUKEwjqv6PW36vqAhVu-ioKHWy0C4YQ_B0wIHoECAgQAw&biw=1536&bih=731#imgrc=hkPjDYPQfqeZOM) -- remove columns that are not attributes of the ID column.
3) use FIRST or MAX aggregates to get the text values (like Title or Creation Date).
For Bridge tables (Pages and Cards and Pages and Users)
1) I would GROUP BY the key columns,
2) remove any descriptive columns, like Title or Description, because those attributes will come from dimensional tables
3) Only keep measures like Share Date.
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"0
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
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive