Remove column from existing schema

Hello! Is it possible to remove a column from an existing dataset using the Domo CLI? In otherwords, can I change the schema? My existing schema has 25 columns. But I only have 23 columns in a data file that I want to upload. This causes an issue when uploading the file using the Domo CLI. So, the last two columns of my existing Domo dataset are not longer needed and they must be removed. Can I do this?
Also, in the dataset schema, I see that all columns have a property called 'isVisible' and it's set to True. If I changed this value to False, would this allow me to upload a data file to the dataset without having to send the columns were isVisible is set to False?
Finally, if I can't remove the columns using the DOMO cli, can they be removed using the Domo front-end UI? I've never used the front-end really, so I'm not sure.
Thanks!
Serissa
Answers
-
You can't change the dataset schema using the front end.
What should happen to the existing values in those two columns you're wanting to drop? Do you still need access to that data or are you wanting it to be completed removed permanently?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
So, I think the data will no longer be needed, so the data can be deleted. How would I go about doing that?
However, if we wanted to keep the data, how would we do this? Is that what the isVisible property is for?
Thanks!!!
0 -
You can utilize the
create-dataset
command in the CLI along with the-i
parameter to specify the existing dataset's ID to update the schema of an existing dataset. Doing this will drop the column from your definition and would be unavailable moving forward. You could make a copy of your original dataset as a backup first in case you need to reference those two columns you're dropping.**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@GrantSmith or anyone... can you explain how to get to the "CLI"...? I'm not familiar with this and have a dataset in which I need to drop a column (it's causing parsing issues and won't allow me to open with ETLs).
0 -
@NathanDorsch I'm referring to the Java CLI tool that Domo provides.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive