Queries in Yandex WebSQL

You can use Yandex WebSQL to run Yandex MPP Analytics for PostgreSQL cluster database operations.

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

To connect to a Yandex MPP Analytics for PostgreSQL cluster from WebSQL, create a connection:

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

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

For more details on working with WebSQL, see these guides.

Greenplum® and Greenplum Database® are registered trademarks or trademarks of Broadcom Inc. in the United States and/or other countries.