Skip to main content

Moving Data Between Databases

There are ways to move your data between databases depending on whether SingleStoreDB Cloud or SingleStoreDB On-Premises 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, GCD, KAFKS, , and AZURE as well.

    SELECT * FROM table_name_1
    INTO S3 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;