We have a table that is managed by a different company that we are accompanying. Every month, there is a spreadsheet that needs to be imported from the official source into the INFO table.
In Production there is a call being made and the call is working perfectly. However in DEV & UAT the call is not working correctly. The requirement now is create a new table in DEV & UAT with the same info in PROD. The spreadsheet is already uploading to the data warehouse on a schedule, so we could potentially be ingesting it directly from there instead of needing to manually process a spreadsheet.
When I check DEV and UAT, there is a INFO table that includes the same table/structure/data as in PROD. The data in DEV & UAT are repeated and inconsistent. So I am confused as to why I would need to create the same table.
How/Where can I figure out the answers to these set of questions below in SQL Server?:
-Is the data in this table modified in any way?
-What is the data refresh frequency of this table?
-Do they keep historical data for each month this gets loaded? e.g. to do need to run a query to always grab the latest INFO table?