As SingleStoreDB Cloud manages its own workspaces, customers are only responsible for managing data and performing data-related tasks, including:
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 workspace capacity
The default SingleStoreDB Cloud Admin user permissions include:
CREATE TEMPORARY TABLES,
ALTER PIPELINE, and
After creating your database and designing a physical schema, you are ready to load data from one or more data sources into the database.
Common ways to load data are:
Use Pipelines to load data from some data sources.
Pipelines are a SingleStore feature that extracts, shapes (modifies), and loads external data in real-time. If you are using Pipelines, see Load Data with Pipelines.
Load data from a file that is located on the filesystem.
For details, see LOAD DATA.
The SQL Reference contains all of the SQL commands that you can run against your database.
Use the SingleStoreDB Cloud SQL Editor to run commands directly against your workspace.
In this section
Last modified: September 12, 2023