Load a Schema from a DRDL File

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

When you're done editing your .drdl file, you can either:

• Use mongodrdl to upload the schema to your MongoDB deployment.

• Run mongosqld with the --schema option to specify the .drdl when launching mongosqld.