The Refresh analysis is provided as a means to re-execute a chain of referenced analyses with a different set of user specified parameters without modifying the original analyses. It falls under the ADS umbrella because it is designed to allow the user to refresh an analytic data set. However, in addition to ADS analyses, it may also be used to refresh Score analyses.
- The first way is to reproduce the entire set of analyses used to generate the analytic data set with the new modified parameters. This is not ideal; if it is a complicated set of analyses, it could take a significant amount of time to reproduce it when you only wanted to change a few things.
- The second way is to actually change the original analyses with new parameters. The problem with this is that the original ADS template is now permanently changed.
With the Refresh Analysis, the original analyses can be re-executed with the modified parameters without affecting the original parameters used. If any of the parameters are not selected to be changed, then the original values are used. When Refresh is run, the analysis to be refreshed is executed (along with any analyses that it references) using the new parameters specified within Refresh. In addition, the referenced analyses will only generate the columns needed for the analysis that is being refreshed, based on column names (subject to some exceptions described below).
Column limiting and certain metadata gathering features are bypassed for certain special-purpose analyses such as those that represent subqueries or seed or recursive components of With (Recursive) queries. These features are also bypassed for any analyses that follow them in a chain of refreshed analyses. If, however, a bypassed analysis is also referenced by a non-bypassed analysis, a warning message is given to warn of possibly unexpected results:
An analysis being refreshed, '...', is referenced both by a bypassed analysis (such as a Subquery or With Recursive Query) and a non-bypassed analysis, possibly leading to unexpected results.It is worth noting that the anchor table replacement feature is not supported for the same special-purpose analyses mentioned above, for the base query of a With (Recursive) analysis, or for analyses that produce a score table or do not have anchor columns selected. However, other bypassed analyses (i.e., those referenced by subquery or With (Recursive) analyses) do support anchor table replacement if they have anchor columns selected.