SQL commands

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

• 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

• Cross-database queries
• EXPLAIN
• RECOMMEND DDL
• SELECT

​

Data management

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

​

Data definition

• ALTER ACCOUNT
• ALTER DATABASE
• ALTER TABLE
• CREATE ACCOUNT
• CREATE AGGREGATING INDEX
• CREATE VECTOR SEARCH 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
• EXPLICIT TRANSACTIONS

​

Engines

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

​

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