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)