BI Connector provides the following environment variables:
Default Value (Atlas-hosted)
Default Value (On Premises)
Specifies whether a query error is returned for queries with clauses that aren't fully translated to the MongoDB query language. SQL query predicates are used to filter data returned by the query.
Specifies the logging level for BI Connector:
2 (Atlas-hosted) and 0 (self-managed)
Specifies the maximum number of unique nested field paths that
mongosqld maps to a relational table for a collection.
The maximum number of unique fields that
mongosqld maps to
relational columns for a collection.
Specifies the maximum string length returned for columns using the
VARCHAR data type. A value of
Determines how BI Connector evaluates document fields that are
specified with multiple data types. For example,
Specifies how frequently, in seconds, that the BI Connector schema
is updated. A value of
See Cached Sampling for more information.
Specifies how the MongoDB schema is transformed into a relational schema:
Specifies the semantics that BI Connector uses for type conversions,
such as the
You must have the atlasAdmin database role to set environment
variables on an Atlas-hosted BI Connector. To set them for a self-managed
BI Connector, you must have the
inprog privilege on the
MongoDB database to which you've connected the BI Connector.
Use any SQL client that is connected to BI Connector to set these
variables. The following example sets
SET GLOBAL mongodb_max_varchar_length = 100
You must start a new connection to the BI Connector after setting a system variable. The connection you used to set the system variable is not affected.