RethinkDB provides the facility to dump existing data either coming from traditional databases such as MySQL and MSSQL in a suitable format, that is, CSV
or JSON
, or freshly generated JSON documents.
In Chapter 3, Data Exploration Using RethinkDB, we used the import
utility to dump a JSON file consisting of 1,000 documents directly into a table. In this section, we are going to refresh the import
utility.
Here is the command:
rethinkdb import -f <file path> --table <Database name>.<table name>
You can also specify the port options and other configuration; for more information, please visit Chapter 3, Data Exploration Using RethinkDB.
Let's look at a few use cases where we can really make use of the import
utility.