Overview
IntegrationsPricing

Downloading as CSV file

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

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

Compiling & Running queries:

  -> Compiling & Running ./warehouse/selects/demo.sql...
     Writing CSV at ./selects/warehouse/demo.csv...
     Success!

The CSV follows the format desired when passing a data flag. This makes the CSV reusable as a data source when running operations!

id,first_name,last_name,username,email,created_at
1234567890,John,DOE,john-doe,johndoe@example.com,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!