Link
Search
Menu
Expand
Document
Firebolt documentation
Overview
Architecture
Organizations and accounts
Engine Fundamentals
Data management lifecycle
Security
Working with tables
Working with partitions
Using indexes
Guides
Getting started
Manage organization
Register to Firebolt
Manage accounts
Manage logins
Service accounts
Manage users
Billing
Load data
Work with external tables
Creating Access Key and Secret ID in AWS
Query data
Query data using the SQL editor
Use the API
Keyboard shortcuts for the SQL editor
Work with engines
Work with engines using DDL
Sizing Engines
Governing Engines
System Engine
Work with semi-structured data
Map data from JSON to table
Ingest semi-structured data
Work with arrays
Work with Parquet arrays and maps
Work with indexes
Primary indexes
Aggregating indexes
Configure security
Set up SSO authentication
Role-based access control (RBAC)
Network policies
Multi-factor authentication
Export data
Develop with Firebolt
Node.js
Python
JDBC
SQLAlchemy
.NET SDK
Node SDK
Go
Integrate with Firebolt
Airflow
dbt
Apache Superset
Preset
SQL reference
Data types
Information schema
Accounts
Applicable roles
Columns
Databases
Engine metrics history
Engine query history
Engine running queries
Engines
Indexes
Logins
Network policies
Object privileges
Service accounts
Tables
Users
Views
Operators
SQL commands
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
Data definition
ALTER ACCOUNT
ALTER DATABASE
ALTER ORGANIZATION
ALTER TABLE
CREATE ACCOUNT
CREATE AGGREGATING INDEX
CREATE DATABASE
CREATE EXTERNAL TABLE
CREATE TABLE
CREATE TABLE AS SELECT (CTAS)
CREATE VIEW
DROP ACCOUNT
DROP DATABASE
DROP INDEX
DROP TABLE
DROP VIEW
USE DATABASE
Data management
COPY FROM
COPY TO
DELETE
INSERT
TRUNCATE TABLE
UPDATE
VACUUM
Engine commands
ALTER ENGINE
CREATE ENGINE
DROP ENGINE
START ENGINE
STOP ENGINE
USE ENGINE
Queries
CANCEL QUERY
SELECT
Metadata commands
DESCRIBE
SHOW CACHE
SHOW COLUMNS
SHOW DATABASES
SHOW ENGINES
SHOW INDEXES
SHOW TABLES
SHOW VIEWS
SQL functions
Aggregate array functions
Aggregation functions
ANY_VALUE
APPROX_COUNT_DISTINCT
AVG
CHECKSUM
COUNT
MAX
MAX_BY
MIN
SUM
Array functions
ARRAY_CONCAT
ARRAY_COUNT_DISTINCT
ARRAY_DISTINCT
ARRAY_JOIN
ARRAY_LENGTH
ARRAY_MAX
ARRAY_MIN
ARRAY_REVERSE
ARRAY_TO_STRING
CONTAINS
FLATTEN
INDEX_OF
Conditional and miscellaneous functions
CASE
CAST
COALESCE
GENERATE_SERIES
IFNULL
NULLIF
TRY_CAST
TYPEOF
VERSION
Date and time functions
CURRENT_DATE
CURRENT_TIMESTAMP
DATE_ADD
DATE_TRUNC
EXTRACT
TO_CHAR
TO_CHAR
TO_DATE
TO_TIMESTAMP
Semi-structured data functions
JSON_EXTRACT
JSON_EXTRACT_ARRAY_RAW
JSON_EXTRACT_KEYS
JSON_EXTRACT_RAW
JSON_EXTRACT_VALUES
Lambda functions
ANY_MATCH
ARRAY_COUNT
ARRAY_SORT
ARRAY_SUM
TRANSFORM
Numeric functions
ABS
MOD
POW
RANDOM
ROUND
String functions
BTRIM
CONCAT
ILIKE
LENGTH
LIKE
LOWER
LPAD
LTRIM
MATCH
OCTET_LENGTH
REGEXP_LIKE
REGEXP_MATCHES
REGEXP_REPLACE
REPLACE
RPAD
RTRIM
SPLIT_PART
SUBSTRING, SUBSTR
TRIM
UPPER
Window functions
AVG OVER
COUNT OVER
MAX OVER
MIN OVER
SUM OVER
Functions glossary
General reference
Release notes
Available regions
System settings
Object identifers
Reserved words
Help menu
Using indexes
TRY FOR FREE
Guides
Work with indexes
Work with indexes
Learn to create and manage primary and aggregating indexes in Firebolt.
Primary indexes
Aggregating indexes