Data Load Status Data

This data set contains the last time each table was updated with new information

How much data is retained?

There is a row for each data set. All data is retained unless

What data can be pulled?

Column NameTypeNullableDefaultDescription
TABLE_NAMEVARCHAR(13)TRUEN/AThe name of the table that was updated
LAST_LOADED_ATTIMESTAMP_TZ(9)TRUEN/AThe time that the data was uploaded. The time is set as the time zone of the account

Sample Query

–- A query that will pull clicks from yesterday
SELECT
TABLE_NAME
,LAST_LOADED_AT 
FROM DATA_LOAD_STATUS