astra db dsbulk count
astra db dsbulk count [-qV] [--no-input] [--[no-]spinner] [--color[=WHEN]]
[--dump-logs[=FILE]] [--dsbulk-config=CONFIG_FILE]
[--encoding=ENCODING] [-k=KEYSPACE] [--log-dir=DIRECTORY]
[--max-concurrent-queries=QUERIES] [-o=FORMAT]
[-query=QUERY] [-r=REGION] [-t=TABLE] [-F=FLAGS]...
[[[-cf=PATH] [-p=NAME]] | [--token=TOKEN [--env=ENV]]]
[DB]Count items for a table, a query
Options
DB-
The name or ID of the Astra database to operate on
-k,--keyspace-
Keyspace used for loading or unloading data
-t,--table-
Table used for loading or unloading data.
--encoding-
The file name format to use when writing. This setting is ignored when reading and for non-file URLs
--max-concurrent-queries-
The maximum number of concurrent queries that should be carried in parallel
--log-dir-
Log directory for dsbulk operations
-r,--region-
The region to use. Uses the db’s default region if not specified.
--dsbulk-config-
Configuration file for DSBulk loader options
-F,--dsbulk-flag-
Additional flags to pass to DSBulk loader, can be specified multiple times (e.g., -F '--key1=value1' -F '--key2')
-query,--schema.query-
Optional query to unload or count
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
# Count all rows in a table
$ astra db dsbulk count my_db -k my_keyspace -t users
# Count rows using a custom query with filtering
$ astra db dsbulk count my_db -k my_keyspace -query "SELECT * FROM orders_by_customer WHERE customer_id = 11111111-1111-1111-1111-111111111111"
# Count with increased parallelism for large tables
$ astra db dsbulk count my_db -k my_keyspace -t products --max-concurrent-queries 32
# Find the largest partitions using dsbulk stats flags
$ astra db dsbulk count my_db -k my_keyspace -t orders_by_customer -F '--stats.modes=partitions' -F '--stats.numPartitions=5'