This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.

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
• 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 VIEW
• DESCRIBE
• DROP DATABASE
• DROP TABLE
• DROP VIEW
• INSERT INTO
• 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

Metadata

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

---