Skip to main content

SYS.PROJECT.HISTORY.EVENTS

The sys.project.history.events table contains the historical metadata for the events in a project.

Syntax
SELECT *
FROM sys.project.history.events
note

Dremio refreshes the data in sys.project.history.events once per hour, so it usually takes about 1 hour for event information to appear. If an event occurs soon after Dremio's hourly refresh and takes a long time to finish, it could take more than 1 hour for the event's data to appear in the sys.project.history.events table.

Example Output

idtimestampactionevent_typestatususer_iddetails
nwseswacjqv2jv252022-02-01 21:22:25.422SCALE_UP_STARTEDENGINEOK678cc92c-01ed-4db3-9a28-d1f871042d9f{"activeReplicas":0,"autoStopDelaySecs":0,"description":"","drainTimeLimitSecs":0,"engineCapacity":"XX_SMALL_V1","engineId":"99317a9f-ffbc-4acf-a9ce-a649dd7892b0","engineName":"First Engine","maxConcurrency":0,"maxReplicas":10,"minReplicas":0,"queueTimeLimitSecs":0,"requestId":"","runTimeLimitSecs":0,"tags":[]}
029oip5i7pkpyr4s2022-02-01 21:22:25.435SCALE_UP_COMPLETEDENGINEOK678cc92c-01ed-4db3-9a28-d1f871042d9f{"activeReplicas":1,"autoStopDelaySecs":0,"description":"","drainTimeLimitSecs":0,"engineCapacity":"XX_SMALL_V1","engineId":"99317a9f-ffbc-4acf-a9ce-a649dd7892b0","engineName":"First Engine","maxConcurrency":0,"maxReplicas":10,"minReplicas":0,"queueTimeLimitSecs":0,"requestId":"","runTimeLimitSecs":0,"tags":[]}
liqdx83ihwzr85qx2022-02-01 21:24:37.910UPDATETABLEOK678cc92c-01ed-4db3-9a28-d1f871042d9f{"approximateStatisticsAllowed":false,"fields":[{"dataType":"DATETIME","name":"pickup_datetime"},{"dataType":"INTEGER","name":"passenger_count"},{"dataType":"FLOAT","name":"trip_distance_mi"},{"dataType":"FLOAT","name":"fare_amount"},{"dataType":"FLOAT","name":"tip_amount"},{"dataType":"FLOAT","name":"total_amount"}],"icebergmetadataenabled":true,"id":"0678823d-1281-431b-b47d-35b5d4ab3a29","name":"NYC-taxi-trips","path":"Samples.\"samples.dremio.com\".\"NYC-taxi-trips\"","tag":"245d0c38-7d57-48f8-bacb-af2eaf06caef","type":"PHYSICAL_DATASET_SOURCE_FOLDER"}
8wvxcsu84433reng2022-02-01 21:29:52.092SCALE_DOWN_STARTEDENGINEOK678cc92c-01ed-4db3-9a28-d1f871042d9f{"activeReplicas":1,"autoStopDelaySecs":0,"description":"","drainTimeLimitSecs":0,"engineCapacity":"XX_SMALL_V1","engineId":"99317a9f-ffbc-4acf-a9ce-a649dd7892b0","engineName":"First Engine","maxConcurrency":0,"maxReplicas":10,"minReplicas":0,"queueTimeLimitSecs":0,"requestId":"","runTimeLimitSecs":0,"tags":[]}
egpnz1fru74f5l962022-02-01 21:29:52.100SCALE_DOWN_COMPLETEDENGINEOK678cc92c-01ed-4db3-9a28-d1f871042d9f{"activeReplicas":0,"autoStopDelaySecs":0,"description":"","drainTimeLimitSecs":0,"engineCapacity":"XX_SMALL_V1","engineId":"99317a9f-ffbc-4acf-a9ce-a649dd7892b0","engineName":"First Engine","maxConcurrency":0,"maxReplicas":10,"minReplicas":0,"queueTimeLimitSecs":0,"requestId":"","runTimeLimitSecs":0,"tags":[]}
47cd91ye16pvagn32022-02-03 13:21:01.510CREATESOURCEOK1{"accelerationGracePeriod":0,"accelerationNeverExpire":false,"accelerationNeverRefresh":false,"accelerationRefreshPeriod":0,"allowCrossSourceSelection":false,"configJson":"{\"type\":\"HistoryTablesPluginConfig\",\"distStorePath\":\"dremioS3:///auditloginternalorg\",\"projectId\":\"b2d94403-dacc-4443-a78e-76df29251b47\",\"credentialProvider\":\"com.dremio.service.coordinator.DremioAssumeRoleCredentialsProviderV1\",\"accessKey\":null,\"secretKey\":null,\"iamRole\":\"SECRET\",\"externalId\":\"SECRET\",\"rootFolder\":\"internaldatalake\"}","description":"","disableMetadataValidityCheck":false,"id":"5009ccd4-e894-4446-91d2-e6ab6d6c22a4","metadataPolicy":{"authTTLMs":3153600000000,"autoPromoteDatasets":false,"datasetDefinitionExpireAfterMs":3153600000000,"datasetDefinitionRefreshAfterMs":3153600000000,"datasetUpdateMode":"UPDATE_MODE_PREFETCH","deleteUnavailableDatasets":true,"namesRefreshMs":3153600000000},"name":"projectstore","tag":"HISTORYTABLES","type":"HISTORYTABLES"}

Fields

FieldData TypeDescription
idvarcharThe UUID to identify the event.
timestamptimestampThe date and time at which the event occurred.
actionvarcharThe type of action that triggered the event.
event_typevarcharThe object that the event was triggered on.
statusvarcharThe status of the event.
user_idvarcharThe UUID to identify the user who triggered the event.
detailsjsonThe updated state of the object that was edited and any additional event details.