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.

• Queries
  Analyze data with SELECT. Tune and optimize query performance with other commands.

• Data management
  Move data between your data lake and Firebolt and between Firebolt resources.

• Data definition
  Data definition language. Create, alter, drop, and otherwise manage objects like databases, tables, and views in your Firebolt account.

• Engines
  Start, stop, and manage Firebolt engines.

• Metadata
  Query the Firebolt information schema for metadata related to its objects and resources.

• Access control
  Access control language. Create, alter and drop, and otherwise manage users, logins, service accounts and roles.

Queries

• EXPLAIN
• RECOMMEND DDL
• SELECT

Data management

• COPY FROM
• COPY TO
• DELETE
• INSERT
• TRUNCATE TABLE
• UPDATE
• VACUUM

Data definition

• ALTER ACCOUNT
• ALTER DATABASE
• ALTER TABLE
• CREATE ACCOUNT
• CREATE AGGREGATING INDEX
• CREATE DATABASE
• CREATE EXTERNAL TABLE
• CREATE FACT or DIMENSION TABLE
• CREATE VIEW
• DROP ACCOUNT
• DROP DATABASE
• DROP INDEX
• DROP TABLE
• DROP VIEW
• USE DATABASE

Engines

• ALTER ENGINE
• CREATE ENGINE
• DROP ENGINE
• START ENGINE
• STOP ENGINE
• USE ENGINE

Metadata

• DESCRIBE
• SHOW CACHE
• SHOW CATALOGS
• SHOW COLUMNS
• SHOW ENGINES
• SHOW INDEXES
• SHOW TABLES
• SHOW VIEWS

Access control

• ALTER LOGIN
• ALTER NETWORK POLICY
• ALTER SERVICE ACCOUNT
• ALTER USER
• CREATE LOGIN
• CREATE NETWORK POLICY
• CREATE ROLE
• CREATE SERVICE ACCOUNT
• CREATE USER
• DROP LOGIN
• DROP NETWORK POLICY
• DROP ROLE
• DROP SERVICE ACCOUNT
• DROP USER
• GRANT
• REVOKE