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 and work with their databases, tables, schemas, and queries. This service runs in the browser, requires no extra login, and simplifies work by providing hints for SQL commands.
For more details on working with WebSQL, see these guides.
To run an SQL query:
-
In the management console, select the resource folder you created the metadata catalog in.
-
Go to 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.