Going to re:Invent this December? Come party with us and The Chainsmokers ->->
Back to integrations

Prequel

partner

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)

Other integrations

Get started with ClickHouse Cloud for free

We'll get you started on a 30 day trial and $300 credits to spend at your own pace.