I normally consider a custom transformation as a reusable artefact and as such one should put a bit of effort into it to make it robust and performing.
What you propose here is a process which every single time needs to read the whole source data set whether it's a "backup day" or not.
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.