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 database schemas and tables, and run queries. This service runs in your browser, requires no additional authentication, and simplifies working with SQL queries by providing hints.

To connect to a Managed Service for ClickHouse® cluster from WebSQL, create a connection:

1. In the management console, select the folder the cluster is in.
2. Go to Managed Service for ClickHouse.
3. Click the cluster name.
4. Enable WebSQL access in the cluster settings if it is not on yet.
5. Select the WebSQL tab.
6. Click Create connection and specify the following connection settings:
   • Connection name.
   • Database type: ClickHouse®.
   • Cluster: Defaults to your current ClickHouse® cluster.
   • Username: Account you will use to connect to the cluster database.
   • Password: User password.
   • Databases: List of databases you want to access. You can only connect to the databases within the current cluster. The user account you specified must have permissions to access these databases.
7. Click Create.

To open the SQL editor, click the connection you created on the WebSQL tab. See the ClickHouse® reference for supported queries.

For more details on using WebSQL, see its official guides.

ClickHouse® is a registered trademark of ClickHouse, Inc.