Developer Tool Guide

Back Next

Troubleshooting Physical Data Objects

I am trying to preview a relational data object or a customized data object source transformation and the preview fails.: Verify that the resource owner name is correct.

When you import a relational resource, the Developer tool imports the owner name when the user name and schema from which the table is imported do not match. If the user name and schema from which the table is imported match, but the database default schema has a different name, preview fails because the Data Integration Service executes the preview query against the database default schema, where the table does not exist.

Update the relational data object or the source transformation and enter the correct resource owner name. The owner name appears in the relational data object or the source transformation
Advanced
properties.
Mapping validation fails with Databricks physical objects.: If you used an escape character when you imported a physical data object from Databricks, mapping validation fails. Avoid escaping characters in object names.