Last Modified dates for MV/Tables in a schema

srini_ch — Fri, 10 Jun 2022 13:10:33 GMT

Hi,

How do I retrieve the creation date, created by, modified by, modified date details for all the objects (such as tables/MVs/Alias/Incorta tables) within a physical schema?

Thanks,

Re: Last Modified dates for MV/Tables in a schema

dylanwan — Fri, 10 Jun 2022 15:45:34 GMT

The changes to the schema definition can be audited using the ACTION table in IncortaMetadata. We tracked the changes at the schema level, not at the table level. However, it is a best practice to schedule the backup of the tenant (all metatdata about schema, dashboard, etc) in your DEV env as well as in the Production env. It can be done by scheduling the backup from CMC. With the ACTION table and reports on the IncortaMetadata dashboard and the backup files, you should be able to identify the change made. Another utility available (upon request via support) is a tenant comparison tool, which can compare any two tenant backup and show the difference.

Hope this helps.

topic Last Modified dates for MV/Tables in a schema in Data & Schema Discussions

Last Modified dates for MV/Tables in a schema

Re: Last Modified dates for MV/Tables in a schema