SARION

Dataset SQL

Load up to five CSV files and query them with SQL, joins included, inside your browser.

Where to find it Capabilities > Tools > Dataset SQL (Workspace)

What it is

Dataset SQL turns each CSV file into a table, named after the file (sales.csv becomes the table sales), that you can query with SQL. The tables live side by side, so one query can join them. The files are read in your browser's memory and are not uploaded.

When to use it

Use it for quick analysis of a spreadsheet export: totals per region, top customers, a join between two lists.

Step by step

  1. Open ⌘ Capabilities and choose Dataset SQL.
  2. Press 📊 Local Dataset Analysis (CSV) and choose a file. Do it again for each further file.
  3. Each loaded dataset is listed with its table name, its row count and a Remove button.
  4. Type a query in the SQL query box and press Run query (or Ctrl+Enter). Up to 200 rows are shown.
  5. Press Remove to take a dataset out of memory and out of chat. Reloading the page clears them all.

Example queries

  • Total per region: SELECT region, SUM(amount) AS total FROM sales GROUP BY region ORDER BY total DESC;
  • Join two files: SELECT c.name, SUM(s.amount) AS total FROM sales s JOIN customers c ON s.customer_id = c.customer_id GROUP BY c.name;

Ask in plain language

While datasets are loaded, the chat and Vault Chat can answer questions about them by writing SQL that your browser runs for you, including joins across your files. Example: "How many rows are in my sales dataset?" To do this the chat is told each table's name, its column names and types and its row count, together with your question. The rows themselves, and your file names, are never sent. Once you remove a dataset, the chat no longer knows about it.

Tips

  • Table names come from file names, so rename files to something short before loading.
  • Adding or removing a dataset briefly reloads the others.

Limits

  • Up to 5 datasets at a time, 50 MB in total. Past that, SARION asks you to remove one first.
  • Up to 200 result rows are displayed.
  • If a file cannot be read, whatever was loaded before is left as it was.

Common questions

How do I query a CSV with SQL?

Open Dataset SQL, load the CSV, write your query and press Run query.

Can I join two CSV files?

Yes. Load both; each becomes a table and one query can join them.

Are my CSV files uploaded?

No, they are not uploaded. They are read in your browser's memory and stay in your browser. Only table and column names are shared with the assistant so it can write queries.

How many CSV files can I load at once?

Up to 5 datasets at a time, 50 MB in total. Past that, SARION asks you to remove one first.