Recently (the past week or so) when I run a job that updates data on a table a pop-appears with the following message:
"The Job [job name] updates table metadata. [job name] needs to be refreshed to use any changes made to table metadata. Refreshing [job name] will remove the ability to undo any previous changes.
Do you want to refresh [job name]?
(check box) Do not show this message again"
Any idea why this pop-up is now appearing? Is it a setting that was maybe switched? Is there something here I should start heeding?
Thanks!
As I understand it, tables used in DI Studio jobs are required to be registered in SAS metadata. The popup is warning you that the underlying table metadata has changed. For example this could be the result of a column addition, deletion or change.
If you want your DI job to take advantage of these changes then you need to do the refresh.as advised. I suggest you investigate what has changed before deciding whether to do it or not.
Are you by any chance using the Transpose transformation?
@Patrick, @LinusH, you are both correct. User Written/Transpose transformations are in the jobs, and buried within those, the 'Summary Tables' node has the 'Update the metada for the target tables' set to 'Yes'. I believe this is the correct setting as the Summary Tables node outputs a table summarizing the data.
So, perhaps in this case, this shouldn't be set to 'yes' then?
Depends on the purpose of this particular job, and you ETL design pattern/maintenance.
But generally I would avoid steps that could create variable output, could cause warnings/errors.
In the Transpose case (if transposing from long to wide) I would recommend a preceding Extract so it will be predictable which columns gets created in the Transpose.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.