Performing Transformations on Ontology Data

Hello,

I currently have an ontology object that was built from user inputted data (call this USER DATA for now), and I want to perform some transformations on USER DATA to create a new ontology object (call this TRANSFORMED for now).

I initially tried adding USER DATA to the pipeline builder, but it seems like you can’t directly perform transformations on ontology data. Is there a workaround for this? That data is directly stored to the ontology, so I can’t upload the raw data and perform transformations that way.

Appreciate any help or ideas. Thanks!

Hey,

You’ll need to create a materialization (i.e., materialized view in SQL DBs) from your Object Type to create a View/Dataset resource that you can then pass into either Pipeline Builder or Code Repositories to transform this further downstream.

  1. Go to the Ontology Manager Application
  2. Locate the relevant Object Type
  3. Access the Materializations page on the left
  4. Create a new materialization (it will take a minute or two to build)
  5. The new materialization can then be used as an input (via its location or RID) in your downstream pipeline

Hope this helps!

2 Likes

Thank you for the help!