I’m trying to create an ontology object from this source table, but the primary key column is of type decimal, which is causing issues when building the ontology object.
Is there a way to transform this column into an integer, or alternatively, add a new column of type integer to the table that I can use as the primary key for the ontology object?
Hello!
Yes, to do that, you need to cast the column that is double to int or string, do that in pipeline builder or the code repository. Then build the dataset again. After that, go to the object and wait till it syncs with the dataset. Once it does, just click on the newly casted property and make it the primary key.
If you faced too many errors in the ontology manager, delete this object and re-create it based on the newly updated dataset. Especially if you haven’t done anything with it yet.
If you face any issues let me know.
To follow up on this response, in Pipeline Builder you should use the Cast expression to change the type. Generally we encourage String, Integer and Short.
Also make sure once this is done to update schema to map new columns in the PB object output along with going into Ontology Manager and doing the same with the updated object set!