Downloading as JSON file

When running a select, you can download the rows returned as a JSON file with the json flag. It creates or overwrites the file <query>.json. This file is located at the same path than the SQL one.

$ blacksmith run select \
  --integration warehouse \
  --file ./warehouse/selects/demo.sql \

Compiling & Running queries:

  -> Compiling & Running ./warehouse/selects/demo.sql...
     Writing JSON at ./selects/warehouse/demo.json...

The rows are not exported as a top-level array but inside a rows key alongside the count of rows returned. This makes the JSON reusable as a data source when running operations!

  "count": 12,
  "rows": [
      "id": "1234567890",
      "first_name": "John",
      "last_name": "DOE",
      "username": "john-doe",
      "email": "",
      "created_at": "2021-06-02T16:59:30Z",


Is something missing?

If you notice something we've missed or could be improved on, please follow this link and submit a pull request to the repository. Once we merge it, the changes will be reflected on the website the next time it is deployed.

Thank you for your contributions!