Querying data on your machine

This file has four columns, service_id, name, prefix and reference_url. Once you downloaded the file, you can simply drag-and-drop from the folder you downloaded it to to the area in the lower left corner of the SQL Workbench:

A table called aws_services.csv has now been automatically created, which you can query via SQLs, for example:

SELECT * FROM "aws_services.csv";

JSON files work the same way. They can either contain an array of objects (e.g. [{"id": 1}, ...]), or one object per line (newline-delimited JSON, often with the extensions .ndjson or .jsonl). The columns and their types are detected automatically, nested objects and arrays become STRUCT and LIST columns. For example, after dropping a file called events.ndjson:

SELECT type, count(*) AS cnt FROM "events.ndjson" GROUP BY ALL;