With the domojupyter.write_dataframe can you pass a specific schema?

Jasveer_Singh

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!

ellibot

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: https://developer.domo.com/portal/3b1e3a7d5f420-data-set-api#:~:text=Valid%20types%20are%20STRING%2C%20DECIMAL,%2C%20DOUBLE%2C%20DATE%2C%20DATETIME.

DavidChurchman

I recommend RobB's post here, too:

https://community-forums.domo.com/main/discussion/comment/80160#Comment_80160

ellibot

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: https://developer.domo.com/portal/3b1e3a7d5f420-data-set-api#:~:text=Valid%20types%20are%20STRING%2C%20DECIMAL,%2C%20DOUBLE%2C%20DATE%2C%20DATETIME.

DavidChurchman

I recommend RobB's post here, too:

https://community-forums.domo.com/main/discussion/comment/80160#Comment_80160