Stream into SingleStore with your free account

The SingleStore materialization connector in Estuary delivers data from Estuary collections directly into tables in a SingleStore database. It supports continuous materialization from real-time or batch pipelines, using standard merge-based updates by default with optional delta updates for applicable workloads.

• Materializes Estuary collections directly into SingleStore tables
• Standard merge-based updates by default to keep destination records synchronized
• Optional delta updates for workloads where changes should be applied incrementally
• Automatic table creation for configured materialization bindings
• Custom SQL after table creation for additional table-level configuration
• Configurable destination table names for individual bindings
• SSL/TLS connection support, including certificate and hostname verification
• Configurable timezone handling for datetime columns
• Username and password authentication
• Support for SingleStoreDB Cloud, including SSL-secured connections
• Option to exclude the root Flow document from standard updates for advanced use cases

Each materialization binding maps an Estuary collection to a SingleStore table. The connector creates the destination table when needed, and you can optionally run additional SQL after table creation for further configuration.

For SingleStoreDB Cloud, SSL is required. Estuary supports several SSL modes, including verify_ca and verify_identity, with support for supplying the SingleStore server CA certificate.