astra db cqlsh exec
astra db cqlsh exec [-qV] [--debug] [--no-input] [--[no-]spinner] [--color
[=WHEN]] [--dump-logs[=FILE]] [-b=PATH]
[--connect-timeout=TIMEOUT] [--encoding=ENCODING]
[-k=KEYSPACE] [-o=FORMAT] [-r=REGION]
[--request-timeout=TIMEOUT] [[[-cf=PATH] [-p=NAME]] |
[--token=TOKEN [--env=ENV]]] [-e[=STATEMENT] | -f=FILE] [DB]Execute CQL statements for your db using cqlsh
Options
DB-
The name/ID of the Astra database to connect to
--debug-
Show additional debugging information
--encoding-
Output encoding (default: utf8)
--connect-timeout-
Connection timeout in seconds
-b,--secure-connect-bundle-
Path to the secure connect bundle to use for authentication instead of the database name
-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.
-e,--execute-
Execute the statement then exit
-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. Can be set viaASTRA_PROFILE. --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 -e "SELECT * FROM my_keyspace.my_table"
# Execute a CQL file
$ astra db cqlsh exec my_db -f script.cql