Prequel

Sharing data from ClickHouse to your customers & partners

• Within Prequel, under the "Data Export" navigation pane, select the "Data Sources" menu, click "Add Source", and then select the ClickHouse option.

• Provide the connection details for your ClickHouse Service:

  • Host - The hostname of the ClickHouse service.
  • Port - Most likely 9440 for ClickHouse.
  • Username - A read-only ClickHouse user created for data transfers.
  • Password - The password for the ClickHouse user.
  • Database - The database to transfer data from.

• Configure your data model in Prequel by selecting one or more of your tables and the relevant columns to share.

• Congratulations! You can now begin connecting to external destinations to begin sharing data from ClickHouse.

Importing data to ClickHouse from your customers & partners

• Within Prequel, under the "Data Import" navigation pane, select the "Data Destinations" menu, click "Add Destination", and then select the ClickHouse option.

• Provide the connection details for your ClickHouse Service:

  • Host - The hostname of the ClickHouse service.
  • Port - 9440 for ClickHous Cloud
  • Username - A ClickHouse user that can read and write data created for data transfers.
  • Password - The password for the ClickHouse user.
  • Database - The database to load data into.

• Congratulations! You can now begin connecting to external sources to import data into ClickHouse.

NOTE: Make sure to allow Prequel's IP addresses to access your ClickHouse Service (Prequel IP Addresses)