Link
Search
Menu
Expand
Document
Firebolt documentation
Overview
Architecture
Engine Fundamentals
Engine Consumption
Organizations and accounts
Data management
Security
Using indexes
Working with tables
Working with partitions
Guides
Getting started
Manage organization
Register to Firebolt
Manage accounts
Manage logins
Service accounts
Manage users
Billing
Load data
Creating Access Key and Secret ID in AWS
Work with external tables
Query data
Using the Develop Workspace
Use the API
Keyboard shortcuts for the develop workspace
Operate Engines
Work with engines using DDL
Sizing Engines
System Engine
Governing Engines
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
Ownership
Export data
Develop with Firebolt
Node.js
Python
JDBC
SQLAlchemy
.NET SDK
Go
Integrate with Firebolt
Airflow
dbt
Apache Superset
Preset
Cube.js
Airbyte
OpenTelemetry Exporter
SQL reference
Data types
Information schema
Accounts
Applicable roles
Catalogs
Columns
Engine history
Engine metering history
Engine metrics history
Engine query history
Engine running queries
Engines
Indexes
Logins
Network policies
Object privileges
Schemata
Service accounts
Storage history
Tables
Users
Views
Operators
SQL commands
Access control
ALTER LOGIN
ALTER NETWORK POLICY
ALTER ROLE
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 SCHEMA
ALTER TABLE
ALTER VIEW
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
RECOMMEND DDL
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
ARRAY_AGG
AVG
BOOL_AND
BOOL_OR
CHECKSUM
COUNT
HLL_COUNT_BUILD
HLL_COUNT_DISTINCT
HLL_COUNT_MERGE
MAX
MAX_BY
MIN
MIN_BY
SUM
Array functions
ARRAY_CONCAT
ARRAY_CONTAINS
ARRAY_COUNT
ARRAY_COUNT_DISTINCT
ARRAY_DISTINCT
ARRAY_FLATTEN
ARRAY_LENGTH
ARRAY_MAX
ARRAY_MIN
ARRAY_REVERSE
ARRAY_REVERSE_SORT
ARRAY_SORT
ARRAY_SUM
ARRAY_TO_STRING
INDEX_OF
Conditional and miscellaneous functions
CASE
CAST
COALESCE
GENERATE_SERIES
GREATEST
IFNULL
LEAST
NULLIF
TRY_CAST
TYPEOF
VERSION
Date and time functions
CURRENT_DATE
CURRENT_TIMESTAMP
DATE_ADD
DATE_TRUNC
EXTRACT
TO_CHAR
TO_DATE
TO_TIMESTAMP
JSON functions
JSON_EXTRACT
JSON_EXTRACT_VALUES
Lambda functions
ARRAY_ANY_MATCH
ARRAY_FIRST
ARRAY_SUM
TRANSFORM
Numeric functions
ABS
HLL_COUNT_ESTIMATE
MOD
POW
RANDOM
ROUND
String functions
BTRIM
ILIKE
LENGTH
LIKE
LOWER
LPAD
LTRIM
OCTET_LENGTH
POSITION
REGEXP_EXTRACT
REGEXP_EXTRACT_ALL
REGEXP_LIKE
REGEXP_REPLACE
REPLACE
RPAD
RTRIM
SPLIT_PART
STRING_TO_ARRAY
STRPOS
SUBSTRING, SUBSTR
TRIM
UPPER
Window functions
AVG OVER
COUNT OVER
DENSE_RANK OVER
LAG OVER
LEAD OVER
MAX OVER
MIN OVER
NTILE OVER
PERCENT_RANK OVER
RANK OVER
ROW_NUMBER OVER
SUM OVER
Functions glossary
General reference
Release notes
Available regions
System settings
Object identifers
Reserved words
Help menu
Using indexes
TRY FOR FREE
SQL reference
SQL commands
Metadata commands
Metadata commands
DESCRIBE
SHOW CACHE
SHOW COLUMNS
SHOW DATABASES
SHOW ENGINES
SHOW INDEXES
SHOW TABLES
SHOW VIEWS