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

    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.