What are all the reserved words in creating a new dataset?
We are using the Stream API to create datasets. This is all dynamic so we have no idea what the data is going to be or what the columns in the source data are called.
What we found is that if the source data has a column named 'row_number' the call to create a new stream dataset will fail but with no message or explanation.
Now that we know about 'row_number' we would like to know what other reserved words cannot be used as column names. Where can I find that information?
Thank you
Answers
-
I don't believe an official list exists however I'd recommend looking at the Beast Mode Function Reference page and avoiding using any of the functions.
Alternatively, you could just prepend or append a character like an underscore to avoid name collisions dynamically.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Checking that page is good advice, thank you.
However, row_number is not a function, so I need to keep looking.
Also, I also cannot change the name of the columns. This is for a product we built which allows anyone to safely load sensitive data into Domo (i.e., they don't want people' personal information - PII, in Domo). So, this workflow can be run by someone in any Domo customer. I really need to keep the column names the same as whatever our customers select to load.
I appreciate you taking the time to respond.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 601 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 689 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 385 Distribute
- 110 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 112 Manage
- 109 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive