SQL Query
Use the Playground's SQL editor to easily explore data
Last updated
Use the Playground's SQL editor to easily explore data
Last updated
Open the SQL editor by navigating to an App Playground and clicking SQL Query in the sidebar.
The Spice.ai Query Editor will suggest table and column names along with keywords as you type. You can manually prompt for a suggestion by pressing ctrl+space.
Start typing a SQL command, such as SELECT * FROM
As you type, the Query Editor will suggest possible completions based on the query context. You can use the arrow keys or mouse to select a completion, and then press Enter or Tab to insert it into the editor.
Examples of using the SQL suggestions:
Select the spice.runtime.metrics table:
Type SELECT * FROM and press Tab. The editor will suggest spice.runtime.metrics as a possible table. Press Enter to insert it into the query.
Show the fields in the spice.runtime.metrics table:
Type SELECT * FROM spice.runtime.metrics WHERE ". The editor will list the fields in the table.
The datasets reference displays all available datasets from the current app and allows you to search through them. Clicking on the dataset will insert a sample query into the SQL editor, which will be automatically selected for execution.
spice.runtime.metrics along with their type.