With the domojupyter.write_dataframe can you pass a specific schema?
Hi All,
Am trying to write a DataFrame to a dataset using the domojupyter.write_dataframe function.
The df in question has a field that is a Boolean, when I run the script and then check the output dataset in the domo Data section, the field has been created as an Integer and the entire column is blank.
Question is, can you pass a specific schema to the function so that all columns are created with the desired datatype? or is there a way to ensure Boolean fields are created correctly?
The workaround I have built is converting the column to a String then writing it, but I want to know if it is possible write it as a Boolean.
Cheers!
Best Answers
-
Hi @Jasveer_Singh,
Unfortunately, boolean is not a datatype in Domo. As a workaround, I'll usually turn it into a string column with TRUE/FALSE values.
Here's a list of all datatypes available in Domo:
2 -
I recommend RobB's post here, too:
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
1
Answers
-
Hi @Jasveer_Singh,
Unfortunately, boolean is not a datatype in Domo. As a workaround, I'll usually turn it into a string column with TRUE/FALSE values.
Here's a list of all datatypes available in Domo:
2 -
I recommend RobB's post here, too:
Please 💡/💖/👍/😊 this post if you read it and found it helpful.
Please accept the answer if it solved your problem.
1
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 283 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 565 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 593 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 96 Manage
- 93 Governance & Security
- 15 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive