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.

    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;

Last modified: August 16, 2023

Was this article helpful?