topic Re: SAS table metadata update in SAS Data Management

SAS table metadata update

keerthi78890976 — Thu, 05 Sep 2019 13:19:30 GMT

Hi All,

We are registering tables in the metadata for third-party databases.When we update the metadata again with a different user the last modified time is getting updated, the last modified by option for these tables which shows up in the DI is not getting updated. Is this the default behavior? Could you please comment.

Re: SAS table metadata update

SAS_Cares — Thu, 05 Sep 2019 14:47:24 GMT

This blog post provides some insights and it also links to some documentation on this topic https://blogs.sas.com/content/sgf/2013/12/25/sas-metadata-and-third-party-databases-an-faq/

Let us know if it helps!

Re: SAS table metadata update

keerthi78890976 — Fri, 06 Sep 2019 08:52:45 GMT

We are using SAS 9.4 M6 on RHEL machines.

When we are connecting to third-party database (snowflake through odbc engine) and trying to register the metadata table, we are able to register successfully. After few changes to snowflake table, when a different user updates the metadata the last modified time is getting updated, but the last modified by option for the tables is not getting updated. The last modified by column still shows the name of the person who has registered the table. The metadata logs are showing the correct name who had updated the table recently but why is this not getting updated in the SAS DI studio. Is this the default behaviour or there is something we should change at configuration level? Could you please comment.