Skip to main content

Copy data from one ClickHouse® server to another

You can copy data from one ClickHouse® server to another using the remoteSecure() function.

Prerequisites​

Details of the source (remote) server

  • Hostname
  • Port
  • Username
  • Password

Copy data​

  1. From your target server, use the remoteSecure() function to select data from the source server.

    SELECT * FROM remoteSecure('HOSTNAME:PORT', db.remote_engine_table, 'USERNAME', 'PASSWORD') LIMIT 3;
    tip

    If you have the managed credentials integration enabled, you can use instead:

    SELECT * FROM remoteSecure('service_YOUR_REMOTE_CLUSTER', db.remote_engine_table) LIMIT 3;

    See how to enable the managed credentials integration.

  2. Insert the selected data into the target server.

    INSERT INTO [db.]table [(c1, c2, c3)] SELECT ...

    For details on how to configure and use the INSERT query, see Inserting the Results of SELECT.

Your data has been copied from the remote (source) server to the new (target) server.