How to find the source table of a Snowflake federated DataSet?
Hi,
This is probably a trivial question. I've created a Snowflake federated DataSet after selecting the Snoflake account, database schema and source table. Once the DataSet has been created, how to find the Snowflake table that it queries?
The table schema is prominently displayed in the "View Full Schema" section of the DataSet page, but I can't seem to find the *name* of the table itself.
Best Answer
-
@danidiaz are you asking for the name of the table in Snowflake? or the name of the dataset as represented in Domo?
The name of the dataset in Domo will be in the UI. You will not see the name of the source table. (that would defeat the whole concept of federated query :P)
You won't get the name of source table in snowflake, b/c to show that you'd have to expose the query to the end-user (keep in mind in your federated query you could combine multiple tables into one dataset which you surface in Domo). That fact alone makes it unreasonable to expect the Domo UI to display the source table name. If you want the dataset in Domo to have a source table name ... name it thusly.
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
Answers
-
@danidiaz are you asking for the name of the table in Snowflake? or the name of the dataset as represented in Domo?
The name of the dataset in Domo will be in the UI. You will not see the name of the source table. (that would defeat the whole concept of federated query :P)
You won't get the name of source table in snowflake, b/c to show that you'd have to expose the query to the end-user (keep in mind in your federated query you could combine multiple tables into one dataset which you surface in Domo). That fact alone makes it unreasonable to expect the Domo UI to display the source table name. If you want the dataset in Domo to have a source table name ... name it thusly.
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
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 709 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive