topic List of columns in Incorta tables / MVs in Administrative Discussions

List of columns in Incorta tables / MVs

RADSr — Mon, 21 Aug 2023 14:15:16 GMT

[edit: Of course, as soon as I hit "post" I remembered the Inspector Tool and the InspectorMetadata schema -- leaving this here to curb my hubris and as a quick answer if anyone else searches for this topic.]

I could have sworn I saw an article on getting a list of columns used in Incorta tables, but I'm not finding it now.

So - is there way to query the Incorta metadata and return all schema.table.column names from a tenant?

Re: List of columns in Incorta tables / MVs

JoeM — Mon, 21 Aug 2023 17:58:23 GMT

Only commenting so we can mark it answered!

Re: List of columns in Incorta tables / MVs

anurag — Tue, 05 Sep 2023 14:58:28 GMT

@RADSr there is another way to do this.

Check out this video:

https://youtu.be/Y71eERIY6nY