Hello @4uSwan ,Kindly refer to below video to understand the relationship between different tables :- https://experienceleague.adobe.com/en/docs/platform-learn/tutorials/schemas/configure-relationships-between-schemas  Different tables will only get joined when you define same identity namespace dur...

Hello @ZoeAG  Here is a two-step approach for exporting data from AJO:Schedule a SQL Query: Write your SQL query and schedule it to run at a predefined time. This will save your results into a temporary dataset. For guidance on scheduling queries, please refer to this documentation.Export the Data: ...

Hi @Bpagadal, The error message indicates that the schema you've defined in your queryDef function, i.e., "xxlmig:newValidation", does not exist in your Adobe Campaign (AC) database.Here’s what you can do:Validate that the schema name is correct, including the proper character case as defined in the...