Inserting data using COPY and a CSV file
Inserting data with the cqlsh command COPY from a CSV file is common for testing queries.
In a production database, inserting columns and column values programmatically is
more practical than using cqlsh, but often, testing queries using this SQL-like
shell is very convenient. A comma-delimited file, or CSV file, is useful if several
records need inserting. While not strictly an INSERT
command, it is
a common method for inserting data.