How can I determine the last update of my tables?

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.