SQL queries in Yandex WebSQL
You can use Yandex WebSQL to send SQL queries to Managed Service for ClickHouse® cluster databases.
WebSQL is a Yandex Cloud service that allows you to connect to managed database clusters, work with databases, tables, and schemas, and run queries. This service runs in the browser, requires no extra login, and simplifies work by providing hints for SQL commands.
To connect to a cluster from WebSQL, you must enable the WebSQL access option in the cluster settings. You can enable this option when creating or updating a cluster.
The Managed Service for ClickHouse® cluster automatically creates a Connection Manager connection for each database user, enabling database access from WebSQL. You can also create a new connection if needed.
To connect to the database from WebSQL:
-
In the management console, select the folder containing your cluster.
-
Navigate to the Managed Service for ClickHouse service.
-
Click the cluster name and navigate to the WebSQL tab.
-
Select the required connection.
The connection will open in WebSQL. To open the query editor, select the required database.
Check this ClickHouse® reference for supported queries.
For more details on working with WebSQL, see these guides.
ClickHouse® is a registered trademark of ClickHouse, Inc.