I have a mysql database and a set of parquet files. The parquet data is curated and joined to the mysql database to create a VDS that has a raw reflection (referenced later).
Then I join this VDS with the mysql database for dimension details. This works but when I try to create a reflection on the joined dataset I get an INVALID_DATASET_METADATA error. I tried various refresh metadata and forget metadata command and the error still popped up.
On a whim I removed the reflection on the original VDS and tried to generate the dimension joined reflection and then it worked. If I add the raw reflection back to the original VDS the joined VDS reflection fails again.
I am attaching the profile if that helps.
b8125603-3033-4502-920d-2d37c39e5277.zip (271.2 KB)