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 sampledRemove fields
Remove tables
Rename tables, so long as the
collection
field remains the sameRename fields using the
sqlname
option
Important
To apply any changes you make to your DRDL files, you must restart
mongosqld
.
Note
BI Connector does not recognize geospatial fields when reading from a view.