Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://datastation.multiprocess.io/docs/tutorials/Query_ClickHouse_with_DataStation.html below:

Querying ClickHouse with DataStation | DataStation

First create a new data source in the left sidebar.

Give it a nice name so you easily can find it later. And select ClickHouse in the Vendor dropdown.

If you are connecting to localhost:8123 (the default), you can leave the host field blank. If your port is 8123 then you can always omit the colon and port and just specify the address.

Next fill in the database, username, and password fields if necessary. Leaving these fields blank is ok too.

If you want connect to a ClickHouse database on a remote server through an SSH proxy, you will need to set up the SSH connection to that server first. Once you do, you can select that connection in the "Via Server" dropdown within the data source editor.

Now create a new panel and select the Database type.

Enter your query and hit play!

You can always download the results of a panel by hitting the download button. Or you can reference the results in other panels.

Create a new panel. Change the type to Graph. Select the previous Database panel as the panel source. Then select the X and Y columns you'd like to graph.

Finally, click the play button to generate the graph. You can download the graph as a PNG by clicking the download button.

Note: Ctrl-r is a shortcut for hitting the play button when you are focused on one panel.

See an error or want to add a clarification? This page is generated from this file on Github.

Last edited Feb 07, 2022.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4