Forum Discussion
TimeStamp - Help
amirzoyan Right, so with Premium I believe you could use Goals to get snapshots at points in time. Otherwise, you would have to import the data for each month in a query that you disable reload and append all the tables together essentially. Doable but not pretty or elegant. Problem is that it doesn't sound like your source system is preserving historical information like, say, a slowly changing dimension. So you are going to have to preserve that historical information somehow in some other system. I would spin up an Azure SQL database and create an Azure Data Factory job to periodically import the data, you timestamp it at the time of the import and you just keep appending rows.
amirzoyan Right, so with Premium I believe you could use Goals to get snapshots at points in time. Otherwise, you would have to import the data for each month in a query that you disable reload and append all the tables together essentially. Doable but not pretty or elegant. Problem is that it doesn't sound like your source system is preserving historical information like, say, a slowly changing dimension. So you are going to have to preserve that historical information somehow in some other system. I would spin up an Azure SQL database and create an Azure Data Factory job to periodically import the data, you timestamp it at the time of the import and you just keep appending rows.