Skip to main content
Link
Menu
Expand
(external link)
Document
Search
Copy
Copied
Firebolt documentation
Overview
Architecture
Engine Fundamentals
Engine Consumption
Organizations and accounts
Data management
COPY FROM
Security
Using indexes
Working with tables
Working with partitions
Guides
Manage organization
Register to Firebolt
Manage accounts
Manage logins
Service accounts
Manage users
Billing
Get started
Get started using a wizard
Get started using SQL
Resources beyond getting started
Load data
Load data using a wizard
Load data using SQL
Creating Access Key and Secret ID in AWS
Work with external tables
Query data
Use the Develop Space
Use the API
Keyboard shortcuts for the Develop Space
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
Optimize query performance
Subresult Reuse
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
Engines Billing
Indexes
Logins
Network policies
Object privileges
Schemata
Service accounts
Storage Billing
Storage Metering History
Storage history
Tables
Users
Views
Operators
Functions glossary
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
EXPLAIN
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
BIT_AND
BIT_OR
BIT_XOR
BOOL_AND
BOOL_OR
COUNT
HASH_AGG
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
Binary functions
CONVERT_FROM
DECODE
ENCODE
Conditional and miscellaneous functions
CASE
CAST
CITY_HASH
COALESCE
GENERATE_SERIES
GREATEST
HASH
IFNULL
LEAST
LIST_OBJECTS
NULLIF
READ_CSV
READ_PARQUET
TRY_CAST
TYPEOF
VERSION
DataSketches functions
APACHE_DATASKETCHES_HLL_BUILD
APACHE_DATASKETCHES_HLL_ESTIMATE
APACHE_DATASKETCHES_HLL_MERGE
Date and time functions
CURRENT_DATE
CURRENT_TIMESTAMP
DATE_ADD
DATE_TRUNC
EXTRACT
LOCALTIMESTAMP
TO_CHAR
TO_DATE
TO_TIMESTAMP
TO_YYYYMM
TO_YYYYMMDD
JSON functions
JSON_EXTRACT
JSON_EXTRACT_ARRAY
JSON_VALUE
JSON_VALUE_ARRAY
Lambda functions
ARRAY_ANY_MATCH
ARRAY_FILTER
ARRAY_FIRST
ARRAY_SUM
ARRAY_TRANSFORM
Numeric functions
ABS
ARRAY_ENUMERATE
HLL_COUNT_ESTIMATE
LN
LOG
MOD
PARAM
POW
RANDOM
ROUND
SQRT
Session functions
CURRENT_ACCOUNT
CURRENT_DATABASE
CURRENT_ENGINE
SESSION_USER
String functions
BTRIM
CONCAT
ILIKE
LENGTH
LIKE
LOWER
LPAD
LTRIM
OCTET_LENGTH
POSITION
REGEXP_EXTRACT
REGEXP_EXTRACT_ALL
REGEXP_LIKE
REGEXP_LIKE_ANY
REGEXP_REPLACE
REPLACE
RPAD
RTRIM
SPLIT_PART
STRING_TO_ARRAY
STRPOS
SUBSTRING, SUBSTR
TRIM
UPPER
URL_DECODE
URL_ENCODE
General reference
Release notes
Available regions
System settings
Object identifers
Reserved words
Help menu
TRY FOR FREE
SQL reference
SQL functions
Lambda functions
Lambda functions
For more information about using Lambda functions, see
Manipulating arrays with Lambda functions
.
ARRAY_ANY_MATCH
ARRAY_FILTER
ARRAY_FIRST
ARRAY_SUM
ARRAY_TRANSFORM