Moving Data Between Databases

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;