MEGA Hub
New
Docs/Datasets

Dataset SQL Console#

Dataset SQL Console lets you run a read-only SQL query against the selected configuration and split in a dataset's Data Studio tab. It is intended for quick exploration and validation without changing the published dataset.

Run a query#

  1. Open a dataset repository and select Data Studio.
  2. Select the configuration and split to query.
  3. Open SQL Console, write a query against the data view, and run it.

For example:

SQL
SELECT category, COUNT(*) AS examplesFROM dataGROUP BY categoryORDER BY examples DESCLIMIT 20

Queries run locally in the browser and must be one read-only SELECT statement or common-table expression over the selected data view. The console does not permit writes, external file readers, or changes to the repository. Keep result sets focused with LIMIT, and use the Viewer to inspect individual rows and column statistics.

After a query finishes, you can share a URL that restores the SQL, copy an iframe embed, download the result as CSV or Parquet, or copy an equivalent mega datasets sql command. These exports contain the returned result rows; they do not alter the dataset revision.

Save a personal query#

Signed-in users can save a query from SQL Console and reopen it later for the same dataset. Saved queries are personal: other readers of a public or shared dataset do not see them. A saved query retains its configuration and split, so check the selected revision and data schema before treating an old result as a new release check.

Use Data Studio to ask for a query suggestion, or Uploading Datasets when a validated change should become a new repository revision.