Queries against datasets with Yandex WebSQL
Note
This feature is in the Preview stage.
You can use Yandex WebSQL to send SQL queries to databases in clusters that are data sources for Data Catalog.
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 SQL commands by suggesting prompts.
For more information about working with WebSQL, see its documentation.
To run an SQL query:
-
In the management console, select the resource folder you created the metadata catalog in.
-
Select Yandex MetaData Hub.
-
In the left-hand panel, select Data Catalog.
-
In the list that opens, select the metadata catalog.
-
In the left-hand panel, select Metadata search.
-
Navigate to a metadata object with the Dataset type by doing one of the following:
- Click the name of the object with the Dataset type.
- Click the name of an object with a type other than Dataset. Navigate across child objects using the Child tab until you find an object with the Dataset type. Click the object’s name.
-
In the Data field, click the Open in WebSQL link.
-
Select a connection to the source cluster database. This will take you to WebSQL.
-
In the top-right panel, enter the SQL query and click Run.
Here are some examples of what you can do with SQL commands:
Note
In case the data source is a Yandex Managed Service for PostgreSQL cluster, you cannot use SQL commands for actions requiring superuser permissions.