Skip to main content

Import From External Cluster

Seamlessly import your ClickHouse data to an existing Gigapipe cluster

Import you ClickHouse data into your Gigapipe cluster

Provide the API with a cluster slug, connection information for the external cluster and a list of which tables to import, along with whether they need to be created for you, and watch your data migrate easily.

curl -X 'PATCH' \
'https://api.gigapipe.com/v1/clusters/<your_cluster_slug>/import-from-external-cluster' \
-H 'accept: application/json' \
-H 'Authorization: Bearer <your_access_token>' \
-H 'Content-Type: application/json' \
-d '{
"req": {
"host": "hostname",
"port": "port_number",
"database": "database_name",
"username": "username",
"password": "password"
},
"table_arrays": [
{
"table_name": "my_table_name",
"create_table": true
}
]
}'
# Payload response ::Dictionary
{
"message": "Successfully imported external data: <>"
}

Import from external cluster payload

Attributes


req  ::Dictionary

A dictionary containing the connection parameters for the external cluster


table_arrays  ::List[Dictionary]

A list of dictionaries containing the table name and whether it should be created


Change ClickHouse version response

Attributes


message  ::String

A basic response message