astra db cqlsh exec
astra db cqlsh exec [-qV] [--debug] [--no-input] [--[no-]spinner] [--dump-logs
[=FILE]] [--color=WHEN] [--connect-timeout=TIMEOUT]
[--encoding=ENCODING] [-f=FILE] [-k=KEYSPACE] [-o=FORMAT]
[-r=REGION] [--request-timeout=TIMEOUT] [[[-cf=PATH]
[-p=NAME]] | [--token=TOKEN [--env=ENV]]] [DB] [STATEMENT]Execute CQL statements for your db using cqlsh
Options
DB-
The name/ID of the Astra database to connect to
STATEMENT-
Execute the statement and quit
--debug-
Show additional debugging information
--encoding-
Output encoding (default: utf8)
--connect-timeout-
Connection timeout in seconds
-k,--keyspace-
Authenticate to the given keyspace
--request-timeout-
Request timeout in seconds
-r,--region-
The region to use. Uses the db’s default region if not specified.
-f,--file-
Execute commands from a CQL file, then exit
Common Options
-o,--output-
One of: human, json, csv
-V,--verbose-
Enable verbose logging output
-q,--quiet-
Only output essential information
--spinner-
Enable/disable loading spinners
--no-input-
Don’t ask for user input (e.g. confirmation prompts)
--color-
One of: auto, never, always
--dump-logs-
Write all logs to an optionally specified file
Connection Options
-cf,--config-file-
The
.astrarcfile to use for this command -p,--profile-
The
.astrarcprofile to use for this command --token-
The astra token to use for this command. Use the
--token @filesyntax to read the token from a file, to avoid potential leaks. --env-
Override the target astra environment
Examples
# Execute a CQL statement
$ astra db cqlsh exec my_db "SELECT * FROM my_keyspace.my_table"
# Execute a CQL file
$ astra db cqlsh exec my_db -f script.cql