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 Name | Type | Nullable | Default | Description |
---|---|---|---|---|
TABLE_NAME | VARCHAR(13) | TRUE | N/A | The name of the table that was updated |
LAST_LOADED_AT | TIMESTAMP_TZ(9) | TRUE | N/A | The 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
Updated over 1 year ago