• Glossary
  • Support
  • Downloads
  • DataStax Home
Get Live Help
Expand All
Collapse All

DataStax Astra DB Classic Documentation

    • Overview
      • Release notes
      • Astra DB FAQs
      • CQL for Astra
      • Astra DB glossary
      • Get support
    • Getting Started
      • Create your database
      • Grant a user access
      • Load and retrieve data
        • Use DSBulk to load data
        • Use Data Loader in Astra Portal
      • Connect a driver
      • Build sample apps
      • Use integrations
    • Planning
      • Plan options
      • Database regions
    • Securing
      • Security highlights
      • Security guidelines
      • Default user permissions
      • Change your password
      • Reset your password
      • Authentication and Authorization
      • Astra DB Plugin for HashiCorp Vault
    • Connecting
      • Connecting to a VPC
      • Connecting Change Data Capture (CDC)
      • Connecting CQL console
      • Connect the Spark Cassandra Connector to Astra
      • Drivers for Astra DB
        • Connecting C++ driver
        • Connecting C# driver
        • Connecting Java driver
        • Connecting Node.js driver
        • Connecting Python driver
        • Connecting Legacy drivers
        • Drivers retry policies
      • Get Secure Connect Bundle
    • Migrating
      • Components
      • FAQs
      • Preliminary steps
        • Feasibility checks
        • Deployment and infrastructure considerations
        • Create target environment for migration
        • Understand rollback options
      • Phase 1: Deploy ZDM Proxy and connect client applications
        • Set up the ZDM Proxy Automation with ZDM Utility
        • Deploy the ZDM Proxy and monitoring
        • Configure Transport Layer Security
        • Connect client applications to ZDM Proxy
        • Leverage metrics provided by ZDM Proxy
        • Manage your ZDM Proxy instances
      • Phase 2: Migrate and validate data
        • Cassandra Data Migrator
        • DSBulk Migrator
      • Phase 3: Enable asynchronous dual reads
      • Phase 4: Change read routing to Target
      • Phase 5: Connect client applications directly to Target
      • Troubleshooting
        • Troubleshooting tips
        • Troubleshooting scenarios
      • Glossary
      • Contribution guidelines
      • Release Notes
    • API QuickStarts
      • Document API QuickStart
      • REST API QuickStart
      • GraphQL CQL-first API QuickStart
    • Developing with APIs
      • Developing with Document API
      • Developing with REST API
      • Developing with GraphQL API
        • Developing with GraphQL API (CQL-first)
        • Developing with GraphQL API (Schema-first)
      • Developing with gRPC API
        • gRPC Rust Client
        • gRPC Go Client
        • gRPC Node.js Client
        • gRPC Java Client
      • Developing with CQL API
      • Tooling Resources
      • Node.js Document Collection Client
      • Node.js REST Client
    • API References
      • Astra DB JSON API v1
      • Astra DB REST API v2
      • Astra DB Document API v2
      • Astra DB DevOps API v2
    • Managing
      • Managing your organization
        • User permissions
        • Pricing and billing
        • Audit Logs
        • Delete an account
        • Bring Your Own Key
          • BYOK AWS DevOps API
        • Configuring SSO
          • Configure SSO for Microsoft Azure AD
          • Configure SSO for Okta
          • Configure SSO for OneLogin
      • Managing your database
        • Create your database
        • View your databases
        • Database statuses
        • Use DSBulk to load data
        • Use Data Loader in Astra Portal
        • Monitor your databases
        • Manage multiple keyspaces
        • Using multiple regions
        • Terminate your database
        • Resize your classic database
        • Park your classic database
        • Unpark your classic database
      • Managing with DevOps API
        • Managing database lifecycle
        • Managing roles
        • Managing users
        • Managing tokens
        • Managing multiple regions
        • Get private endpoints
        • AWS PrivateLink
        • Azure PrivateLink
        • GCP Private Service
    • Astra CLI
  • DataStax Astra DB Classic Documentation
  • Overview
  • Astra DB FAQs

Astra DB FAQs

Frequently asked questions about DataStax Astra DB.

What tools does Astra DB include?

  • Stargate APIs: The Stargate APIs are available as the Astra DB APIs. Create an application token and begin interacting with your database.

  • CQLSH: Each Astra DB database includes an integrated CQL shell for interactive Cassandra Query Language (CQL) commands. Use CQLSH to create tables, insert data, and modify data in your keyspace.

  • Astra DB Data Loader: From the console, use Data Loader to load the following into your Astra DB database:

    • CSV data

    • Example datasets

    • Extracted DynamoDB data that resides in an Amazon S3 bucket

  • DataStax Bulk Loader: Use DataStax Bulk Loader (dsbulk) to load and unload data into your Astra DB database. You can load data from a variety of sources and unload data from DSE database for transfer, use, or storage of data.

  • Metrics dashboards: Use the integrated metrics dashboards to view health metrics that include information regarding latency and throughput to the database. These metrics provide insights into the performance of the database and how workloads are distributed.

  • Integrations: Connect a third-party tool of your choice to Astra DB for data management, machine learning, analytics, and more.

How is Astra DB different from DSE?

While you can run DataStax Enterprise (DSE) both on premises and in the cloud, Astra DB allows you to create databases in minutes, with reduced complexity, fewer operational concerns, and an approachable entry point for developing your applications. Astra DB is a true database-as-a-service (DBaaS) offering that provides simplified cluster management with flexible pricing. DSE also includes Advanced Workloads (DSE Search, Analytics, and Graph), which are not available in Astra DB. Read this whitepaper for an in-depth understanding of the cloud-native architecture of Astra DB.

Which version of Apache Cassandra™ is compatible with Astra DB?

Apache Cassandra version 3.11 is compatible with Astra DB databases.

What is a Vector Search?

A Vector Search reviews data on a database to determine the distance between the vectors. The closer they are, the more similar the data. The more the distance, the less similar the data.

Which cloud vendors does Astra DB support?

Astra DB supports creating databases on Amazon Web Services (AWS), Google Cloud, and Microsoft Azure.

How do I connect to Astra DB databases?

Options Description

I don’t want to create or manage a schema. Just let me get started.

Use schemaless JSON Documents with the Document API.

I want to start using my database now with APIs.

Use the REST API or GraphQL API to begin interacting with your database and self manage the schema.

I have an application and want to use the DataStax drivers.

Initialize one of the DataStax drivers to manage database connections for your application.

I know CQL and want to connect quickly to use my database.

Use the integrated CQL shell or the standalone CQLSH tool to interact with your database using CQL.

What does DataStax consider “recent” when listing Recent Resources?

Recent Resources includes the five most recent databases and streaming tenants resources used by someone in your organization.

Which DataStax drivers work with Astra DB?

Each of the supported DSE and Apache Cassandra drivers is compatible. Choose the DataStax driver for your preferred language and configure it to connect to your Astra DB database. See Connecting to Astra DB databases using DataStax drivers.

How do I manage billing for Astra DB?

Astra DB handles billing through an integration with Stripe, and displays all related billing information on the Billing Summary page. Enter a credit card number and associated billing information to begin creating Astra DB databases. See Billing for more information.

What happens when my monthly credit runs out?

You are prompted to add a credit card when your credit limit is running low. You also receive this notification by email and in Astra Portal.

If your application uses all $25 in credit, the database temporarily pauses until you add a credit card to re-start the database. Alternatively, you can wait until the next month for the $25 credit to reload.

Unused credits do not rollover. A $25 credit is added to your organization on the 1st of every month.

View your credit balance in the Dashboard:

Credit dashboard

Where do I find the Database ID and Organization ID?

While logged in to Astra, view the URL:

astra.datastax.com/{organization_id}

Navigate to your database dashboard:

astra.datastax.com/org/{organization_id}/database/{database_id}

Alternatively, you can view your Database ID in the Databases listing on the Astra DB dashboard. Use the clipboard icon to copy the ID.

Database ID in Astra UI

If you need the Datacenter ID (or IDs, if you have a multi-region database), click the database name to see its details and to locate the ID of each datacenter next to its name in the list.

Datacenter ID in Astra UI

How do I navigate to a CQL shell?

Select your current database on the left panel. Navigate to the CQL console tab.

CQL shell

Here, you can run CQL commands. These are a few to test out

  • Use <keyspace_name>; navigates to your keyspace

  • Desc tables; describes the tables within your current keyspaces

  • Select * from <table_name> limit 10; selects all columns from table, 10 rows

I am trying to create a keyspace in the CQL shell, and I am running into an error. How do I fix this?

Keyspaces need to be created in Astra Portal. Navigate to the Dashboard overview and select Add Keyspace.

Add keyspace

How do I delete a keyspace?

We do not allow users to delete the last keyspace to avoid accidental deletion of data. This is the error you will see in the CQL shell:

token@cqlsh> drop keyspace test_db;
Unauthorized: Error from server: code=2100 [Unauthorized] message="Missing correct permission on test_db."

To avoid any storage costs associated with the keyspace, you can drop tables from the keyspace by running:

drop table <keyspace_name>

What is the practical limit for the amount of data stored in an Astra DB database?

There is no practical limit to the number of bytes an Astra DB database can store.

How can I fix a “Missing Correct Permission Error”?

A permission error occurs for two reasons.

The first reason is that Astra places certain limitations on the user with Astra DB database guardrails and limits.

The second reason is that you don’t have the appropriate permissions on your account. Learn more information about user permissions.

token@cqlsh> select * from test_db.data
Unauthorized: Error from server: code=2100 [Unauthorized] message="No SELECT permission on <table test_db.data>"

I created my table in Astra Portal. Now, when I run a select statement I get an error. What do I do?

This is the error: Invalid Request: Error from server: code=2200 [Invalid query] message="table {table_name} does not exist"

When you upload a table through Astra Portal, any table name, keyspace name, or column name with case-sensitive characters can be accessed by using double quotes.

For example, see the select statement below:

token@cqlsh:test> desc tables;
token@cqlsh:test> select * from "Case_Sensitive";

I need help with the Workshop Project. Where do I go for help?

Check the YouTube description for the Workshop you attended. Use the Discord group or the YouTube chat to ask questions.

Additional links:

  • DataStaxDevs Discord: https://bit.ly/cassandra-workshop

  • Backup Stream (alternative to YouTube): https://www.twitch.tv/datastaxdevs

  • StackOverflow for dev-related questions: Follow the cassandra tag

  • DBA StackExchange for admin/ops-related questions: Follow the cassandra tag

  • Event Alerts: Subscribe for news

Where can I find Astra DB project tutorials?

You can find sample projects in our Sample App Gallery located on the left hand side of your Astra dashboard or the Github Repository.

Sample App Gallery

Additionally, you can follow along to video tutorials on our DataStax Developers YouTube page: https://www.youtube.com/c/DataStaxDevs

How do I open a support ticket?

Open your Astra Portal, select the Help Center. A panel for Health Center appears on the right side of the screen.

On the bottom right hand corner, select Submit a Ticket. You are redirected to the DataStax Support portal.

Select Submit a Request at the top. You must complete the fields marked with an asterisk. When finished, select Create.

For more, see Get support for Astra DB.

Can I change the keyspace name?

No, you cannot alter the keyspace name. You can create an entire new keyspace with a different name.

What if my CSV file is too large for the Data Loader?

If the file is over 40 MB, you can upload data with our DSBulk Loader. For more, see how to get started with DSBulk Loader.

Can I use cfstats or nodetool?

No, Astra is a zero-operations database-as-a-service (DBaaS) offering. Some operational Cassandra tools are not relevant. We offer access to a limited set of database metrics. You can view them in the Health tab in Astra Portal.

Dashboard

For more, see the Astra DB database guardrails and limits.

Can I use strict security settings, such as an ad blocker, with Astra DB?

If you are using strict security settings in your web browser, you might not see everything in Astra Portal, such as messages and certainly functionalities that simplify your experience.

Where can I find help?

There are several places to get help:

  • Use this product documentation to get answers about the capabilities of your database and information about how to use your databases.

  • Practice using the Astra DB database with our sample apps and integrations.

  • Within the Astra Portal Home, there are guides to help you get started easier, faster, and more efficiently. These guides include step-by-step instructions in the Astra Portal, along with prerequisites and procedures.

  • To send us feedback or get additional help, use the chat feature in Astra Portal.

Classic database FAQs

Which cloud regions are currently available for classic databases?

Astra DB supports single-region and multi-region deployments. The available classic regions vary based on the selected cloud provider and more are added over time. Within a region, data is replicated across three availability zones to ensure high availability.

To discuss region needs, use the chat icon in Astra Portal to talk with DataStax for guidance.

Is VPC peering possible for classic databases?

VPC peering is available on only Classic C- and D-tier Astra DB databases. For more, see AWS VPC peering, GCP VPC peering, and Azure.

How is pricing calculated for classic databases?

Pricing for DataStax Astra classic databases is based on plan, units of measure, cloud provider, and region. See Pricing for more information.

What is the range of ports available for classic databases?

The port range is 29000-32767.

APIs such as REST and GraphQL, and the Astra DB Health dashboard: 443.

What can I update with my avatar on Astra?

Click your avatar to review your current account settings, update your username, and reset your password.

Release notes CQL for Astra

General Inquiries: +1 (650) 389-6000 info@datastax.com

© DataStax | Privacy policy | Terms of use

DataStax, Titan, and TitanDB are registered trademarks of DataStax, Inc. and its subsidiaries in the United States and/or other countries.

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Kubernetes is the registered trademark of the Linux Foundation.

landing_page landingpage