Ways to insert data in Mission Control
You can insert data into databases programmatically and in the UI.
Permissions required to insert data
To insert data into a database, you must be able to read and write to the target database, keyspace, and collection or table.
To insert data with the Data API, you need an application token with a valid role.
To insert data in the UI with cqlsh, you must have superuser permissions for the target database.
Content requirements for CSV and JSON files
If you insert data from a CSV or JSON file, the data must be compatible with Hyper-Converged Database (HCD) or DataStax Enterprise (DSE) and, if applicable, the table schema.
For example, if you insert a CSV file into a table, the CSV file must contain the same column names and data types as the table.
If you insert a JSON file exported from a database that isn’t based on Apache Cassandra®, you might need to transform the data into a format that is compatible with HCD or DSE before you insert the data.
Content requirements for collections
Collections contain pieces of data known as documents, which are similar to rows in a table. Each document consists of one or more properties or fields.
Regardless of how you choose to insert data, the following requirements apply to documents inserted into collections.
Rules for field names in documents
A document can contain user-defined and reserved fields.
For more information, see parameters in the HCD Insert many documentation or DSE Insert many documentation.
Maximum limits for fields and documents
Documents and fields are subject to limits. For more information, see the HCD documentation.
