Please Sign In or Register to join the Community to see more content!

A common mistake with derived datasets

Derived Datasets are extremely useful outputs in Unify. Their power comes from the flexibility to be consumed by other Asset Pipelines, ODBC/JDBC connections, and connectors in the Connector Portal. A common mistake though, is changing the schema associated with the data flow going into a Derived Dataset. The "schema" refers to the column names and number of columns.

After you publish a Derived Dataset, the schema must remain the same. If it changes, you might see an error.

The error below lets a user know when a column name has changed.

The error below lets a user know when the number of columns has changed.

If you see an error on a Derived Datasets always check the schema of the data flow to ensure it hasn't changed.