Load Data

As SingleStore Helios manages its own workspaces, 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 workspace capacity

The default SingleStore Helios 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.

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.

• Load Data from MySQL using mysqldump

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

Use the SingleStore Helios SQL Editor to run commands directly against your workspace.