The Query Editor
Audience: Data Owners and Data Users
Content Summary: This page outlines the basic features of the Query Editor, which contains three main components: Table List and Schema View, the Query Editor, and the Query Results View. For a tutorial that details how to use the Query Editor, navigate to the Data Source User Guide.
The Query Editor allows users who are subscribed to a data source to preview data, write queries, and execute queries directly in the Immuta UI for any data sources they are subscribed to. Additionally, Data Owners can examine how their policies impact the underlying data.
Table List and Schema View
This panel contains a list of tables the user is subscribed to grouped by schema, and this list automatically updates when users switch their current project. Clicking a table in the list displays the schema view and shows all columns with their respective data types.
Users can enter, modify, and execute their own queries in this panel. After users click Run Query, results appear in the Query Results panel.
In the top right corner of the Query Editor is a dropdown to select a schema. Any tables in
SELECT statements that
are not schema-qualified use the schema chosen from the dropdown.
Query Results View
This panel displays the data returned by the query. Table columns can be resized or re-arranged by clicking and dragging, and results can be filtered. Currently displayed results can also be exported to .csv (limited to 1000 rows.)