Queries in Yandex WebSQL

You can send queries to databases in a Managed Service for Greenplum® cluster using Yandex WebSQL.

WebSQL is a Yandex Cloud service that allows you to connect to managed database clusters, work with DBs, tables, and schemas, and run queries. It is a web-based tool that requires no additional authorization and simplifies working with Valkey™ commands by suggesting prompts.

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

1. Navigate to the folder dashboard and select Managed Service for Greenplum.
2. Click the cluster name.
3. Enable WebSQL access in the cluster settings if it is not enabled yet.
4. Select the WebSQL tab.
5. Click Create connection and specify the connection parameters:
   • Database type: Greenplum®.
   • Cluster folder: Defaults to your current folder.
   • Cluster: Defaults to your current Greenplum® cluster.
   • Username you will use to connect to the database in the cluster.
   • User password.
   • Databases you want to connect to. You can only connect to the databases that exist in this cluster. The user you specified must have access to them.
6. Click Create.

To open the query editor, click the created connection on the WebSQL tab.

For more information about working with WebSQL, see its documentation.