Moving Data Between Databases

There are ways to move your data between databases depending on whether SingleStore Helios or SingleStore Self-Managed is where the data is being accessed.

• SELECT ... INTO , CREATE PIPELINE AS LOAD DATA, then START PIPELINE. The following example uses S3, but this will work for HDFS, GCS, KAFKS, and AZURE as well.

  SQL

  Copy

  SELECT * FROM table_name_1
  INTO S3 bucket/target
  CONFIG configuration_json
  CREDENTIALS credentials_json
  
  CREATE PIPELINE pipeline_name AS LOAD DATA S3 'bucket-name' | '<bucket-name/path>'
        [CONFIG '<configuration_json>']
        CREDENTIALS '<credentials_json>'
  INTO TABLE table_name_2;
  
  START PIPELINE pipeline_name;