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 with SELECT. 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

• ALTER TABLE…DROP PARTITION
• CREATE EXTERNAL TABLE
• INSERT INTO
• COPY TO

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

Data manipulation

• UPDATE
• DELETE

Queries and query optimization

• CREATE AGGREGATING INDEX
• DROP INDEX
• EXPLAIN
• SELECT
• SHOW INDEXES
• COPY TO
• VACUUM (Beta)

Metadata

• DESCRIBE
• SHOW CACHE
• SHOW COLUMNS
• SHOW DATABASES
• SHOW ENGINES
• SHOW INDEXES
• SHOW TABLES

---