SQL commands
Use the alphabetical list in the navigation pane to find the syntax for commands that you already know.
Use the functional list below to find commands for a specific task area that you’re working in.
-
Engines
Start, stop, and manage Firebolt engines. -
Data ingest and movement
Move data between your data lake and Firebolt, and betweeen Firebolt resources. -
Database objects
DDL. Create, alter, drop, and otherwise manage objects like databases, tables, and views in your Firebolt account. -
Data manipulation
DML. Update data or delete data from tables in your Firebolt account. -
Queries and query optimization
Analyze data withSELECT
. Tune and optimize query performance with other commands. -
Information schema
Query the Firebolt information schema for metadata related to Firebolt objects and resources.
Engines
- ALTER ENGINE
- ATTACH ENGINE
- CREATE ENGINE
- DETACH ENGINE (deprecated)
- DROP ENGINE
- SHOW CACHE
- SHOW ENGINES
- START ENGINE
- STOP ENGINE
Data ingest and movement
Database objects
- ALTER TABLE…DROP PARTITION
- CREATE AGGREGATING INDEX
- CREATE DATABASE
- CREATE EXTERNAL TABLE
- CREATE FACT or DIMENSION TABLE
- CREATE JOIN INDEX (legacy)
- CREATE VIEW
- DESCRIBE
- DROP DATABASE
- DROP TABLE
- DROP VIEW
- INSERT INTO
- REFRESH JOIN INDEX (legacy)
- SHOW COLUMNS
- SHOW DATABASES
- SHOW TABLES
- TRUNCATE TABLE