CREATE LOCATION (MongoDB)

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

Parameter	Description
`<location_name>`	A unique identifier for the location within your account.
`SOURCE`	Must be `MONGODB`.
`URI`	MongoDB connection string (`mongodb://` or `mongodb+srv://`). Required. The deployment must be a replica set or sharded cluster; standalone servers have no change streams.
`USER`, `PASSWORD`	Credentials for the connection. Optional, but must be supplied together. Credentials embedded in the URI work as well.
`TLS_CA_FILE`	Optional CA certificate for deployments with a private certificate authority.
`DESCRIPTION`	Optional 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';

MongoDB CDC: source prerequisites and end-to-end setup.
CREATE STREAM: bind a stream to a collection in this location.
CREATE LOCATION: location objects in general.
DROP LOCATION

CREATE LOCATION (Iceberg)

CREATE LOCATION (Postgres)

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

TLS

Example

​Syntax

​Parameters

​TLS

​Example

​Related

Syntax

Parameters

TLS

Example

Related