MongoDB is a popular open-source NoSQL database that utilizes a flexible, document-oriented data model, making it ideal for handling large volumes of unstructured data. Known for its scalability and performance, MongoDB supports modern application development with features like indexing, sharding, and real-time data processing.

This article provides an overview to get started with the MongoDB connector in Peliqan. Please contact support if you have any additional questions or remarks.

Contents

• Contents
• Required Schema collection in your DB
• Need further help

Required Schema collection in your DB

Peliqan uses Trino to connect to MongoDB and to execute SQL queries on MongoDB.

A _schema collection must be present in each database, which defines the schema.

Example record in _schema:

{
    "_id": {
        "$oid": "65b8fb86593a75d575ee835b"
    },
    "table": "my_collection",
    "fields": [
        {
            "name": "_id",
            "type": "ObjectId",
            "hidden": false
        },
        {
            "name": "name",
            "type": "varchar",
            "hidden": false
        },
        {
            "name": "age",
            "type": "bigint",
            "hidden": false
        }
    ]
}

Below is an example Python script that will add and/or update _schema in each DB. This script will perform introspection on the first 100 records of each collection to generate a _schema record:

Need further help

Please contact our support for any further assistance via support@peliqan.io.