arangoimport Options

Usage: arangoimport [<options>]

General

NameTypeDescription
auto-rate-limitbooleanAdjust the data loading rate automatically, starting at —batch-size bytes per thread per second
This option can be specified without value to enable it.
Default: false
Introduced in: v3.7.11
backslash-escapebooleanUse backslash as the escape character for quotes, used for csv
This option can be specified without value to enable it.
Default: false
batch-sizeuint64Size for individual data batches (in bytes)
Default: 8388608
check-configurationbooleanCheck the configuration and exit
This is a command, no value needs to be specified. The process terminates after executing the command.
collectionstringCollection name
Default: “”
configstringThe configuration file or ‘none’
Default: “”
configurationstringThe configuration file or ‘none’
Default: “”
convertbooleanConvert the strings ‘null’, ‘false’, ‘true’ and strings containing numbers into non-string types (csv and tsv only)
This option can be specified without value to enable it.
Default: true
create-collectionbooleanCreate collection if it does not yet exist
This option can be specified without value to enable it.
Default: false
create-collection-typestringType of collection if collection is created (edge or document)
Default: “document”
Possible values: “document”, “edge”
create-databasebooleanCreate the target database if it does not exist
This option can be specified without value to enable it.
Default: false
definestring…Define key=value for a @key@ entry in config file
Default: []
dump-dependenciesbooleanDump dependency graph
This is a command, no value needs to be specified. The process terminates after executing the command.
dump-optionsbooleanDump configuration options in JSON format
This is a command, no value needs to be specified. The process terminates after executing the command.
filestringFile name (“-“ for STDIN)
Default: “”
from-collection-prefixstring_from collection name prefix (will be prepended to all values in ‘_from’)
Default: “”
headers-filestringFilename to read CSV or TSV headers from. if specified will not try to read headers from regular input file
Default: “”
Introduced in: v3.8.0
ignore-missingbooleanIgnore missing columns in csv input
This option can be specified without value to enable it.
Default: false
latencybooleanShow 10 second latency statistics (values in microseconds)
This option can be specified without value to enable it.
Default: false
logstring…The global or topic-specific log level
Default: [“info”]
Deprecated in: v3.5.0
on-duplicatestringAction to perform when a unique key constraint violation occurs. Possible values: ignore, replace, update, error
Default: “error”
Possible values: “error”, “ignore”, “replace”, “update”
overwritebooleanOverwrite collection if it exist (WARNING: this will remove any data from the collection)
This option can be specified without value to enable it.
Default: false
progressbooleanShow progress
This option can be specified without value to enable it.
Default: true
quotestringQuote character(s), used for csv
Default: “\””
remove-attributestring…Remove an attribute before inserting an attribute into a collection (for csv and tsv only)
Default: []
separatorstringField separator, used for csv and tsv. Defaults to a comma (csv) or a tabulation character (tsv)
Default: dynamic (e.g. “”)
skip-linesuint64Number of lines to skip for formats (csv and tsv only)
Default: 0
skip-validationbooleanSkips document validation during import
This option can be specified without value to enable it.
Default: false
Introduced in: v3.7.0
threadsuint32Number of parallel import threads
Default: 2
to-collection-prefixstring_to collection name prefix (will be prepended to all values in ‘_to’)
Default: “”
translatestring…Translate an attribute name (use as —translate “from=to”, for csv and tsv only)
Default: []
typestringType of import file
Default: “json”
Possible values: “auto”, “csv”, “json”, “jsonl”, “tsv”
versionbooleanReports the version and exits
This is a command, no value needs to be specified. The process terminates after executing the command.

Encryption

NameTypeDescription
encryption.key-generatorstringEnterprise Edition only
Program providing the encryption key on stdout. If set, encryption will be enabled.
Default: “”
encryption.keyfilestringEnterprise Edition only
File containing the encryption key. If set, encryption will be enabled.
Default: “”

Log

NameTypeDescription
log.colorbooleanUse colors for TTY logging
This option can be specified without value to enable it.
Default: dynamic (e.g. true)
log.escapebooleanEscape characters when logging
This option can be specified without value to enable it.
Default: true
log.filestringShortcut for ‘—log.output file://‘
Default: “-“
log.file-groupstringGroup to use for new log file, user must be a member of this group
Default: “”
Introduced in: v3.4.5
log.file-modestringMode to use for new log file, umask will be applied as well
Default: “”
Introduced in: v3.4.5
log.force-directbooleanDo not start a seperate thread for logging
This option can be specified without value to enable it.
Default: false
log.foreground-ttybooleanAlso log to tty if backgrounded
This option can be specified without value to enable it.
Default: dynamic (e.g. false)
log.hostnamestringHostname to use in log message (empty for none, use ‘auto’ to automatically figure out hostname)
Default: “”
Introduced in: v3.8.0
log.idsbooleanLog unique message ids
This option can be specified without value to enable it.
Default: true
Introduced in: v3.5.0
log.levelstring…The global or topic-specific log level
Default: [“info”]
log.line-numberbooleanInclude 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 value to enable it.
Default: false
log.max-entry-lengthuint32Maximum length of a log entry (in bytes)
Default: 134217728
Introduced in: v3.7.9
log.outputstring…Log destination(s), e.g. file:///path/to/file (any ‘$PID’ will be replaced with the process id)
Default: []
log.performancebooleanShortcut for ‘—log.level performance=trace’
This option can be specified without value to enable it.
Default: false
Deprecated in: v3.5.0
log.prefixstringPrefix log message with this string
Default: “”
log.processbooleanShow process identifier (pid) in log message
This option can be specified without value to enable it.
Default: true
Introduced in: v3.8.0
log.request-parametersbooleanInclude full URLs and HTTP request parameters in trace logs
This option can be specified without value to enable it.
Default: true
log.rolebooleanLog server role
This option can be specified without value to enable it.
Default: false
log.shorten-filenamesbooleanShorten filenames in log output (use with —log.line-number)
This option can be specified without value to enable it.
Default: true
log.threadbooleanShow thread identifier in log message
This option can be specified without value to enable it.
Default: false
log.thread-namebooleanShow thread name in log message
This option can be specified without value to enable it.
Default: false
log.time-formatstringTime 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”
Introduced in: v3.5.0
log.use-json-formatbooleanUse json output format
This option can be specified without value to enable it.
Default: false
Introduced in: v3.8.0
log.use-local-timebooleanUse local timezone instead of UTC
This option can be specified without value to enable it.
Default: false
Deprecated in: v3.5.0
log.use-microtimebooleanUse microtime instead
This option can be specified without value to enable it.
Default: false
Deprecated in: v3.5.0

Random

NameTypeDescription
random.generatoruint32Random 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

NameTypeDescription
server.authenticationbooleanRequire authentication credentials when connecting (does not affect the server-side authentication settings)
This option can be specified without value to enable it.
Default: false
server.connection-timeoutdoubleConnection timeout in seconds
Default: 5
server.databasestringDatabase name to use when connecting
Default: “_system”
server.endpointstringEndpoint to connect to. Use ‘none’ to start without a server. Use http+ssl:// or vst+ssl:// as schema to connect to an SSL-secured server endpoint, otherwise http+tcp://, vst+tcp:// or unix://
Default: “http+tcp://127.0.0.1:8529”
server.force-jsonbooleanForce to not use VelocyPack for easier debugging
This option can be specified without value to enable it.
Default: false
Introduced in: v3.6.0
server.max-packet-sizeuint64Maximum packet size (in bytes) for client/server communication
Default: 1073741824
server.passwordstringPassword to use when connecting. If not specified and authentication is required, the user will be prompted for a password
Default: “”
server.request-timeoutdoubleRequest timeout in seconds
Default: 1200
server.usernamestringUsername to use when connecting
Default: “root”

SSL

NameTypeDescription
ssl.protocoluint64Ssl 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

NameTypeDescription
temp.pathstringPath for temporary files
Default: “”