Table of Contents

Firehose

Our built-in SQL management tool

SQL Firehose is our built-in SQL management tool. It allows you to run SQL statements against the solution database with type-ahead suggestions, and browse database tables & data.

To use the tool, write the SQL statement in the input field and press either Run or Ctrl + Enter and see the results in the panel at the bottom of the screen. Gif1

The History-button in the bottom panel let's you view the past queries that has been run. Gif2

And the Download-button let's you download the full response as a CSV file (semicolon delimited). Gif3

If you write an invalid query, a notifications box will appear with the error message. For example this query: SELECT ProductId FROM EcomProducts WEHRE ProductId = '1000' fails because WHERE is misspelled as WEHRE: SQLFirehose2

Before executing UPDATE, DELETE, or INSERT statement, a warning appears showing the expected number of affected rows. For example: UPDATE EcomProducts SET ProductId = '1' WHERE ProductId = '1000' gives a warning that 1 row(s) will be affected - in this manner you can review risky operations before making any major changes. SQLFirehose3

Improve this doc
To top