Global Flags

Global flags specify runtime program behavior for the StackQL application, these flags are set at the command line when the StackQL application is launched (in either the interactive/shell mode or non-interactive exec mode) or are sourced from the StackQL initialization (.stackqlrc) file. Flags include:

Flag	Data Type	Description	Default
--acid	string	JSON / YAML string representing ACID config	{}
--apirequesttimeout	integer	API request timeout in seconds, 0 for no timeout	45
--approot	string	Application config and cache root path	{cwd}/.stackql
--approotfilemode	uint32	Application config and cache file mode	493
--auth	string	auth context keyvals in json form
--cachekeycount	integer	Cache initial key count	100
--colorscheme	string	Color scheme used in the shell must be one of {dark, light, null}; applies to Linux and Mac only	null
--configfile	string	Config file full path	{cwd}/.stackqlrc
--cpuprofile	string	cpuprofile file, none if empty	null
--cpuprofile	string	cpuprofile file, none if empty	null
--dataflow.dependency.max	int	Maximum dataflow dependency depth for a given query	1
--dbInternal	string	JSON / YAML string to configure DBMS housekeeping query handling	{}
-d, --delimiter	string	Delimiter for csv output. Single char only.  Ignored for all non-csv output	,
--dryrun	flag	dryrun flag; run preprocessor only, templated output will be returned	false
--execution.concurrency.limit	int	Concurrency limit for query execution	1
--gc	string	JSON / YAML string representing GC config	{}
-H, --hideheaders	flag	Disables column headers, valid only with --output csv or --output text	false
--http.log.enabled	flag	Display http request info in terminal	false
--http.proxy.host	string	Proxy host (leave blank for no proxy)	null
--http.proxy.password	string	Proxy password	null
--http.proxy.port	integer	Proxy port, any number <=0 will result in the default port for a given scheme (e.g. http -> 80)	-1
--http.proxy.scheme	string	Proxy scheme, {http or https}	http
--http.proxy.user	string	Proxy user	null
--http.response.maxResults	integer	Maximum results per http request, any number <=0 results in no limitation	-1
--http.response.pageLimit	integer	Maximum pages of results that will be returned per resource, any number <=0 results in no limitation	20
--indirect.depth.max	integer	Maximum depth for indirect queries: views and subqueries	5
-i, --infile	string	Input file (IQL file) from which queries are read	{stdin}
-q, --iqldata	string	Context (data) file for templating (json or jsonnet file)
--loglevel	string	Log level, must be one of {info, warn, debug, fatal}	fatal
--metadatattl	integer	TTL for cached metadata documents, in seconds	3600
--namespaces	string	JSON / YAML string representing namespaces for caching, views etc	{}
--offline	flag	Work offline, using cached data	false
-f, --outfile	string	Output file into which results are written	{stdout}
-o, --output	string	Output format, must be one of {json, table, csv, text}	table
--querycachesize	integer	Size in number of entries of LRU cache for query plans	10000
--registry	string	openapi registry context keyvals in json form
--sqlBackend	string	JSON / YAML string representing SQL Backend System Config	{}
--store.txn	string	JSON / YAML string representing Txn store config	{}
--tls.CABundle	string	Path to CA bundle, if not specified then system defaults used
--tls.allowInsecure	flag	Allow trust of insecure certificates (not recommended)
--var	string	External variables provided as key/value pairs for sourcing into StackQL queries through jsonnet data files
-v, --verbose	flag	Verbose output	false
-h, --help		Context specific help for stackql
--version		Displays the version of the StackQL program