How do you join a federated dataset with a cloud amplifier dataset from Snowflake?
Best Answers
-
Hey HLIN,
According do Domo documentation, Federated Datasets do not support Magic ETL. I've also just confirmed in my own instance that we are not able to use federated datasets as inputs in SQL transforms either:
As for actually getting your data together, you would need to shift your focus to joining them outside of Domo or convert the federated dataset to a cloud amplifier dataset.
0 -
After a DataSet is created in Domo from a Federated connection, it is referred to as a Federated DataSet. These DataSets do not support Magic ETL, including Data Science actions. Alternatively, you can create Views with the on-premise DataSet.
If you want to join a Federated DataSet, you should either join them outside of Domo or convert the Federated DataSet to a Cloud Amplifier DataSet in your Snowflake database before pulling it into Domo.
Can Domo's ETL and SQL tools be used to transform Federated DataSets?
No, this is currently not supported. I recommend submitting an enhancement request through the Ideas Exchange platform. This helps our product development team prioritize new feature requests.
0
Answers
-
Hey HLIN,
According do Domo documentation, Federated Datasets do not support Magic ETL. I've also just confirmed in my own instance that we are not able to use federated datasets as inputs in SQL transforms either:
As for actually getting your data together, you would need to shift your focus to joining them outside of Domo or convert the federated dataset to a cloud amplifier dataset.
0 -
After a DataSet is created in Domo from a Federated connection, it is referred to as a Federated DataSet. These DataSets do not support Magic ETL, including Data Science actions. Alternatively, you can create Views with the on-premise DataSet.
If you want to join a Federated DataSet, you should either join them outside of Domo or convert the Federated DataSet to a Cloud Amplifier DataSet in your Snowflake database before pulling it into Domo.
Can Domo's ETL and SQL tools be used to transform Federated DataSets?
No, this is currently not supported. I recommend submitting an enhancement request through the Ideas Exchange platform. This helps our product development team prioritize new feature requests.
0 -
Thank you both for your answers. I ended up creating an ETL outside of Domo.
1
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 307 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 746 Automate
- 187 Apps
- 475 APIs & Domo Developer
- 68 Workflows
- 16 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive