SingleStore Managed Service

Load Data

As SingleStore Managed Service manages its own clusters, customers are only responsible for managing data and performing data-related tasks, including:

  • Database configuration

  • Schema design and implementation

  • Index and query tuning

  • Extract, transform, load (ETL)

  • User creation and permission assignment

  • Making requests for restoring backups

  • Making requests for increasing or decreasing cluster capacity

The default SingleStore Managed Service Admin user permissions include: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, PROCESS, INDEX, ALTER, SHOW METADATA, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, ALTER VIEW, DROP VIEW, CREATE DATABASE, DROP DATABASE, CREATE PIPELINE, DROP PIPELINE, START PIPELINE, ALTER PIPELINE, and SHOW PIPELINE.

After creating your database and designing a physical schema, you are ready to load data from one or more data sources into the database.

You can use Pipelines to load data from some data sources. Pipelines is a SingleStore feature that extracts, shapes (modifies), and loads external data in real-time. If you are using Pipelines, see Pipeline Concepts for foundational knowledge.

This SQL Reference Overview contains all of the SQL commands that you can run against your database.

Use the Managed Service SQL Editor to run commands directly against your cluster.