Connect ClickHouse to Google Sheets and automatically export data from the ClickHouse data warehouse without any lines of code. This way you can not only perform a more microscopic analysis and generate insights from your data but also save a significant chunk of your time by eliminating manual tasks. And by automating the task, the chance of error is significantly reduced.
Another benefit of connecting ClickHouse to Google Sheets is the ability to easily share the data and collaborate with team members and clients.
We can easily and quickly connect ClickHouse to Google Sheets using Amigo. With Amigo we can integrate ClickHouse and Google Sheets from the web (also possible with the Amigo addon) without any coding. And after creating a ClickHouse and Google Sheets, we can easily and automatically pull data from ClickHouse to Google Sheets.
Following are the steps to connect ClickHouse to Google Sheets and export data from ClickHouse to Google Sheets.
- Connect ClickHouse to Google Sheets
- Export ClickHouse data to Google Sheets from tables
- Export ClickHouse data to Google Sheets using SQL query
- Automate data exports from ClickHouse to Google Sheets
How to connect ClickHouse to Google Sheets
Below are the steps to connect ClickHouse to Google Sheets and export ClickHouse data to Google Sheets.
Connect ClickHouse to Google Sheets
Log in to Amigo. Sign in with your Google account.
Add a ClickHouse-Google Sheets connection by clicking “Create new connections”.
Select ClickHouse from the sources list to create a ClickHouse and Google Sheets integration.
Enter the ClickHouse credentials and click “Connect” to connect ClickHouse to Google Sheets.
On clicking “Connect”, a ClickHouse and Google Sheets integration will be created. If the connection is successful, it will show up on the connections dashboard.
Export ClickHouse data to Google Sheets
There are two ways you can export data from ClickHosue to Google Sheets. One is a no-code method that allows users to move data easily and quickly from ClickHouse to Google Sheets directly from tables. The other is more versatile but also more technical. It uses SQL to retrieve data from single or multiple tables from ClickHouse to Google Sheets. Both methods are covered in the subsequent sections.
We’ll start with the non-code method to export data from ClickHouse to Google Sheets.
No-code data export from ClickHouse to Google Sheets
Click the connection you’ve created.
Choose whether to export from table or using SQL query. Click “Import from Tables”.
Select the table from which to export ClickHouse data to Google Sheets.
Be default all metrics are selected. Unselect the metrics to omit; or simply uncheck the “Select all” option and select the metrics you want to export.
Then set the row limit. The row limit is set to 50 by default. Name the report. And then click “Import to Google Sheets” to pull the ClickHouse data to Google Sheets.
If you’re using Amigo for the first time you need to connect Amigo to Google Drive to export the data to Google Sheets (you can also connect to multiple accounts). Add a connection to export the ClickHouse data to Google Sheets.
Export ClickHouse data to Google Sheets using SQL query
On clicking the ClickHouse Google Sheets connection you’ve created, you’ll be presented with an option to export from tables or with a custom SQL query. If you don’t see the SQL query option, click this link and select the connection.
Clicking the SQL query option takes you to a page where you can enter the SQL query to extract ClickHouse data and export to Google Sheets.
Enter the SQL query and click “Run” to preview the data. Then click “Import to Google Sheets” to export the ClickHouse data to Google Sheets. You can export the data to the Google account that you have connected previously or add a new account.
Automate data exports from ClickHouse to Google Sheets
Amigo can automatically update the exported data regularly–hourly, daily, weekly, or on certain days of the week. This option is not yet available on the web version however. So you’ll have to use the Amigo addon in Google Sheets. You can get it from the Google Workspace Marketplace. Click here to install the Amigo add-on.
Get alerts of the ClickHouse data exported to Google Sheets
If you want to get the exported data sent to your email or Slack, you can set up an alert and add the email addresses of all the people you want to share the data with and the Slack channels to which you want the alert to be sent. Then Amigo will update you and your team with the latest data. This feature is also, for now, only available with the add-on.
Click this link to learn more about how to set a refresh schedule and create an alert.
Amigo can connect Google Sheets to multiple sources and allows you to export data automatically. It is a convenient and versatile tool to import and export data to Google Sheets. Visit our blog to discover more.
Some related articles you may find useful:
Importing MySQL Data to Google Sheets