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.

Query syntax

Redivis supports the BigQuery Standard SQL Syntax and features. This is the same syntax as you would use in writing code-based transforms within a project.

Running a query

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.