Skip to main content
Private Preview FeatureThis feature is currently in private preview. Contact support@firebolt.io to request early access.
Creates a location object that stores the connection URI and credentials for a MongoDB deployment, for use with change data capture streams.

​
Syntax

CREATE LOCATION [IF NOT EXISTS] <location_name> WITH
    SOURCE = MONGODB
    URI = '<connection_uri>'
    [USER = '<user>']
    [PASSWORD = '<password>']
    [TLS_CA_FILE = '<ca_file>']
    [DESCRIPTION = '<description>'];

​
Parameters

ParameterDescription
<location_name>A unique identifier for the location within your account.
SOURCEMust be MONGODB.
URIMongoDB connection string (mongodb:// or mongodb+srv://). Required. The deployment must be a replica set or sharded cluster; standalone servers have no change streams.
USER, PASSWORDCredentials for the connection. Optional, but must be supplied together. Credentials embedded in the URI work as well.
TLS_CA_FILEOptional CA certificate for deployments with a private certificate authority.
DESCRIPTIONOptional metadata describing the location’s purpose.

​
TLS

TLS follows the URI: mongodb+srv:// connections use TLS, and plain mongodb:// URIs can request it with the tls=true URI option.

​
Example

CREATE LOCATION mongo_prod WITH
    SOURCE = MONGODB
    URI = 'mongodb+srv://cluster0.example.mongodb.net/'
    USER = 'firebolt_cdc'
    PASSWORD = '********'
    DESCRIPTION = 'Production Atlas cluster';