Convert query to static table

I am attempting to convert a dashboard that is fed from SQL server into an example piece to be shown to an audience outside of our organizaiton. Because this will no longer be a "live" dashboard, I need to put the current data into static tables that will not be updated and will add a new date field that will contain forward looking dates (~5 years ahead) so that certain metrics will continue to be valid (MTD, YTD, QTD, etc). I no longer have access to the server credentials, so am limited in what I can do in the query editor. Additionally, the data is so massive that copy/paste into a new table is not an option without breaking it up and appending later which will be extremely time consuming. Is there another alternative?

Summary: I need to take exisiting data and break the connection to SQL server and put it into a static table for further manipulation.

Thank you