Skip to main content
Link
Menu
Expand
(external link)
Document
Search
Copy
Copied
Firebolt documentation
What is Firebolt?
Platform capabilities
Overview
Architecture
Organizations and accounts
Engine Fundamentals
Engine Consumption
Data management
Using indexes
Security
Working with tables
Working with partitions
Role-Based Access Control
Account Permissions
Engine Permissions
Ownership
Check Assigned Privileges
Role Management
Default System Roles
Custom Roles
Database permissions
Schema permissions
Table permissions
View permissions
Guides
Manage organization
Register to Firebolt
Manage accounts
Manage logins
Manage programmatic access
Manage users and roles
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
Use AWS roles to access S3
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
Configure SSO
Auth0
Okta
OneLogin
PingFederate
Salesforce
Custom Identity Provider
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
Paradime
Estuary
Optimize query performance
Understanding History-based Optimization
Subresult Reuse
Spilling
SQL reference
Data types
Information schema
Accounts
Applicable roles
Catalogs
Columns
Enabled roles
Engine history
Engine metering history
Engine metrics history
Engine query history
Engine running queries
Engine user query history
Engines
Engines Billing
Indexes
Logins
Network policies
Object privileges
Schemata
Service accounts
Storage Billing
Storage Metering History
Storage history
Tables
Transitive applicable roles
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 TABLE CLONE
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 CATALOGS
SHOW COLUMNS
SHOW ENGINES
SHOW INDEXES
SHOW TABLES
SHOW VIEWS
SQL 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
MEDIAN
MIN
MIN_BY
PERCENTILE_CONT
STDDEV_POP
STDDEV_SAMP
SUM
VAR_POP
VAR_SAMP
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
Geospatial functions
ST_ASBINARY
ST_ASEWKB
ST_ASGEOJSON
ST_ASTEXT
ST_CONTAINS
ST_COVERS
ST_DISTANCE
ST_GEOGFROMGEOJSON
ST_GEOGFROMTEXT
ST_GEOGFROMWKB
ST_GEOGPOINT
ST_INTERSECTS
ST_X
ST_Y
JSON functions
JSON_EXTRACT
JSON_EXTRACT_ARRAY
JSON_POINTER_EXTRACT_KEYS
JSON_POINTER_EXTRACT_TEXT
JSON_POINTER_EXTRACT_VALUES
JSON_VALUE
JSON_VALUE_ARRAY
Lambda functions
ARRAY_ALL_MATCH
ARRAY_ANY_MATCH
ARRAY_FILTER
ARRAY_FIRST
ARRAY_SUM
ARRAY_TRANSFORM
Numeric functions
ABS
ACOS
ARRAY_ENUMERATE
ASIN
ATAN
ATAN2
BIT_SHIFT_LEFT
BIT_SHIFT_RIGHT
CEIL
COS
COT
DEGREES
FLOOR
HLL_COUNT_ESTIMATE
IS_FINITE
IS_INFINITE
LN
LOG
MOD
PARAM
PI
POW
RADIANS
RANDOM
ROUND
SIN
SQRT
TAN
Session functions
CURRENT_ACCOUNT
CURRENT_DATABASE
CURRENT_ENGINE
SESSION_USER
String functions
BTRIM
CONCAT
GEN_RANDOM_UUID_TEXT
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
Vector functions
VECTOR_ADD
VECTOR_COSINE_DISTANCE
VECTOR_COSINE_SIMILARITY
VECTOR_EUCLIDEAN_DISTANCE
VECTOR_INNER_PRODUCT
VECTOR_MANHATTAN_DISTANCE
VECTOR_SQUARED_EUCLIDEAN_DISTANCE
VECTOR_SUBTRACT
Window functions
AVG OVER
COUNT OVER
DENSE_RANK OVER
FIRST_VALUE
LAG OVER
LEAD OVER
MAX OVER
MIN OVER
NTILE OVER
PERCENT_RANK OVER
RANK OVER
ROW_NUMBER OVER
SUM OVER
General reference
Release notes
Available regions
System settings
Object identifers
Reserved words
Help menu
TRY FOR FREE
SQL reference
SQL functions
Geospatial functions
Geospatial functions
ST_ASBINARY
ST_ASEWKB
ST_ASGEOJSON
ST_ASTEXT
ST_CONTAINS
ST_COVERS
ST_DISTANCE
ST_GEOGFROMGEOJSON
ST_GEOGFROMTEXT
ST_GEOGFROMWKB
ST_GEOGPOINT
ST_INTERSECTS
ST_X
ST_Y