topic Re: What are these views in the datamart internal schema? in Data Movement & Streaming

What are these views in the datamart internal schema?

MoeE — Wed, 19 Mar 2025 23:02:17 GMT

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

Re: What are these views in the datamart internal schema?

TimGarrod — Tue, 25 Jul 2023 19:14:43 GMT

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.

Re: What are these views in the datamart internal schema?

MoeE — Tue, 25 Jul 2023 23:11:15 GMT

Hi Tim,

Thanks for the info mate, much appreciated.

Regards,

Mohammed

Re: What are these views in the datamart internal schema?

MoeE — Tue, 25 Jul 2023 23:15:57 GMT

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

Re: What are these views in the datamart internal schema?

TimGarrod — Thu, 27 Jul 2023 01:46:28 GMT

That’s correct.