SingleStore

Add SingleStore as a decube connection and help your team discover, document and monitor their data assets to drive data-driven insights and decisions.

Supported Capabilities

Supported Capabilities

General

• Metadata — metadata extraction and display of asset information (tables, columns, schemas). Types collected: Schema, Table, Column

• Profiling — data profiling on the Profiler tab

• Preview — sample data preview

• Data Quality — data quality monitoring and observability

Data Quality Monitors

• Freshness

• Volume

• Field Health

• Custom SQL

• Schema Drift

Lineage

• Foreign Key Lineage — tracks relationships between tables via primary and foreign keys

Not Supported

Connection Requirements

Connecting to decube is as easy as providing us with credentials to your SingleStore database. At a minimum, we require

• Username

• Password

• Host Address

• Host Port

• Database

SingleStore

The source name will be for you to differentiate and recognize particular sources within the decube application.

We strongly encourage you to create a decube read-only user for this credential purpose, which you can follow here.

Security Concerns

You may need to configure your SingleStore database to whitelist our IP. You can do so under the Workspace > Firewall

Custom User for decube

A custom user would allow for a granular configuration of the user on your database and your connection to decube.

1. Create the user, and change host and password accordingly.

CREATE USER 'decube' IDENTIFIED BY '<password>';

1. Grant access to the decube user.

GRANT SELECT ON <database>.* TO 'decube'@'%';