Skip to content

Latest commit

 

History

History
40 lines (29 loc) · 630 Bytes

README.md

File metadata and controls

40 lines (29 loc) · 630 Bytes

RockSQL

An SQL shell for executing Rockset queries.

Installation

pip3 install RockSQL

Usage

  1. Authentication:
$ export `ROCKSET_TOKEN`=[API key] `ROCKSET_SERVER`=[API server]```

Note: You can also authorize using rsql [API key] [API server] in the next step.

  1. Enter the shell:
$ rsql
  1. Execute a query
$ SELECT * FROM my_collection
  1. Exit
$ exit

Shell commands

  • help
  • cls/clear
  • exit (^D)

Save results

To save query results to a file, append > to the end of your query.

$ SELECT * FROM my_collection > collection.json