On this page

    Logs preview

    The SQL command for logs enable you to show logs in your Nessie repository.

    note:

    If you are using these SQL commands in engines other than Dremio Sonar, the SQL syntax may differ:

    Showing Logs

    The SHOW LOGS command enables you to show all the logs that are available in a project’s Nessie repository.

    Syntax
    SHOW LOGS
       [ AT ( REF[ERENCE] | BRANCH | TAG | COMMIT ) <refValue> ]
       [ IN <nessie_name> ]
    

    Parameters

    AT ( REF[ERENCE] | BRANCH | TAG | COMMIT ) <refValue>

    String

    Optional

    Specify a reference point where you want to show the logs from. When this parameter is omitted, the current reference point is used.

    • REF or REFERENCE: Identifies the branch, tag, or commit that you want to show the available logs from.
    • BRANCH: Shows the available logs in the specified branch.
    • TAG: Shows the available logs in the specified tag.
    • COMMIT: Shows the available logs in the specified commit. Commit hashes must be enclosed in double quotes (for example, “ff2fe50fef5a030c4fc8e61b252bdc33c72e2b6f929d813833d998b8368302e2”).
    .


    IN <nessie_name>

    String

    Optional

    The name of the Nessie repository that you want to show the available logs in. When this parameter is omitted, the current Nessie repository is used.