About this Task
To make encrypted fields queryable, create an encryption schema. This schema defines which fields are queryable, and which query types are permitted. For more information, see Encrypted Fields and Enabled Queries.
Important
Queryable Encryption supports equality and range queries. You can configure a field for only one query type.
Before you Begin
When you make encrypted fields queryable, consider performance and security. For details on how each configuration option affects these, see Configure Encrypted Fields for Optimal Search and Storage.
Steps
Specify fields to encrypt.
Add the
pathandbsonTypestrings to a document within the fields array:const encryptedFieldsObject = {
fields: [
{path: "myDocumentField", bsonType: "int"
}
]
}Important
You can specify any field for encryption except the
_idfield.Optionally, set a
keyIdfield with the DEK ID.Important
Key IDs must be unique, otherwise the server returns an error.
By configuring
AutoEncryptionSettingson the client, you can use thecreateEncryptedCollectionhelper method to create keys automatically.{
path: "myDocumentField",
bsonType: "int",keyId: "<unique data encryption key>"
}queries: { queryType: "equality" }
}4Enable range queries on desired fields.
This enables querying with the
$lt,$lte,$gt, and$gteoperators.For details on how the following options affect security and performance, see Configure Encrypted Fields for Optimal Search and Storage.
Add the
queriesobject and setqueryTypeto"range":{
path: "myDocumentRangeField",
bsonType: "int",
queries: { queryType: "range" }
}Set the following fields:
Field Type Description Same as field
bsonTypeRequired if
bsonTypeisdecimalordouble. Optional but highly recommended if it isint,long, ordate. Defaults to the minimum and maximum values of thebsonType.When possible, specifying bounds on a query improves performance. If querying values outside of these inclusive bounds, MongoDB returns an error.
{
path: "myDocumentRangeField",
bsonType: "int",
queries: { queryType: "range",min: 0, max: 1200
}
}5Enable prefix, suffix, or substring queries on desired fields.
These query types are for
stringfields only. You can enable bothprefixPreviewandsuffixPreviewon the same field, but can't enable either if usingsubstringPreview.Warning
Prefix, Suffix, and Substring Queries are in Public Preview
Queryable Encryption prefix, suffix, and substring queries are available in public preview in MongoDB 8.2. Do not enable these query types in production. Public preview functionality will be incompatible with the GA feature, and you will have to drop any collections that enable these queries.
prefixPreviewqueries enable the$encStrStartsWithand$encStrNormalizedEqaggregation expressions.suffixPreviewqueries enable the$encStrEndsWithand$encStrNormalizedEqaggregation expressions.substringPreviewqueries enable the$encStrContainsand$encStrNormalizedEqaggregation expressions.
Add the
queriesobject and setqueryTypeto"prefixPreview","suffixPreview", or"substringPreview":{
path: "myDocumentStringField",
bsonType: "string",
queries: { queryType: "substringPreview" }
}Set the following fields.
For details on how they affect security and performance, see Configure Encrypted Fields for Optimal Search and Storage.
Field Type Description integer
substringPreviewqueries only. The maximum allowed length for a substring-indexed field.integer
The minimum allowed prefix/suffix/substring length to query.
integer
The maximum allowed prefix/suffix/substring length to query.
IMPORTANT: This setting strongly impacts query performance. Limit it whenever possible.
Boolean
Optional. Whether queries are case-sensitive. Defaults to
true.Boolean
Optional. Whether queries are diacritic-sensitive. Defaults to
true.{
path: "myDocumentStringField",
bsonType: "string",
queries: {
"queryType": "substringPreview","strMaxLength": 30, "strMinQueryLength": 1,
"strMaxQueryLength": 20,
"caseSensitive": false
}
}Example
This example shows how to create an encryption schema for hospital data.
Consider the following document that contains personally identifiable information (PII), credit card information, and sensitive medical information:
{
"firstName": "Jon",
"lastName": "Snow",
"patientId": 12345187,
"address": "123 Cherry Ave",
"medications": [
"Adderall",
"Lipitor"
],
"patientInfo": {
"ssn": "921-12-1234",
"billing": {
"type": "visa",
"number": "1234-1234-1234-1234"
}
}
}To ensure the PII and sensitive medical information stays secure, this encryption schema adds the relevant fields:
const encryptedFieldsObject = {
fields: [
{
path: "patientId",
bsonType: "int"
},
{
path: "patientInfo.ssn",
bsonType: "string"
},
{
path: "medications",
bsonType: "array"
},
{
path: "patientInfo.billing",
bsonType: "object"
}
]
}Adding the
queriesproperty makes thepatientIdandpatientInfo.ssnfields queryable. This example enables equality queries:const encryptedFieldsObject = {
fields: [
{
path: "patientId",
bsonType: "int",queries: { queryType: "equality" }
},
{
path: "patientInfo.ssn",
bsonType: "string",queries: { queryType: "equality" }
},
{
path: "medications",
bsonType: "array"
},
{
path: "patientInfo.billing",
bsonType: "object"
},
]
}