Configure SQL Server Bootstrap Provider

The SQL Server bootstrap provider loads initial state from a Microsoft SQL Server database so queries start with a complete snapshot before streaming begins.

When to use SQL Server bootstrap

• You need historical/current state from SQL Server when a query starts.
• Your query depends on existing rows (aggregations, joins, thresholds).
• You want snapshot + CDC streaming from the same database.

Prerequisites

• Use with a SQL Server source (sources[].kind: mssql).
• The configured user must have SELECT permission on the monitored tables.

Quick example (Drasi Server config)

In Drasi Server config, bootstrap provider keys are camelCase, and the discriminator field is bootstrapProvider.kind.

sources:
  - kind: mssql
    id: orders-db
    autoStart: true

    host: ${MSSQL_HOST:-localhost}
    port: ${MSSQL_PORT:-1433}
    database: ${MSSQL_DATABASE:-MyDatabase}
    user: ${MSSQL_USER:-drasi_user}
    password: ${MSSQL_PASSWORD}

    tables:
      - orders
      - customers

    bootstrapProvider:
      kind: mssql

When bootstrapProvider.kind is mssql with no additional fields, the bootstrap provider inherits the connection details from the parent source configuration.

You can also override the connection details if the bootstrap should connect to a different server or use different credentials:

    bootstrapProvider:
      kind: mssql
      host: ${BOOTSTRAP_HOST:-localhost}
      port: 1433
      database: ${BOOTSTRAP_DB:-MyDatabase}
      user: ${BOOTSTRAP_USER:-drasi_reader}
      password: ${BOOTSTRAP_PASSWORD}
      authMode: sqlserver
      encryption: notsupported
      trustServerCertificate: false
      tables:
        - orders
        - customers
      tableKeys:
        - table: order_items
          keyColumns: [order_id, product_id]

Configuration reference

Fields support Drasi Server config references like ${ENV_VAR} / ${ENV_VAR:-default}.

Notes

• Drasi Server only allows kind: mssql when the source is also kind: mssql.
• When no additional fields are provided, connection details are inherited from the parent source configuration.
• The bootstrap reads current table state via SELECT queries—it does not use CDC.

Documentation resources