Dynamically add data to an existing table
I am currently trying to backfill data from an S3 bucket, to SQL server using Alteryx. Unfortunately, there is a lot of data and running a month at a time crashes our server.
I'm trying to find a way to build a SQL statement, that will look for a MAX() date that is currently in the dataset, and then subsequently add/append the next 3+ days of data to my table. Is this functionality possible, and if so, any suggestions on the query?
I would like to then schedule this query to run overnight so we can start populating this table.