DataStax Astra database limits

DataStax Astra sets limits for databases to ensure good practices, foster availability, and promote optimal configurations for your database.

DataStax Astra offers a Free tier, allowing you to create an Astra database with 10 GB for free. Create a database with just a few clicks and start developing within minutes.

You can create up to 5 databases per region, and add a total of 20 Capacity Units (CUs) per database (10TBs). To adjust these limits, contact DataStax Support.

Note: Astra provides one database on the Free tier per user.

The following limits are set for all databases not on the Free tier created using DataStax Astra. These limits ensure good practices, foster availability, and promote optimal configurations for your database.

Columns

Parameter Limit Notes
Single column size 5 MB Hard limit.
Number of columns per table 50 Hard limit.
Size of values in BLOB and collection types 1 MB Hard limit.

Tables

Parameter Limit Notes
Number of tables per keyspace 2001 A warning is issued when the database exceeds 100 tables.
Table properties Fixed All table properties are fixed except for Expiring data with time-to-live.
Secondary index 1 Limit is per table.
Materialized view 2 Limit is per table. A warning is issued if the materialized view will create large partitions.
1Each DataStax Astra database supports only one keyspace.

Cassandra Query Language (CQL)

Note: At this time, user-defined functions (UDFs) and user-defined aggregate functions (UDAs) are not enabled.
Parameter Limit Notes
Consistency level Fixed Supported consistency levels:
Compaction strategy Fixed Only the SizeTieredCompaction strategy is supported.
Lists Fixed When returning lists is disabled, read-before-write.
Page size Fixed The proper page size is configured automatically.
Large partition Warning A warning is issued if reading or compacting a partition that exceeds 50 MB.