ArangoDB v3.9 reached End of Life (EOL) and is no longer supported.

This documentation is outdated. Please see the most recent version at docs.arangodb.com

arangoimport Options

Usage: arangoimport [<options>]

General

--auto-rate-limit

Introduced in: v3.7.11

Type: boolean

Adjust the data loading rate automatically, starting at --batch-size bytes per thread per second

This option can be specified without a value to enable it.

Default: false


--backslash-escape

Type: boolean

Use backslash as the escape character for quotes, used for csv

This option can be specified without a value to enable it.

Default: false


--batch-size

Type: uint64

Size for individual data batches (in bytes)

Default: 8388608


--check-configuration

Type: boolean

Check the configuration and exit

This is a command, no value needs to be specified. The process terminates after executing the command.


--collection

Type: string

Collection name

Default: ""


--config

Type: string

The configuration file or 'none'

Default: ""


--configuration

Type: string

The configuration file or 'none'

Default: ""


--convert

Type: boolean

Convert the strings 'null', 'false', 'true' and strings containing numbers into non-string types (csv and tsv only)

This option can be specified without a value to enable it.

Default: true


--create-collection

Type: boolean

Create collection if it does not yet exist

This option can be specified without a value to enable it.

Default: false


--create-collection-type

Type: string

Type of collection if collection is created (edge or document)

Default: "document"

Possible values: “document”, “edge”


--create-database

Type: boolean

Create the target database if it does not exist

This option can be specified without a value to enable it.

Default: false


--datatype

Introduced in: v3.9.0

Type: string…

Force a specific datatype for an attribute (null/boolean/number/string). Use as "attribute=type". For CSV and TSV only. Takes precendence over --convert

Default: []


--define

Type: string…

Define key=value for a @key@ entry in config file

Default: []


--dump-dependencies

Type: boolean

Dump dependency graph

This is a command, no value needs to be specified. The process terminates after executing the command.


--dump-options

Type: boolean

Dump configuration options in JSON format

This is a command, no value needs to be specified. The process terminates after executing the command.


--file

Type: string

File name ("-" for STDIN)

Default: ""


--from-collection-prefix

Type: string

_from collection name prefix (will be prepended to all values in '_from')

Default: ""


--headers-file

Introduced in: v3.8.0

Type: string

Filename to read CSV or TSV headers from. if specified will not try to read headers from regular input file

Default: ""


--ignore-missing

Type: boolean

Ignore missing columns in csv input

This option can be specified without a value to enable it.

Default: false


--latency

Type: boolean

Show 10 second latency statistics (values in microseconds)

This option can be specified without a value to enable it.

Default: false


--log

Deprecated in: v3.5.0

Type: string…

The global or topic-specific log level

Default: ["info"]


--merge-attributes

Introduced in: v3.9.1

Type: string…

Merge attributes into new document attribute (e.g. mergedAttribute=[someAttribute]-[otherAttribute]) (CSV and TSV only)

Default: []


--on-duplicate

Type: string

Action to perform when a unique key constraint violation occurs. Possible values: ignore, replace, update, error

Default: "error"

Possible values: “error”, “ignore”, “replace”, “update”


--overwrite

Type: boolean

Overwrite collection if it exists (WARNING: this will remove any data from the collection)

This option can be specified without a value to enable it.

Default: false


--progress

Type: boolean

Show progress

This option can be specified without a value to enable it.

Default: true


--quote

Type: string

Quote character(s), used for csv

Default: "\""


--remove-attribute

Type: string…

Remove an attribute before inserting documents into collection (for CSV and TSV only)

Default: []


--separator

Type: string

Field separator, used for csv and tsv. Defaults to a comma (csv) or a tabulation character (tsv)

Default: dynamic (e.g. "")


--skip-lines

Type: uint64

Number of lines to skip for formats (csv and tsv only)

Default: 0


--skip-validation

Introduced in: v3.7.0

Type: boolean

Skips document validation during import

This option can be specified without a value to enable it.

Default: false


--threads

Type: uint32

Number of parallel import threads

Default: dynamic (e.g. 36)


--to-collection-prefix

Type: string

_to collection name prefix (will be prepended to all values in '_to')

Default: ""


--translate

Type: string…

Translate an attribute name (use as --translate "from=to", for csv and tsv only)

Default: []


--type

Type: string

Type of import file

Default: "json"

Possible values: “auto”, “csv”, “json”, “jsonl”, “tsv”


--version

Type: boolean

Reports the version and exits

This is a command, no value needs to be specified. The process terminates after executing the command.


--version-json

Introduced in: v3.9.0

Type: boolean

Reports the version as JSON and exits

This is a command, no value needs to be specified. The process terminates after executing the command.

Encryption

--encryption.key-generator

Enterprise Edition only

Type: string

Program providing the encryption key on stdout. If set, encryption will be enabled.

Default: ""


--encryption.keyfile

Enterprise Edition only

Type: string

File containing the encryption key. If set, encryption will be enabled.

Default: ""

Log

--log.color

Type: boolean

Use colors for TTY logging

This option can be specified without a value to enable it.

Default: dynamic (e.g. true)


--log.escape-control-chars

Introduced in: v3.9.0

Type: boolean

Escape control characters when logging

This option can be specified without a value to enable it.

Default: true


--log.escape-unicode-chars

Introduced in: v3.9.0

Type: boolean

Escape unicode characters when logging

This option can be specified without a value to enable it.

Default: false


--log.file

Type: string

Shortcut for '--log.output file://<filename>'

Default: "-"


--log.file-group

Introduced in: v3.4.5

Type: string

Group to use for new log file, user must be a member of this group

Default: ""


--log.file-mode

Introduced in: v3.4.5

Type: string

Mode to use for new log file, umask will be applied as well

Default: ""


--log.force-direct

Type: boolean

Do not start a seperate thread for logging

This option can be specified without a value to enable it.

Default: false


--log.foreground-tty

Type: boolean

Also log to tty if backgrounded

This option can be specified without a value to enable it.

Default: dynamic (e.g. false)


--log.hostname

Introduced in: v3.8.0

Type: string

Hostname to use in log message (empty for none, use 'auto' to automatically figure out hostname)

Default: ""


--log.ids

Introduced in: v3.5.0

Type: boolean

Log unique message ids

This option can be specified without a value to enable it.

Default: true


--log.level

Type: string…

The global or topic-specific log level

Default: ["info"]


--log.line-number

Type: boolean

Include the function name, file name and line number of the source code that issues the log message. Format: [func@FileName.cpp:123]

This option can be specified without a value to enable it.

Default: false


--log.max-entry-length

Introduced in: v3.7.9

Type: uint32

Maximum length of a log entry (in bytes)

Default: 134217728


--log.output

Type: string…

Log destination(s), e.g. file:///path/to/file (any '$PID' will be replaced with the process id)

Default: []


--log.performance

Deprecated in: v3.5.0

Type: boolean

Shortcut for '--log.level performance=trace'

This option can be specified without a value to enable it.

Default: false


--log.prefix

Type: string

Prefix log message with this string

Default: ""


--log.process

Introduced in: v3.8.0

Type: boolean

Show process identifier (pid) in log message

This option can be specified without a value to enable it.

Default: true


--log.request-parameters

Type: boolean

Include full URLs and HTTP request parameters in trace logs

This option can be specified without a value to enable it.

Default: true


--log.role

Type: boolean

Log server role

This option can be specified without a value to enable it.

Default: false


--log.shorten-filenames

Type: boolean

Shorten filenames in log output (use with --log.line-number)

This option can be specified without a value to enable it.

Default: true


--log.thread

Type: boolean

Show thread identifier in log message

This option can be specified without a value to enable it.

Default: false


--log.thread-name

Type: boolean

Show thread name in log message

This option can be specified without a value to enable it.

Default: false


--log.time-format

Introduced in: v3.5.0

Type: string

Time format to use in logs

Default: "utc-datestring"

Possible values: “local-datestring”, “timestamp”, “timestamp-micros”, “timestamp-millis”, “uptime”, “uptime-micros”, “uptime-millis”, “utc-datestring”, “utc-datestring-millis”


--log.use-json-format

Introduced in: v3.8.0

Type: boolean

Use json output format

This option can be specified without a value to enable it.

Default: false


--log.use-local-time

Deprecated in: v3.5.0

Type: boolean

Use local timezone instead of UTC

This option can be specified without a value to enable it.

Default: false


--log.use-microtime

Deprecated in: v3.5.0

Type: boolean

Use microtime instead

This option can be specified without a value to enable it.

Default: false

Random

--random.generator

Type: uint32

Random number generator to use (1 = MERSENNE, 2 = RANDOM, 3 = URANDOM, 4 = COMBINED (not for Windows), 5 = WinCrypt (Windows only)

Default: 1

Possible values: 1, 2, 3, 4

Server

--server.authentication

Type: boolean

Require authentication credentials when connecting (does not affect the server-side authentication settings)

This option can be specified without a value to enable it.

Default: false


--server.connection-timeout

Type: double

Connection timeout in seconds

Default: 5


--server.database

Type: string

Database name to use when connecting

Default: "_system"


--server.endpoint

Type: string…

Endpoint to connect to. Use 'none' to start without a server. Use http+ssl:// as schema to connect to an SSL-secured server endpoint, otherwise http+tcp:// or unix://

Default: ["http+tcp://127.0.0.1:8529"]


--server.max-packet-size

Type: uint64

Maximum packet size (in bytes) for client/server communication

Default: 1073741824


--server.password

Type: string

Password to use when connecting. If not specified and authentication is required, the user will be prompted for a password

Default: ""


--server.request-timeout

Type: double

Request timeout in seconds

Default: 1200


--server.username

Type: string

Username to use when connecting

Default: "root"

SSL

--ssl.protocol

Type: uint64

Ssl protocol (1 = SSLv2 (unsupported), 2 = SSLv2 or SSLv3 (negotiated), 3 = SSLv3, 4 = TLSv1, 5 = TLSv1.2, 6 = TLSv1.3, 9 = generic TLS)

Default: 5

Possible values: 1, 2, 3, 4, 5, 6, 9

Temp

--temp.path

Type: string

Path for temporary files

Default: ""