Note: The Rockset VSCode extension is currently in a beta release. Please report any bugs to Rockset Customer Support
Features
- SQL syntax highlighting and documentation
- Query execution and validation
- Add documents
- Error Highlighting
- Autocomplete
- Formatting
Installation
The Rockset VSCode plugin is available to install on the VSCode Extension Marketplace.
Setup
After installation, first set the following two properties in your VSCode preferences (CMD + ,).
-
rockset.apiserver
: The Rockset API server to use with this extension -
rockset.apikey
: The Rockset API key to use with this extension
The recommended way to get started with SQL files is to use Rockset CLI.
# Authenticate
$ rockset auth:add default <apikey>
# Populate your Query Lambda SQL from Rockset
$ rockset local:init
$ rockset local:download
$ rockset local:queryLambda:add commons.myLambda
# Open the current directory in VSCode (if you have the VSCode CLI tools)
$ code .
# Alternatively, simply open the current directory using the VSCode UI
Configuring RocksetSQL language
Then, open myLambda.sql
in VSCode. You should confirm that the language of your SQL file is set to RocksetSQL to activate this extension. You may also want to set RocksetSQL as the default language for '.sql' file extensions. See the VSCode documentation for more information about configuring languages for your files.
Executing and Validating Queries
You can execute and validate simple queries directly in VSCode. Open the Command Palette in VSCode (CTRL + SHIFT + P or CMD + SHIFT + P) and execute the command Execute Rockset Query
or Validate Rockset Query
. At this point, it is not possible to run parameterized queries directly from VSCode.
Adding Documents
You can add documents with the Write API directly from VSCode. With a JSON or YAML file open, execute the command Add Rockset Document(s)
. This command takes either a list of documents or a single document.
SQL Documentation
You can hover over any SQL function and get its parameters and description, along with a link to Rockset's documentation.
Formatting SQL
The Rockset VSCode Extension comes with a formatter. The simplest way to use the formatter is by running Format Document
in the VSCode Command Palette (CTRL-Shift-P
or CMD-Shift-P
), in any RocksetSQL document. We recommend adding the following to your VSCode preferences:
- Turn on
editor.formatOnSave
. This will automatically format your document whenever you save it.
Collection Hovers
You can hover over a collection to get its metadata.
The recommended way to execute queries is with the Rockset Developer UI, which comes with the Rockset CLI. Please follow the documentation to install and set up these tools.
# After following the setup instructions above
rockset local:serve
This will open up a UI which will allow you to set parameters and test your local Query Lambdas.
You can also execute simple queries directly in VSCode. Open the Command Palette in VSCode (CTRL-SHIFT-P
or CMD-SHIFT-P
) and execute the command Execute Rockset Query
. This will execute the Query Lambda text raw and will not pass any parameters. At this point, it is not possible to run parameterized queries directly from VSCode (this is available in the Rockset Developer UI).
Command shortcuts
- Execute query: ctrl + alt + e
- Validate query: ctrl + alt + v
- Add document: ctrl + alt + a
See the VSCode documentation to configure your own keybinds.
Extension Settings
This extension contributes the following settings:
-
rockset.apiserver
: The Rockset API server to use with this extension -
rockset.apikey
: The Rockset API key to use with this extension
Release Notes
0.3.0
- syntax highlighting for Rockset's SQL dialect
- basic query execution in VsCode
- autoformatting for .sql files