I am working with a database that doesn't save historical data. I.e. rows get an override every once in a while, and an old record doesn't exist anymore.
Is there a way to have Query Editor import the data and save it to, say, another table every time and not refresh that data again? Upon refresh, I'd lose all the rows that got an override between 2 refreshes. The process would be smth like this: import new data -> append to the data from the last import -> remove duplicates.
For now that process was to do a CSV import out of the database on a regular basis, save it on the local drive with a timestamp, and then let Query Editor import all the csv files and kill the duplicates. But I want to avoid the CSV file step and do it directly in Query Edtior.
Another way is to have my DBA create a custom table like this, but I want to see if I can do this on my own before rattling that cage.