What are these views in the datamart internal schema?

[MoeyE]

Hi,

I noticed that an internal schema is created alongside the other schema for my datamart task. What is the purpose of the internal schema? What is the purpose of the tables and also the views? What does 'whdr' mean?  

Thanks,

Mohammed

[TimGarrod · Accepted solution]

in QCDI, the INTERNAL SCHEMA is where tables are created along with any objects required by QCDI for processing.  the __whdr means with header and includes header columns which can be used to help triage when data showed up / was processed. 

It is recommended that any external process reading data, processing data etc. use the views generated in the 'external' or data asset schema. 

[MoeyE]

Hi Tim,

Thanks for the info mate, much appreciated.

Regards,

Mohammed

[MoeyE]

Hi Tim,

Follow up question just confirming my understanding. The internal schemas are for Qlik Cloud to use for processing. We are not to use them and the external/data asset schemas are for users.

regards,

Mohammed

[TimGarrod]

That’s correct.