File Import Schema
I often get frustrated by Domo's need to define its own data structures. It might get quite a bit right, but what it gets wrong becomes a problem. In the file import, I see no way to define the data structure for each column. The best I can do is force the data type in the source file and try to trick Domo into creating the field I want. For example, Domo will try to make an ID field an integer, where I need a string. So I will inject an alpha character into the source.
Can we get some kind of functionality to set the data types for file import?
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **
Comments
-
@ArborRose if you have access to the admin area, there is a schema manager in the governance toolkit to adjust the schema to your liking. We have to do that from time to time when using some connectors because Domo gets it wrong.
0 -
What kind of witchcraft is this? What does it do? It looks like it lets you redefine the schema on a dataset.
I spent months working with Domo when we first started because the dataset schemas on our API calls were not defining properly. I do have admin access. It is all flagged as premium.
It looks like you can focus on a specific dataset and redefine the schema for it. Am I correct?** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
@ArborRose Absolutely. You can target individual datasets, change datatypes, remove columns, rename etc.
1
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
- 710 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