SingleStoreDB connection

To access your data in SingleStoreDB, create a connection asset for it.

SingleStoreDB is a fast, distributed, and highly scalable cloud-based SQL database. You can use SingleStoreDB to power real-time and data-intensive applications.

Supported versions

SingleStoreDB version 8.1 and 8.5.

Create a connection to SingleStoreDB

To create the connection asset, you need these connection details:

  • Database (optional): If you do not enter a database name, you must enter the catalog name, schema name, and the table name in the properties for SQL queries.
  • Hostname or IP address
  • Port number
  • Username and password
  • SSL certificate (if required by the database server)

For Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.

Federal Information Processing Standards (FIPS) compliance

The SingleStoreDB connection cannot be created in a FIPS environment.

SingleStoreDB setup

To set up SingleStoreDB, see Getting Started with SingleStoreDB Cloud.

Running SQL statements

To ensure that your SQL statements run correctly, refer to the SingleStoreDB Docs SQL Reference for the correct syntax.

Learn more