Can I specify column datatypes when creating physical dataset via Catalog API call

1

Can we specify the data type for a field when we create a physical dataset using V3 catalog API?
Response contains fields and each field has VARCHAR type.
I added the below key and value in create catalog payload but didn’t work.

“fields”: [
{
“name”: “total exports”,
“type”: {
“name”: “FLOAT”
}
},
{
“name”: “beef”,
“type”: {
“name”: “FLOAT”
}
}]

2

Dremio auto detects schema based on the underlying data. If you require changing the schema, you can create a virtual dataset and use SQL to cast the type for example.