BI Connector provides the following environment variables:
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:
Specifies the maximum number of unique nested field paths that
The maximum number of tables allowed in a MongoDB deployment with an automatically- generated schema.
The maximum number of tables allowed in a collection in a table with an automatically-generated schema.
The default limit for table's nesting depth of arrays that MongoDB translates to tables, in a collection with an automatically-generated schema.
The maximum number of fields examined per collection in a table with an automatically-generated schema.
Specifies the maximum string length returned for columns using the
Determines how BI Connector evaluates document fields that are
specified with multiple data types. For example,
Allows you to choose the behavior where MongoDB does not automatically convert types for some queries using arithmetic aggregate functions. In MongoDB version 3.6 and earlier, this behavior results in improved performance, compared with implicit type conversions for arithmetic aggregation functions in subsequent versions.
See Type Conversion Modes for more information.
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.