Docs Menu

Docs HomeMongoDB Connector for BI

Load a Schema from a DRDL File

On this page

  • Overview

The --schema option allows you to specify a schema file for mongosqld to use.

The schema generation tool mongodrdl outputs a schema file in Document Relational Definition Language (DRDL) format. Examine the generated schema's table structure and field types to verify that the generated schema supports your reporting requirements.

You can manually edit the schema definition files to perform the following actions:

  • Add fields that mongodrdl did not discover within the subset of documents that it sampled

  • Remove fields

  • Remove tables

  • Rename tables, so long as the collection field remains the same

  • Rename fields using the sqlname option


To apply any changes you make to your DRDL files, you must restart mongosqld.


BI Connector does not recognize geospatial fields when reading from a view.

←  Use MongoDB ViewsResample Schema Data with "FLUSH SAMPLE" →

On this page

Share Feedback
© 2023 MongoDB, Inc.


  • Careers
  • Investor Relations
  • Legal Notices
  • Privacy Notices
  • Security Information
  • Trust Center
© 2023 MongoDB, Inc.