Dremio Cloud
Dremio Software
 
On this page

    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

    Example Output

    id timestamp action event_type status user_id details
    nwseswacjqv2jv25 2022-02-01 21:22:25.422 SCALE_UP_STARTED ENGINE OK 678cc92c-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”:[]}
    029oip5i7pkpyr4s 2022-02-01 21:22:25.435 SCALE_UP_COMPLETED ENGINE OK 678cc92c-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”:[]}
    liqdx83ihwzr85qx 2022-02-01 21:24:37.910 UPDATE TABLE OK 678cc92c-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”}
    8wvxcsu84433reng 2022-02-01 21:29:52.092 SCALE_DOWN_STARTED ENGINE OK 678cc92c-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”:[]}
    egpnz1fru74f5l96 2022-02-01 21:29:52.100 SCALE_DOWN_COMPLETED ENGINE OK 678cc92c-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”:[]}
    47cd91ye16pvagn3 2022-02-03 13:21:01.510 CREATE SOURCE OK 1 {“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

    Field Data Type Description
    id varchar The UUID to identify the event.
    timestamp timestamp The date and time at which the event occurred.
    action varchar The type of action that triggered the event.
    event_type varchar The object that the event was triggered on.
    status varchar The status of the event.
    user_id varchar The UUID to identify the user who triggered the event.
    details json The updated state of the object that was edited and any additional event details.