Skip to main content
Version: 24.3.x

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

Syntax for export-profiles command
./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.
Export profiles in default mode
./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 profiles command output example for 50 jobs
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 profiles command output example for 0 jobs
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.
Local-attach mode command
./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
Offline mode command
./dremio-admin export-profiles --output ~/temp/profiles -o

output message
The output message is available on console.