On this page

    Export Profiles

    The Dremio administration export-profiles command allows you to export Job profiles to the specified location.

    The export-profiles option supports 3 modes:

    • Default (requires dremio to be running)
    • Local-attach (requires dremio to be running)
    • Offline (dremio should not be running)

    Syntax

    ./dremio-admin export-profiles --output <options>
    

    Options

    ParameterDescription
    -h, –helpShows usage.
    –output(Required) Path to generate profile chunks. Example: /tmp/profiles/
    –write-modeSpecifies how we should handle a case, when target file already exists. Valid values are [FAIL_IF_EXISTS (default), OVERWRITE and SKIP.
    –fromExport profiles beginning from this date inclusively (job_end_time >= toDate). Example: 2011-12-03T10:15:30
    –toExport profiles ending by this date exclusively (job_end_time < toDate). Example: 2011-12-03T10:15:30
    -u, –userUsername (administrator). Is required for online mode [–online].
    -p, –passwordPassword. Required for online mode [–online].
    -a, –accept-allAccept all ssl certificates. Default value is false.
    –sizeChunk size for each zip file. hidden = true
    –local-pathDefault local path to export. hidden = true
    –formatFormat in which profiles should be exported. .json and .zip (default) are supported.
    -l, –local-attachAttach locally to Dremio JVM to authenticate user. Not compatible with user/password options. Default value is false.
    -o, –offlineAppend this option to use offline export. Default value is false.

    Examples

    The following examples show default, local-attach, and offline mode usage.

    Default mode

    The default mode requires the following:

    • Dremio is running
    • user & password are required. If not provided in cli, will be prompted.

    usage

    ./dremio-admin export-profiles --output /tmp/profiles -u user -p password
    

    output message
    The output message is available on console. If no jobs are processed, then the output path is not provided.

    The following output shows 50 jobs processed and the output path:

    Export completed. Jobs processed: 50, profiles processed: 34, profiles skipped: 0
    Output path: /tmp/profiles/14581e7c-0302-474e-aaef-5667051e345b
    

    The following output shows 0 jobs process:

    Export completed. Jobs processed: 0, profiles processed: 0, profiles skipped: 0
    

    Local-attach mode

    The local-attach mode requires the following:

    • Dremio is running. (the user & password are not required)
    • The -l or --local-attach option is required.
    • The command should be run by the same local user who started the Dremio cluster.

    usage

    ./dremio-admin export-profiles --output ~/tmp/profiles -l
    

    output message
    The output message is available in server.out since in local attach mode we attach to main process.

    Offline mode

    The offline mode requires the following:

    • Dremio is not running (the user & password are not required)
    • The -o or --offline option is required

    usage

    ./dremio-admin export-profiles --output ~/temp/profiles -o
    

    output message
    The output message is available on console.