Astra DB conveniently has its own data loader built in to the user interface.Use this DataStax Astra DB Data Loader to load your own data into your database or try one of our sample datasets.
From your Astra DB Dashboard, select Load Data for the database where you want to load data.
The Astra DB Data Loader launches.
Load your data using one of the options to upload your dataset:
Make sure the column names in your .csv file does not include spaces! Underscores are accepted. For example, ShoeSize , ShirtColor , Shoe_Size , and Shirt_Color are all accepted column names.
CSV files must be less than 40 MB. If you upload a .csv file, you will see a status bar to show how much of the data has uploaded.
Once you select or upload your dataset, select Next.
To configure your dataset, give your table for this dataset a name.
Your dataset will be included in the Data Preview and Types.
Select the data type for each column.
The Astra DB Data Loader automatically selects data types for your dataset. If needed, you can change this to your own selection.
Select your partition key and clustering column for your data.
Select Next.
Select your database from the dropdown menu.
Select your keyspace from the available keyspaces.
Select Next.
You will see a confirmation that your data is being imported. Within a few minutes, your dataset will begin uploading to your database.
You will receive an email when the job has started and when the dataset has been loaded.Then you can interact with your data by connecting to your database.