Link
Search
Menu
Expand
Document
Firebolt documentation
Getting started
Release notes
Release notes archive
Architecture overview
Using the SQL workspace
Keyboard shortcuts
Using visual explain
Integrations
Business intelligence
Apache Superset / Preset
Cube.js
Looker
Metabase
Panintelligence
Tableau
Data integration and transformation
Adverity
Airbyte
Dataddo
dbt
Estuary Flow
Hevo
Hightouch
Keboola
Rivery
Data observability
Sifflet
Data orchestration
Airflow
Prefect
Using the CLI
Account and user management
Account concepts and terminology
Creating a Firebolt account
Service accounts (Beta)
Managing users
Billing
Working with engines
Understanding engine fundamentals
Choosing an engine
Working with engines using DDL
Working with engines using the Firebolt Manager
Working with engines using the REST API
System Engine (Beta)
Working with tables
Using indexes
Quick reference
Primary indexes
Aggregating indexes
Join indexes
Loading data
Working with external tables
Using AWS roles to access S3
Incrementally loading data
Working with partitions
Working with semi-structured data
Mapping data from JSON to table
Ingesting semi-structured data
Working with arrays
Working with Parquet arrays and maps
Exporting query results
Developing with Firebolt
Node.js
Python
REST API
SQLAlchemy
JDBC
.NET
Go
General reference
Data types
Operators
Identifier requirements
Information schema and usage views
Databases
Engines
Tables
Views
Columns
Indexes
Running queries
Query history
Reserved words
System settings
Available engine specs
Available AWS Regions
Firebolt help menu
SQL commands
ALTER DATABASE
ALTER ENGINE
ALTER TABLE...DROP PARTITION
ATTACH ENGINE
COPY TO
CREATE AGGREGATING INDEX
CREATE DATABASE
CREATE ENGINE
CREATE EXTERNAL TABLE
CREATE TABLE
CREATE TABLE AS SELECT (CTAS)
CREATE VIEW
DELETE
DESCRIBE
DROP DATABASE
DROP ENGINE
DROP INDEX
DROP TABLE
DROP VIEW
EXPLAIN
INSERT INTO
SELECT
SHOW CACHE
SHOW COLUMNS
SHOW DATABASES
SHOW ENGINES
SHOW INDEXES
SHOW TABLES
SHOW VIEWS
START ENGINE
STOP ENGINE
TRUNCATE TABLE
UPDATE
VACUUM (Beta)
SQL functions
ABS
ACOS
ALL_MATCH
ANY
ANY_MATCH
ANY_VALUE
APPROX_COUNT_DISTINCT
APPROX_PERCENTILE
ARRAY_AGG
ARRAY_CONCAT
ARRAY_COUNT
ARRAY_COUNT_GLOBAL
ARRAY_CUMULATIVE_SUM
ARRAY_DISTINCT
ARRAY_FILL
ARRAY_FIRST
ARRAY_FIRST_INDEX
ARRAY_INTERSECT
ARRAY_JOIN
ARRAY_MAX
ARRAY_MAX_GLOBAL
ARRAY_MIN
ARRAY_MIN_GLOBAL
ARRAY_REPLACE_BACKWARDS
ARRAY_REVERSE
ARRAY_SORT
ARRAY_SUM
ARRAY_SUM_GLOBAL
ARRAY_UNIQ
ARRAY_UNNEST (deprecated)
ASIN
ATAN
ATAN2
AVG (aggregation function)
AVG (window function)
BASE64_ENCODE
BTRIM
CASE
CAST
CBRT
CEIL, CEILING
CHECKSUM
CITY_HASH
COALESCE
CONCAT
CONTAINS
COS
COT
COUNT (aggregation function)
COUNT (window function)
CUME_DIST
CURRENT_DATE
CURRENT_TIMESTAMP
DATE_TRUNC
DECODE
DEGREES
DENSE_RANK
ELEMENT_AT
ENCODE
EXP
EXTRACT
EXTRACT_ALL
FILTER
FIRST_VALUE
FLATTEN
FLOOR
GEN_RANDOM_UUID
HLL_COUNT_DISTINCT
IFNULL
ILIKE
INDEX_OF
JSON_EXTRACT
JSON_EXTRACT_ARRAY_RAW
JSON_EXTRACT_KEYS
JSON_EXTRACT_RAW
JSON_EXTRACT_VALUES
LAG
LEAD
LENGTH (array function)
LENGTH (string function)
LIKE
LOCALTIMESTAMP
LOG
LOWER
LPAD
LTRIM
MATCH
MATCH_ANY
MAX (aggregation function)
MAX (window function)
MAX_BY
MD5
MD5_NUMBER_LOWER64
MD5_NUMBER_UPPER64
MEDIAN
MIN (aggregation function)
MIN (window function)
MIN_BY
MOD
NEST
NTH_VALUE
NTILE
NULLIF
PERCENTILE_CONT (aggregation function)
PERCENTILE_CONT (window function)
PERCENTILE_DISC (aggregation function)
PERCENTILE_DISC (window function)
PERCENT_RANK
PI
POW, POWER
RADIANS
RANDOM
RANK
REDUCE
REGEXP_EXTRACT
REGEXP_EXTRACT_ALL
REGEXP_LIKE
REGEXP_MATCHES
REGEXP_REPLACE
REPEAT
REPLACE
REVERSE
ROUND
ROW_NUMBER
RPAD
RTRIM
SIGN
SIN
SLICE
SPLIT
SPLIT_PART
SQRT
STDDEV_SAMP
STRPOS
SUBSTR
SUM (aggregation function)
SUM (window function)
TAN
TO_CHAR
TO_DATE
TO_DOUBLE
TO_FLOAT
TO_INT
TO_TIMESTAMP
TO_TIMESTAMPTZ
TRANSFORM
TRIM
TRUNC
TRY_CAST
UPPER
VERSION
ZEROIFNULL
GET STARTED
SQL functions
NEST
NEST
Synonym for
ARRAY_AGG
.