Exporting Data from Countly


Use cases to Export Data

In some cases, you may find that you need to export data from Countly. This can happen in one of two cases:

  1. Archiving older data and keeping short term data in Countly for faster server experience or reducing server costs, etc.
  2. Putting data that Countly collects in some data lake, which combines data from multiple other platforms so data scientists can connect all the data in one place

This article talks about how you can undertake such an export.

With DB Viewer

Before we dive into DB Viewer API, please note that there is also UI for DB Viewer in Countly dashboard, which allows easy data export of specific collections and queries in JSON, CSV, and Excel formats.

Get Information About All Apps

Get User Information About a Specific App

Get All Event Data

Without DB Viewer

Directly from MongoDB

You can also take a direct and complete data dump from MongoDB using MongoDB tools.

Using mongodump (https://docs.mongodb.com/database-tools/mongodump/) command to dump the whole database in unreadable BSON format and then restore it using mongorestore(https://docs.mongodb.com/database-tools/mongorestore/https://docs.mongodb.com/database-tools/mongorestore/) command.

Or alternatively, you can use mongoexport (https://docs.mongodb.com/database-tools/mongoexport/) which can also export specific collections from specific databases (or even results of queries) in JSONL format, which can be imported respectively using mongoimport (https://docs.mongodb.com/database-tools/mongoimport/) command.

Was this article helpful?
0 out of 0 found this helpful

Looking for help?