DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.
Check out the Academy FAQ pages for answers to your questions:
DS210 CQL COPY Course: https://academy.datastax.com/units/21022-cql-copy-dse-operations-apache-cassandra
OK for using
COPYin production DB for small amount of data
Can you define "small amount" ?
Or more exactly, what is the practicable size limit of a CSV (in rows, columns, CSV file size?) before the use of COPY FROM is discouraged? A ball park number would be enough.
@Tri The COPY command can be used efficiently for copying few thousand records with out running into major problems.
For large datasets running into millions, it is advised to use DataStax Bulk Loader.
DataStax Bulk Loader efficiently and reliably loads small or large amounts of data. CSV or JSON files can be rapidly loaded or unloaded to or from the following supported databases:
For an in-depth details on these tools, please listen to a video from DataStax team at
https://www.youtube.com/watch?v=CAH7Mlg_rVI
Also please refer to our Blog post on Bulk Loader
https://www.datastax.com/blog/2018/05/introducing-datastax-bulk-loader
6 People are following this question.
