The query view allows you to directly query data a table by writing SQL. It is intended to allow advanced users to generate more comprehensive statistics and information about a particular table.
Queries are limited to an output size of 256 MB, and can only reference the corresponding table. The results of a query cannot be saved or exported, though your query history is saved for future reference. If you would like to materialize larger results, you can add the dataset to a project and create a transform.
This query view is only available if you have data access to the dataset.
You will not be able to run an invalid query. You can hover on the Invalid query message to see the validator feedback and make changes.