SQL Examples

SQL examples for local file analysis

These starter queries work well after importing CSV, JSON, or Parquet files into SQL for Files. Replace table and column names with your own schema.

Open the editorRead the docs

Preview and inspect imported tables

Filter rows and check missing values

Join two imported files

Create chart-ready aggregate result sets

Example queries

Find missing values

SELECT COUNT(*) AS missing_rows
FROM my_table
WHERE important_column IS NULL;

Create a chart-ready result

SELECT category, COUNT(*) AS rows, AVG(amount) AS average_amount
FROM my_table
GROUP BY category
ORDER BY rows DESC;