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;