When Panoply ingests data into tables in your warehouse, the Panoply system automatically appends a field called
__updatetime to each table. This field contains a timestamp from when each record in your data was updated. Therefore, querying this field will provide information about when your data was updated.
To identify the most recent update to a particular table, you can run the following query shown below. Replace
mytable with the name of the table you want to check.
SELECT MAX(__updatetime) FROM "mytable";
On the other hand, to identify the first update to a particular table, you can run the following query:
SELECT MIN(__updatetime) FROM "mytable";
Better, you can run the two previous queries as one:
SELECT MAX(__updatetime), MIN(__updatetime) FROM "mytable";
Note that the
__updatetime field is only available for tables that were created by one of Panoply's data sources. Other 3rd party ingestion tools will most likely have similar methods to keep the update time for each record that will depend on the way they structure their tables.