Allow naming of tables in Snowflake with Cloud Amplifier
chrissweeney92
Domo Employee
Currently when data is added into Snowflake via Domo's cloud amplifier, it is not possible to choose the name of the dataset in Snowflake. It is named as 'DATASET_0001' etc. but it would be better to be given the same name as the dataset in Domo.
Tagged:
4
Comments
-
While Domo doesn't currently offer this option, there are a few workarounds you can try:
- Use a naming convention: One option is to develop a consistent naming convention for your datasets in Domo, so that you can easily identify which datasets correspond to which tables in Snowflake. For example, you could use a prefix or suffix to indicate the Snowflake table name (e.g. "my_dataset_sf_table").
- Use a Snowflake task: Another option is to create a Snowflake task that renames the table after it's been created by Domo's cloud amplifier. You could set up a task to run at a regular interval (e.g. daily) that checks for new tables created by Domo and renames them according to your desired naming convention.
I hope these suggestions are helpful. Let me know if you have any other questions or concerns!
0 -
Hi all - this issue has been resolved, and when using Domo to create new tables in Snowflake those Snowflake tables will now reflect the name of the DataSet from Domo.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive