# Firebolt Documentation

> Firebolt is a high-performance cloud data warehouse optimized for sub-second analytics at scale. This documentation covers SQL references, architecture, integrations, security, and operational guides for developers and data engineers.

## Docs

- [What is Firebolt?](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/overview.md): Firebolt is a high-performan…
- [Quickstart](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/overview/quickstart.md): Start querying with Firebolt…
- [Architecture](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/overview/architecture-overview.md): How Firebolt runs as a singl…
- [Core concepts](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/overview/data-management.md): A technical tour of Firebolt…
- [Overview](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability.md): Guides to optimizing perform…
- [Query Planning](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning.md): Guides to understanding and…
- [Inspecting query plans](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/inspecting-query-plans.md): Learn on how to inspect the…
- [Cardinality estimation](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/cardinality-estimation.md): Understand and control how s…
- [Automated Column Statistics (ACS)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/automated-column-statistics.md): Learn how to use automated c…
- [Create tables with column statistics](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/automated-column-statistics/table-with-statistics.md): How to create a table that a…
- [Infer from user created indexes](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/automated-column-statistics/user-created-indexes.md): How to configure automated c…
- [History-Based Statistics](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/history-based-statistics.md): How to use statistics about…
- [UNIQUE constraints as query hints](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/unique-constraint.md): Understand how the UNIQUE co…
- [Query hints](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/query-hints.md): Influence the planner behavi…
- [No partial aggregation](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/query-hints/no-partial-aggregation.md): You can disable partial aggr…
- [No join ordering](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/query-hints/no-join-ordering.md): You can disable join order o…
- [Optimize for single row window partitions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/query-hints/optimize-for-single-row-window-partitions.md): Avoid expensive window opera…
- [Unique columns](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/query-hints/unique-columns.md): You can mark a column as uni…
- [User-guided mode](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/user-guided-mode.md): Learn how to take full contr…
- [Late materialization](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/late-materialization.md): Speed up your top-k queries…
- [Join pruning](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/query-planning/join-pruning.md): Use one side of a join to pr…
- [Subresult reuse and result caching](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/runtime/understand-query-performance-subresult.md): How to understand subresult…
- [Spilling](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/runtime/understand-spilling.md): How to understand spilling a…
- [Iceberg performance](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/runtime/iceberg-performance.md): How Firebolt accelerates Apa…
- [Storage and indexing](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/storage-and-indexing.md): How Firebolt stores managed…
- [Primary index](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/storage-and-indexing/primary-index.md): Primary index overview
- [Data skipping index](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/storage-and-indexing/data-skipping-index.md): Skip granules that cannot ma…
- [Inverted index](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/storage-and-indexing/inverted-index.md): Speed up point lookups with…
- [Full-text search index](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/storage-and-indexing/full-text-search-index.md): Speed up substring and patte…
- [Aggregating index](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/storage-and-indexing/aggregating-index.md): Aggregating index overview
- [Vector search index](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/storage-and-indexing/vector-search-index.md): Vector search index overview
- [Table and Column Compression](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/performance-and-observability/storage-and-indexing/table-and-column-compression.md): Learn about custom compressi…
- [Security](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security.md): Introduction to Firebolt sec…
- [Role-Based Access Control](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac.md): Learn about role-based acces…
- [Database permissions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/database-permissions.md): Understand the permissions t…
- [Schema permissions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/database-permissions/schema-permissions.md): Learn about the permissions…
- [Table permissions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/database-permissions/table-permissions.md): Learn about the permissions…
- [View permissions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/database-permissions/view-permissions.md): Learn about the permissions…
- [Location Permissions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/location-permissions.md): Learn about location-related…
- [Role Permissions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/role-permissions.md): Learn about role-level permi…
- [Account Permissions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/account-permissions.md): Learn about account-level pe…
- [User Permissions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/user-permissions.md): Learn about user-level permi…
- [Engine Permissions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/engine-permissions.md): Learn about engine-level per…
- [Ownership](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/ownership.md): Learn about ownership in Fir…
- [Check Assigned Privileges](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/check-privileges.md): Learn how to view and verify…
- [Role Management](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/role-management.md): Learn about role management…
- [Default System Roles](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/role-management/system-roles.md): Learn about the default syst…
- [Custom Roles](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/rbac/role-management/custom-roles.md): Learn how to create and mana…
- [Role-based access control (RBAC)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/guides/rbac.md): Learn about managing RBAC au…
- [Column-level security](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/guides/column-level-security.md): Learn how to use column-leve…
- [Using secure views](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/guides/rbac-views-security.md): Learn how to use views with…
- [LOCATION objects](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/guides/location.md): Learn about LOCATION objects…
- [Ownership](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/security/guides/ownership.md): Learn about object Ownership…
- [Self-Managed](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed.md): Documentation for running Fi…
- [Installation](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/installation.md): Install the Firebolt Operato…
- [Quickstart](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/quickstart.md): Create a Firebolt instance a…
- [kubectl firebolt plugin](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/kubectl-plugin.md): Manage Firebolt Instances an…
- [Architecture](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/architecture.md): How FireboltInstance, Firebo…
- [Instance overview](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/instance/overview.md): Shared infrastructure and st…
- [Gateway overview](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/instance/gateway/overview.md): Per-instance Envoy gateway f…
- [Gateway query routing](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/instance/gateway/gateway-query-routing.md): Select an Engine, understand…
- [Gateway sizing](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/instance/gateway/gateway-sizing.md): Size Gateway replicas and me…
- [Metadata overview](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/instance/metadata/overview.md): Stores and services engine m…
- [Engine overview](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/engine/overview.md): Create, operate, and inspect…
- [Engine rollouts](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/engine/engine-rollouts.md): Configure Engine rollout str…
- [Auto-stop and wake-up](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/engine/auto-stop-and-wake-up.md): Stop idle Engines and wake t…
- [Engine scaling](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/engine/engine-scaling.md): Scale, stop, resume, and upd…
- [Amazon S3](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/engine/object-storage/amazon-s3.md): Configure Amazon S3 as the b…
- [S3-compatible storage](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/engine/object-storage/s3-compatible.md): Configure a non-AWS S3-compa…
- [Google Cloud Storage](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/engine/object-storage/google-cloud-storage.md): Configure Google Cloud Stora…
- [Azure Blob Storage](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/engine/object-storage/azure-blob-storage.md): Configure Azure Blob Storage…
- [FireboltEngineClass overview](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/engineclass/overview.md): Optional namespaced classes…
- [EngineClass configuration inheritance](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/engineclass/configuration-inheritance.md): Share Engine settings while…
- [Monitoring](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/monitoring.md): Prometheus metrics exposed b…
- [Security model](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/security.md): Firebolt Operator and platfo…
- [Troubleshooting](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/troubleshooting.md): Common Firebolt Operator fai…
- [FireboltInstance CRD reference](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/crd-reference/instance-crd-reference.md): Spec, status, and conditions…
- [FireboltEngine CRD reference](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/crd-reference/engine-crd-reference.md): Spec, phases, and conditions…
- [FireboltEngineClass CRD reference](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/firebolt-operator/crd-reference/fireboltengineclass-crd-reference.md): Spec, status, inherited Engi…
- [Firebolt instance Helm chart](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/overview.md): Architecture, components, an…
- [Prerequisites](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/prerequisites.md): Kubernetes cluster, local to…
- [Quickstart](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/quickstart.md): Install the firebolt-instanc…
- [Single engine](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/usage/single-engine.md): Default install of the fireb…
- [Multi-engine](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/usage/multi-engine.md): Two or more named Firebolt e…
- [Amazon S3](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/usage/object-storage/amazon-s3.md): Amazon S3 and S3-compatible…
- [S3-compatible storage](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/usage/object-storage/s3-compatible.md): Back Firebolt engines with a…
- [Google Cloud Storage](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/usage/object-storage/google-cloud-storage.md): Google Cloud Storage object…
- [Azure Blob Storage](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/usage/object-storage/azure-blob-storage.md): Azure Blob Storage object st…
- [External PostgreSQL](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/usage/external-postgres.md): Connecting the Metadata Serv…
- [Authentication](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/usage/authentication.md): Enabling engine authenticati…
- [TLS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/usage/tls.md): Enabling TLS on the gateway'…
- [Image overrides](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/usage/image-overrides.md): Engine and metadata image ta…
- [Operator upgrade path](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/operator-upgrade-path.md): Capabilities that warrant gr…
- [Monitoring](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/monitoring.md): Engine and gateway Prometheu…
- [Security model](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/security.md): Pod-hardening defaults the c…
- [Troubleshooting](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/helm-chart/troubleshooting.md): Common failure modes when in…
- [Run Firebolt from the standalone binaries](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/standalone-binaries/overview.md): Run the Firebolt Engine and…
- [Deploy with embedded metadata](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/standalone-binaries/embedded-metadata.md): Run a single-node or multi-n…
- [Deploy with standalone metadata](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/standalone-binaries/standalone-metadata.md): Run one or more Firebolt Eng…
- [Colocate multiple nodes on one host](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/standalone-binaries/colocation.md): Run several Firebolt nodes o…
- [Connecting over HTTP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/connecting-over-http.md): Submit SQL to a self-managed…
- [Engine arguments](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/engine-arguments.md): Command-line arguments that…
- [Engine configuration reference](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/engine-configuration.md): Reference for the YAML confi…
- [Web UI](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/self-managed/web-ui.md): Run the optional web UI for…
- [Organizations and accounts](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organizations-accounts.md): Learn about Firebolt organiz…
- [Engine Fundamentals](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/engine-fundamentals.md): Learn fundamental concepts a…
- [Engine Consumption](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/engine-consumption.md): Understand Firebolt's consum…
- [Pricing and billing](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/billing.md): How Firebolt bills for usage
- [Available regions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/available-regions.md): Provides the AWS regions ava…
- [Support](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/support.md): Describes the options of the…
- [Configure SSO](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/security/sso.md): Learn about how to set up SS…
- [Auth0](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/security/sso/auth0.md): Learn how to configure Auth0…
- [Okta](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/security/sso/okta.md): Learn how to configure Okta…
- [OneLogin](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/security/sso/onelogin.md): Learn how to configure OneLo…
- [PingFederate](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/security/sso/pingfederate.md): Learn how to configure PingF…
- [Salesforce](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/security/sso/salesforce.md): Learn how to configure Sales…
- [Custom Identity Provider](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/security/sso/custom-sso.md): Learn how to configure a cus…
- [Multi-factor authentication](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/security/enabling-mfa.md): Learn about how to enable an…
- [Network policies](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/security/network-policies.md): Learn about creating and man…
- [AWS PrivateLink](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/security/privatelink.md): Learn how to set up and use…
- [Governing Engines](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/operate-engines/rbac-for-engines.md): Learn how to use Role Based…
- [Work with engines](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/operate-engines/working-with-engines-using-ddl.md): Learn how to create, modify…
- [Sizing Engines](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/operate-engines/sizing-engines.md): Learn how to size engines in…
- [Understanding Autoscaling](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/operate-engines/understand-autoscaling.md): Learn how autoscaling works…
- [Warming Up Engines](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/operate-engines/warming-up-engines.md): Learn how to warm up engines…
- [Release settings](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/operate-engines/engines-release-settings.md): Learn how to control the rel…
- [System Engine](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/operate-engines/system-engine.md): System engine documentation
- [Engine Warmpools](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/operate-engines/engine-warmpools.md): Learn about engine warmpools…
- [Manage logins](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/managing-logins.md): Learn about user permissions…
- [Manage programmatic access](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/service-accounts.md): Create and manage programmat…
- [CREATE LOGIN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/create-login.md): Reference and syntax for the…
- [ALTER LOGIN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/alter-login.md): Reference and syntax for the…
- [DROP LOGIN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/drop-login.md): Reference and syntax for the…
- [CREATE SERVICE ACCOUNT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/create-service-account.md): Reference and syntax for the…
- [ALTER SERVICE ACCOUNT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/alter-service-account.md): Reference and syntax for the…
- [DROP SERVICE ACCOUNT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/drop-service-account.md): Reference and syntax for the…
- [CREATE ORGANIZATION ROLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/create-organization-role.md): Reference and syntax for the…
- [ALTER ORGANIZATION ROLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/alter-organization-role.md): Reference and syntax for the…
- [DROP ORGANIZATION ROLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/drop-organization-role.md): Reference and syntax for the…
- [GRANT ORGANIZATION ROLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/grant-organization-role.md): Reference and syntax for the…
- [REVOKE ORGANIZATION ROLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/revoke-organization-role.md): Reference and syntax for the…
- [ALTER ORGANIZATION](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/commands/alter-organization.md): Reference and syntax for the…
- [Accounts](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/information-schema/accounts.md): Use this reference to learn…
- [Logins](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/information-schema/logins.md): Use this reference to learn…
- [Organization](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/information-schema/organization.md): Use this reference to learn…
- [Service accounts](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/information-schema/service-accounts.md): Use this reference to learn…
- [Network policies](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/managed-service/organization/information-schema/network_policies.md): Use this reference to learn…
- [Manage organization](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/managing-your-organization.md): Learn about user permissions…
- [Register to Firebolt](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/managing-your-organization/creating-an-organization.md): Learn how to create an organ…
- [Manage accounts](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/managing-your-organization/managing-accounts.md): Learn about how to add and r…
- [Manage users and roles](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/managing-your-organization/managing-users.md): Learn about user permissions…
- [Billing](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/managing-your-organization/billing.md): Understand how Firebolt bill…
- [Arrays](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/sql-dialect/arrays.md): Learn techniques to manipula…
- [Collations](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/sql-dialect/collations.md): Learn how to work with colla…
- [SQL Pipe syntax](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/sql-dialect/sql-pipe-syntax.md): Reference and syntax for SQL…
- [Parametrized queries](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/sql-dialect/parametrized-queries.md): Learn how to write parametri…
- [Load data](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/loading-data.md): Understand options for loadi…
- [Load data using a wizard](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/loading-data/loading-data-wizard.md): Understand options for loadi…
- [Load data using SQL](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/loading-data/loading-data-sql.md): Understand options for loadi…
- [Creating Access Key and Secret ID in AWS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/loading-data/creating-access-keys-aws.md): Understand how to create sec…
- [Use AWS roles to access S3](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/loading-data/configuring-aws-role-to-access-amazon-s3.md): Learn how to use AWS IAM rol…
- [Work with external tables](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/loading-data/working-with-external-tables.md): Understand the role of exter…
- [Incremental loading from Amazon S3](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/loading-data/incremental-ingestion-from-s3.md): Load every file from an Amaz…
- [Work with semi-structured data](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/loading-data/working-with-semi-structured-data.md): Learn how to handle semi-str…
- [Load semi-structured JSON data](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/loading-data/working-with-semi-structured-data/load-json-data.md): Learn how to map semi-struct…
- [Load semi-structured Parquet data](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/loading-data/working-with-semi-structured-data/load-parquet-data.md): Learn how to load Parquet da…
- [Change data capture](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/change-data-capture.md): Stream changes from Postgres…
- [Postgres CDC](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/change-data-capture/postgres.md): Ingest changes from Postgres…
- [MongoDB CDC](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/change-data-capture/mongodb.md): Ingest changes from MongoDB…
- [CDC tables](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/change-data-capture/cdc-tables.md): How CDC tables keep one live…
- [Export data](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/exporting-data.md): Export query results from Fi…
- [Iceberg](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/iceberg-and-data-lake/iceberg.md): How to query, tune, and expo…
- [Query DuckLake tables with Firebolt](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/iceberg-and-data-lake/ducklake.md): Set up a DuckLake catalog on…
- [Firebolt Agent](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/ai/firebolt-agent.md): Use Firebolt Agent to get an…
- [Getting started with AI](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/ai/getting-started-with-ai.md): Leverage AI within your SQL…
- [Use AWS roles to access Bedrock](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/ai/use-aws-roles-to-access-bedrock.md): Learn how to use AWS IAM rol…
- [REST API](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/developing-with-firebolt/using-the-api.md): Learn about using the Firebo…
- [Node.js](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/developing-with-firebolt/connecting-with-nodejs.md): Learn about using the Node.j…
- [Python](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/developing-with-firebolt/connecting-with-python.md): Learn about using the Python…
- [JDBC](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/developing-with-firebolt/connecting-with-jdbc.md): How to use the Firebolt JDBC…
- [SQLAlchemy](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/developing-with-firebolt/connecting-with-sqlalchemy.md): Learn about using the Firebo…
- [.NET SDK](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/developing-with-firebolt/connecting-with-net-sdk.md): Learn about using the .NET S…
- [Go](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/developing-with-firebolt/connecting-with-go.md): Learn about using the Go SDK…
- [Rust](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/developing-with-firebolt/connecting-with-rust.md): Learn about using the Rust S…
- [Parametrized queries](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/developing-with-firebolt/parametrized-queries.md): Learn how to use parametrize…
- [Integrate with Firebolt](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations.md): Connect Firebolt to your fav…
- [Airbyte](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/airbyte.md): Connecting Airbyte and Fireb…
- [Airflow](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/airflow.md): Learn how to use the Apache…
- [Apache Superset](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/connecting-to-apache-superset.md): Learn about connecting Apach…
- [DataBrain](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/connecting-to-databrain.md): Learn about connecting DataB…
- [AWS Glue](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/aws-glue.md): Learn how to use AWS Glue wi…
- [AWS QuickSight](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/quicksight.md): Connecting AWS QuickSight an…
- [Cube.js](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/cube-js.md): Learn how to connect Cube.js…
- [DBeaver](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/dbeaver.md): Configure DBeaver to connect…
- [dbt - Firebolt adapter](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/dbt-firebolt-adaptor.md): Learn how to connect dbt to…
- [dbt - PostgreSQL adapter (cloud and core)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/dbt-postgres-adaptor.md): Learn how to connect dbt to…
- [Dot](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/dot.md): Connect Dot AI Data Analyst…
- [Embeddable](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/embeddable.md): Learn about connecting Embed…
- [Estuary](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/estuary.md): Using Estuary to transfer da…
- [Hex](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/hex.md): Learn how to connect Hex to…
- [Kafka Sink Connector](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/kafka-sink-connector.md): Learn about moving data from…
- [LangChain](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/langchain.md): Connect LangChain to Firebol…
- [Lightdash](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/lightdash.md): Learn how to connect dbt to…
- [Looker Cloud](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/looker-cloud.md): Connect Looker Cloud to Fire…
- [Looker On-Prem](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/looker-on-prem.md): Connect Looker On-Prem to Fi…
- [MCP Server](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/mcp.md): Use Firebolt MCP Server to e…
- [Metabase Cloud](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/metabase-cloud.md): Connecting Metabase Cloud an…
- [Metabase On Prem](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/metabase-on-prem.md): Connecting Metabase and Fire…
- [OpenTelemetry Exporter](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/otel-exporter.md): Learn how to enable Firebolt…
- [Omni](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/omni.md): Learn how to connect Omni to…
- [Pandas](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/pandas.md): Use Pandas to analyze data i…
- [Paradime](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/connecting-to-paradime.md): Connect Paradime to Firebolt.
- [Power BI](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/power-bi.md): Connecting Power BI and Fire…
- [Preset](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/connecting-to-preset.md): Learn about connecting Prese…
- [Tableau](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/tableau.md): Connecting Tableau and Fireb…
- [TextQL](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/textql.md): Use TextQL to query Firebolt…
- [ThoughtSpot](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/thoughtspot.md): Connecting ThoughtSpot and F…
- [Wirekite](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/integrations/wirekite.md): Use Wirekite to migrate data…
- [Migrate to Firebolt](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/migration-guides.md): Learn how to migrate your wo…
- [Migrate from Amazon Redshift](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/guides/migration-guides/redshift.md): Learn how to migrate your wo…
- [Lexical structure](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/lexical-structure.md): Describes the lexical struct…
- [Object identifiers](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/lexical-structure/object-identifiers.md): Provides requirements and gu…
- [Reserved words](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/lexical-structure/reserved-words.md): Provides a list of reserved…
- [Operators](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/lexical-structure/operators.md): Reference for SQL operators…
- [ANY/ALL (array)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/lexical-structure/any-all-array.md): Reference for ANY(array) and…
- [ANY/ALL (subquery)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/lexical-structure/any-all-subquery.md): Reference for ANY(subquery)…
- [Explicit Transactions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/explicit-transactions.md): Reference for Explicit Trans…
- [Data types](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/data-types.md): Provides the SQL data types…
- [BYTEA data type](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/data-types/bytea.md): Describes the Firebolt imple…
- [DATE data type](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/data-types/date.md): Describes the Firebolt imple…
- [GEOGRAPHY data type](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/data-types/geography.md): Describes the Firebolt imple…
- [JSON Data Type](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/data-types/json.md): Describes Firebolt's impleme…
- [NUMERIC data type](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/data-types/numeric.md): Describes the Firebolt imple…
- [STRUCT data type](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/data-types/struct.md): Describes the Firebolt imple…
- [TIMESTAMP data type](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/data-types/timestampntz.md): Describes the Firebolt imple…
- [TIMESTAMPTZ data type](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/data-types/timestamptz.md): Describes the Firebolt imple…
- [Information Schema](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema.md): Reference for Information Sc…
- [Account info](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/account_info.md): Use this reference to learn…
- [Applicable roles](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/applicable-roles.md): Use this reference to learn…
- [Catalogs](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/catalogs.md): Use this reference to learn…
- [Columns](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/columns.md): Use this reference to learn…
- [Enabled roles](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/enabled-roles.md): Use this reference to learn…
- [Engine history](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/engine-history.md): Query the information_schema…
- [Engine metering history](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/engine-metering-history.md): Query the information_schema…
- [Engine metrics history](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/engine-metrics-history.md): Use this reference to learn…
- [Engine caches](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/engine-caches.md): Query the information_schema…
- [Engine query history](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/engine-query-history.md): Use this reference to learn…
- [Engine running queries](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/engine-running-queries.md): Use this reference to learn…
- [Engine user query history](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/engine-user-query-history.md): Use this reference to learn…
- [Engines](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/engines.md): Query the information_schema…
- [Indexes](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/indexes.md): Use this reference to learn…
- [Locations](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/locations.md): Use this reference to learn…
- [Object default privileges](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/object-default-privileges.md): Reference for the informatio…
- [Object privileges](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/object-privileges.md): Use this reference to learn…
- [Quotas](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/quotas.md): Use this reference to learn…
- [Routines](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/routines.md): Use this reference to learn…
- [CDC ingests](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/cdc-ingests.md): Use this reference to monito…
- [Schemata](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/schemata.md): Use this reference to learn…
- [Streams](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/streams.md): Use this reference to learn…
- [Tables](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/tables.md): Use this reference to learn…
- [Transactions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/transactions.md): Use this reference to learn…
- [Transitive applicable roles](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/transitive-applicable-roles.md): Use this reference to learn…
- [Users](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/users.md): Use this reference to learn…
- [Views](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/information-schema/views.md): Use this reference to learn…
- [SQL commands](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands.md): Reference for SQL commands a…
- [ALTER DEFAULT PRIVILEGES](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/alter-default-privileges.md): Reference and syntax for the…
- [ALTER NETWORK POLICY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/alter-network-policy.md): Reference and syntax for the…
- [ALTER ROLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/alter-role.md): Reference and syntax for the…
- [ALTER USER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/alter-user.md): Reference and syntax for the…
- [CREATE NETWORK POLICY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/create-network-policy.md): Reference and syntax for the…
- [CREATE ROLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/create-role.md): Reference and syntax for the…
- [CREATE USER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/create-user.md): Reference and syntax for the…
- [DROP NETWORK POLICY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/drop-network-policy.md): Reference and syntax for the…
- [DROP ROLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/drop-role.md): Reference and syntax for the…
- [DROP USER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/drop-user.md): Reference and syntax for the…
- [GRANT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/grant.md): Reference and syntax for the…
- [REVOKE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/access-control/revoke.md): Reference and syntax for the…
- [ALTER ACCOUNT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/alter-account.md): Reference and syntax for the…
- [ALTER DATABASE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/alter-database.md): Reference and syntax for the…
- [ALTER LOCATION](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/alter-location.md): Reference and syntax for the…
- [ALTER SCHEMA](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/alter-schema.md): Reference and syntax for the…
- [ALTER TABLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/alter-table.md): Reference and syntax for the…
- [ALTER VIEW](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/alter-view.md): Reference and syntax for the…
- [COMMENT ON](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/comment-on.md): Reference and syntax for the…
- [CREATE ACCOUNT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-account.md): Reference and syntax for the…
- [CREATE AGGREGATING INDEX](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-aggregating-index.md): Syntax for the CREATE AGGREG…
- [CREATE INDEX](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-index.md): Syntax for CREATE INDEX ...…
- [CREATE VECTOR SEARCH INDEX](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-vector-search-index.md): Learn how to create and opti…
- [CREATE DATABASE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-database.md): Reference and syntax for the…
- [CREATE EXTERNAL TABLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-external-table.md): Reference and syntax for the…
- [CREATE TABLE AS SELECT (CTAS)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-fact-dimension-table-as-select.md): Reference and syntax for the…
- [CREATE FUNCTION](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-function.md): Reference and syntax for the…
- [CREATE TABLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-fact-dimension-table.md): Reference and syntax for the…
- [CREATE ICEBERG DATABASE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-iceberg-database.md): Reference and syntax for the…
- [CREATE ICEBERG TABLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-iceberg-table.md): Reference and syntax for the…
- [CREATE ICEBERG TABLE AS SELECT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-iceberg-table-as-select.md): Reference and syntax for the…
- [CREATE CDC TABLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-cdc-table.md): Reference and syntax for the…
- [CREATE LOCATION (Amazon Bedrock)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-location-bedrock.md): Reference and syntax for cre…
- [CREATE LOCATION (DuckLake)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-location-ducklake.md): Create a reusable location o…
- [CREATE LOCATION (Iceberg)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-location-iceberg.md): Reference and syntax for cre…
- [CREATE LOCATION (MongoDB)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-location-mongodb.md): Reference and syntax for CRE…
- [CREATE LOCATION (Postgres)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-location-postgres.md): Reference and syntax for CRE…
- [CREATE LOCATION (Amazon S3)](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-location-s3.md): Reference and syntax for cre…
- [CREATE LOCATION](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-location.md): Reference and syntax for the…
- [CREATE SCHEMA](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-schema.md): Reference and syntax for the…
- [CREATE STREAM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-stream.md): Reference and syntax for the…
- [CREATE TABLE CLONE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-table-clone.md): Reference and syntax for the…
- [CREATE VIEW](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/create-view.md): Reference and syntax for the…
- [DROP ACCOUNT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/drop-account.md): Reference and syntax for the…
- [DROP DATABASE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/drop-database.md): Reference and syntax for the…
- [DROP FUNCTION](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/drop-function.md): Reference and syntax for the…
- [DROP INDEX](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/drop-index.md): Reference and syntax for the…
- [DROP LOCATION](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/drop-location.md): Reference and syntax for the…
- [DROP SCHEMA](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/drop-schema.md): Reference and syntax for the…
- [DROP TABLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/drop-table.md): Reference and syntax for the…
- [DROP VIEW](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/drop-view.md): Reference and syntax for the…
- [USE DATABASE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-definition/use-database.md): Reference and syntax for the…
- [COPY FROM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-management/copy-from.md): Reference and syntax for the…
- [COPY TO](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-management/copy-to.md): Reference and syntax for the…
- [DELETE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-management/delete.md): Reference and syntax for the…
- [INSERT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-management/insert.md): Reference and syntax for the…
- [MERGE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-management/merge.md): Reference and syntax for the…
- [TRUNCATE TABLE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-management/truncate-table.md): Reference and syntax for the…
- [UPDATE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-management/update.md): Reference and syntax for the…
- [VACUUM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/data-management/vacuum.md): Reference and syntax for the…
- [Engine commands](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/engines.md): Reference for engine commands
- [ALTER ENGINE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/engines/alter-engine.md): Reference and syntax for the…
- [CREATE ENGINE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/engines/create-engine.md): Reference and syntax for the…
- [DROP ENGINE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/engines/drop-engine.md): Reference and syntax for the…
- [START ENGINE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/engines/start-engine.md): Reference and syntax for the…
- [STOP ENGINE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/engines/stop-engine.md): Reference and syntax for the…
- [USE ENGINE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/engines/use-engine.md): Reference and syntax for the…
- [CLEAR CACHE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/engines/clear-cache.md): Reference and syntax for the…
- [CANCEL QUERY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/queries/cancel.md): Cancel a running query withi…
- [EXPLAIN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/queries/explain.md): Analyze and display query ex…
- [SELECT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/queries/select.md): Reference and syntax for SEL…
- [Cross-database queries](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/queries/cross-database-queries.md): Query across multiple databa…
- [DESCRIBE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/metadata/describe.md): Reference and syntax for the…
- [SHOW CACHE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/metadata/show-cache.md): Reference and syntax for the…
- [SHOW CATALOGS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/metadata/show-catalogs.md): Reference and syntax for the…
- [SHOW COLUMNS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/metadata/show-columns.md): Reference and syntax for the…
- [SHOW ENGINES](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/metadata/show-engines.md): Reference and syntax for the…
- [SHOW INDEXES](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/metadata/show-indexes.md): Reference and syntax for the…
- [SHOW TABLES](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/metadata/show-tables.md): Reference and syntax for the…
- [SHOW VIEWS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/commands/metadata/show-views.md): Reference and syntax for the…
- [SQL functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference.md): Reference for SQL functions…
- [Functions glossary](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/functions-glossary.md): Reference for SQL functions…
- [ANY_VALUE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/any_value.md): Reference material for ANY_V…
- [APPROX_COUNT_DISTINCT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/approx-count-distinct.md): Reference material for APPRO…
- [ARRAY_AGG](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/array-agg.md): Reference material for ARRAY…
- [AVG](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/avg.md): Reference material for AVG
- [BIT_AND](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/bit_and.md): Reference material for BIT_A…
- [BIT_OR](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/bit_or.md): Reference material for BIT_OR
- [BIT_XOR](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/bit_xor.md): Reference material for BIT_X…
- [BOOL_AND](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/bool_and.md): Reference material for BOOL_…
- [BOOL_OR](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/bool_or.md): Reference material for BOOL_…
- [CORR](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/corr.md): Reference material for CORR
- [COUNT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/count.md): Reference material for COUNT
- [COUNTING_HLL_COUNT_DISTINCT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/counting-hll-count-distinct.md): Reference material for COUNT…
- [COVAR_POP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/covar-pop.md): Reference material for COVAR…
- [COVAR_SAMP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/covar-samp.md): Reference material for COVAR…
- [GROUPING](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/grouping.md): Reference material for GROUP…
- [HASH_AGG](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/hash-agg.md): Reference material for HASH_…
- [HLL_COUNT_BUILD](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/hll-count-build.md): Reference material for HLL_C…
- [HLL_COUNT_DISTINCT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/hll-count-distinct.md): Reference material for HLL_C…
- [HLL_COUNT_MERGE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/hll-count-merge.md): Reference material for HLL_C…
- [MAX_BY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/max-by.md): Reference material for MAX_BY
- [MAX](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/max.md): Reference material for MAX
- [MEDIAN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/median.md): Reference material for MEDIAN
- [MIN_BY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/min-by.md): Reference material for MIN_BY
- [MIN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/min.md): Reference material for MIN
- [PERCENTILE_CONT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/percentile-cont.md): Reference material for PERCE…
- [STDDEV_POP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/stddev-pop.md): Reference material for STDDE…
- [STDDEV_SAMP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/stddev-samp.md): Reference material for STDDE…
- [STRING_AGG](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/string-agg.md): Reference material for STRIN…
- [SUM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/sum.md): Reference material for SUM
- [VAR_POP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/variance-pop.md): Reference material for VAR_P…
- [VAR_SAMP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/aggregation/variance-samp.md): Reference material for VAR_S…
- [AI functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/ai.md): Reference for AI functions
- [AI_EMBED_TEXT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/ai/ai-embed-text.md): Generate a text embedding wi…
- [AI_QUERY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/ai/ai-query.md): Invoke an LLM endpoint and r…
- [AWS_BEDROCK_AI_QUERY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/ai/aws-bedrock-ai-query.md): Invoke an Amazon Bedrock mod…
- [ARRAY_CONCAT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-concat.md): Reference material for ARRAY…
- [ARRAY_CONTAINS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-contains.md): Reference material for ARRAY…
- [ARRAY_COUNT_DISTINCT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-count-distinct.md): Reference material for ARRAY…
- [ARRAY_COUNT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-count.md): Reference material for ARRAY…
- [ARRAY_DISTINCT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-distinct.md): Reference material for ARRAY…
- [ARRAY_INTERSECT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-intersect.md): Reference material for ARRAY…
- [ARRAY_LENGTH](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-length.md): Reference material for ARRAY…
- [ARRAY_MAX](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-max.md): Reference material for ARRAY…
- [ARRAY_MIN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-min.md): Reference material for ARRAY…
- [ARRAY_REVERSE_SORT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-reverse-sort.md): Reference material for ARRAY…
- [ARRAY_REVERSE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-reverse.md): Reference material for ARRAY…
- [ARRAY_SLICE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-slice.md): Reference material for ARRAY…
- [ARRAY_SORT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-sort.md): Reference material for ARRAY…
- [ARRAY_SUM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-sum.md): Reference material for ARRAY…
- [ARRAY_TO_STRING](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-to-string.md): Reference material for ARRAY…
- [ARRAY_UPPER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/array-upper.md): Reference material for ARRAY…
- [ARRAYS_OVERLAP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/arrays-overlap.md): Reference material for ARRAY…
- [ARRAY_FLATTEN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/flatten.md): Reference material for ARRAY…
- [INDEX_OF](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/array/index-of.md): Reference material for INDEX…
- [CONVERT_FROM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/bytea/convert-from.md): Reference material for CONVE…
- [DECODE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/bytea/decode.md): Reference material for DECOD…
- [ENCODE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/bytea/encode.md): Reference material for ENCOD…
- [CASE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/case.md): Reference material for CASE…
- [CAST](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/cast.md): Reference material for CAST…
- [CITY_HASH](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/city-hash.md): Reference material for CITY_…
- [COALESCE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/coalesce.md): Reference material for COALE…
- [GREATEST](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/greatest.md): Reference material for GREAT…
- [HASH](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/hash.md): Reference material for HASH…
- [IF](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/if.md): Reference material for IF fu…
- [IFNULL](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/ifnull.md): Reference material for IFNUL…
- [LEAST](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/least.md): Reference material for LEAST…
- [NULLIF](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/nullif.md): Reference material for NULLI…
- [TRY_CAST](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/try-cast.md): Reference material for TRY_C…
- [TYPEOF](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/typeof.md): Reference material for TYPEO…
- [VERSION](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/conditional-and-miscellaneous/version.md): Reference material for VERSI…
- [DataSketches functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/datasketches.md): Reference for datasketches f…
- [APACHE_DATASKETCHES_HLL_BUILD](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/datasketches/apache-datasketches-hll-build.md): Reference material for APACH…
- [APACHE_DATASKETCHES_HLL_ESTIMATE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/datasketches/apache-datasketches-hll-estimate.md): Reference material for APACH…
- [APACHE_DATASKETCHES_HLL_MERGE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/datasketches/apache-datasketches-hll-merge.md): Reference material for APACH…
- [AGO](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/ago.md): Reference material for AGO f…
- [CURRENT_DATE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/current-date.md): Reference material for CURRE…
- [CURRENT_TIMESTAMP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/current-timestamptz.md): Reference material for CURRE…
- [DATE_ADD](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/date-add.md): Reference material for DATE_…
- [DATE_DIFF](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/date-diff.md): Reference material for DATE_…
- [DATE_TRUNC](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/date-trunc.md): Reference material for the D…
- [DATE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/date.md): Reference material for DATE…
- [EXTRACT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/extract.md): Reference material for the E…
- [LOCALTIMESTAMP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/localtimestamp.md): Reference material for LOCAL…
- [TO_CHAR](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/to-char.md): Reference material for TO_CH…
- [TO_DATE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/to-date.md): Reference material for TO_DA…
- [TO_TIMESTAMP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/to-timestamp.md): Reference material for TO_TI…
- [TO_YYYYMM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/to-yyyymm.md): Reference material for the T…
- [TO_YYYYMMDD](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/date-and-time/to-yyyymmdd.md): Reference material for the T…
- [ST_ASBINARY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_asbinary.md): Reference material for ST_AS…
- [ST_ASEWKB](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_asewkb.md): Reference material for ST_AS…
- [ST_ASGEOJSON](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_asgeojson.md): Reference material for ST_AS…
- [ST_ASTEXT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_astext.md): Reference material for ST_AS…
- [ST_CONTAINS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_contains.md): Reference material for ST_CO…
- [ST_COVERS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_covers.md): Reference material for ST_CO…
- [ST_DISTANCE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_distance.md): Reference material for ST_DI…
- [ST_GEOGFROMGEOJSON](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_geogfromgeojson.md): Reference material for ST_GE…
- [ST_GEOGFROMTEXT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_geogfromtext.md): Reference material for ST_GE…
- [ST_GEOGFROMWKB](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_geogfromwkb.md): Reference material for ST_GE…
- [ST_GEOGPOINT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_geogpoint.md): Reference material for ST_GE…
- [ST_INTERSECTS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_intersects.md): Reference material for ST_IN…
- [ST_S2CELLIDFROMPOINT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_s2cellidfrompoint.md): Reference material for ST_S2…
- [ST_X](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_x.md): Reference material for ST_X…
- [ST_Y](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/geospatial/st_y.md): Reference material for ST_Y…
- [Iceberg functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/iceberg.md): Reference for Iceberg functi…
- [READ_ICEBERG](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/iceberg/read_iceberg.md): Reference material for READ_…
- [LIST_ICEBERG_FILES](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/iceberg/list_iceberg_files.md): Lists the data files of an I…
- [ICEBERG_YEAR](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/iceberg/partitioning/iceberg_year.md): Extract year as years from 1…
- [ICEBERG_MONTH](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/iceberg/partitioning/iceberg_month.md): Extract month as months from…
- [ICEBERG_DAY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/iceberg/partitioning/iceberg_day.md): Extract day as days from 197…
- [ICEBERG_HOUR](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/iceberg/partitioning/iceberg_hour.md): Extract hour as hours from 1…
- [ICEBERG_BUCKET](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/iceberg/partitioning/iceberg_bucket.md): Hash value into a bucket acc…
- [ICEBERG_TRUNCATE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/iceberg/partitioning/iceberg_truncate.md): Truncate value to a width ac…
- [DuckLake functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/ducklake/ducklake.md): Overview of the Firebolt tab…
- [READ_DUCKLAKE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/ducklake/read_ducklake.md): Read rows from a DuckLake ta…
- [LIST_DUCKLAKE_FILES](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/ducklake/list_ducklake_files.md): List the Parquet data files…
- [JSON functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json.md): Reference for JSON functions
- [CHECK_JSON](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/check-json.md): Reference material for CHECK…
- [JSON_ARRAY_LENGTH](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-array-length.md): Reference material for JSON_…
- [JSON_EXTRACT_ARRAY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-extract-array.md): Reference material for JSON_…
- [JSON_EXTRACT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-extract.md): Reference material for JSON_…
- [JSON_POINTER_EXTRACT_KEYS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-pointer-extract-keys.md): Reference material for JSON_…
- [JSON_POINTER_EXTRACT_TEXT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-pointer-extract-text.md): Reference material for JSON_…
- [JSON_POINTER_EXTRACT_VALUES](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-pointer-extract-values.md): Reference material for JSON_…
- [JSON_VALUE_ARRAY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-value-array.md): Reference material for JSON_…
- [JSON_VALUE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-value.md): Reference material for JSON_…
- [JSON_FORMAT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-format.md): Reference for JSON_FORMAT fu…
- [JSON_IS_VALID](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-is-valid.md): Reference material for JSON_…
- [JSON_TYPEOF](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-typeof.md): Reference material for JSON_…
- [JSON Operators](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/json-operators.md): Reference material for JSON…
- [TO_JSON](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/to-json.md): Reference material for the T…
- [TO_JSON_STRING](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/json/to-json-string.md): Reference material for TO_JS…
- [Lambda functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/lambda.md): Reference for lambda functio…
- [ARRAY_ALL_MATCH](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/lambda/array-all-match.md): Reference material for ARRAY…
- [ARRAY_ANY_MATCH](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/lambda/array-any-match.md): Reference material for ARRAY…
- [ARRAY_FIRST](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/lambda/array-first.md): Reference material for ARRAY…
- [ARRAY_FILTER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/lambda/filter.md): Reference material for ARRAY…
- [ARRAY_TRANSFORM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/lambda/transform.md): Reference material for ARRAY…
- [ABS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/abs.md): Reference material for ABS f…
- [ACOS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/acos.md): Reference material for ACOS…
- [ARRAY_ENUMERATE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/array-enumerate.md): Reference material for ARRAY…
- [ASIN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/asin.md): Reference material for ASIN…
- [ATAN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/atan.md): Reference material for ATAN…
- [ATAN2](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/atan2.md): Reference material for ATAN2…
- [BIT_SHIFT_LEFT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/bit_shift_left.md): Reference material for BIT_S…
- [BIT_SHIFT_RIGHT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/bit_shift_right.md): Reference material for BIT_S…
- [CBRT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/cbrt.md): Reference material for CBRT…
- [CEIL](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/ceil.md): Reference material for CEIL,…
- [COS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/cos.md): Reference material for COS f…
- [COT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/cot.md): Reference material for COT f…
- [DEGREES](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/degrees.md): Reference material for DEGRE…
- [EXP](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/exp.md): Reference material for EXP f…
- [FLOOR](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/floor.md): Reference material for FLOOR…
- [HLL_COUNT_ESTIMATE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/hll-count-estimate.md): Reference material for HLL_C…
- [IS_FINITE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/is_finite.md): Reference material for the I…
- [IS_INFINITE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/is_infinite.md): Reference material for the I…
- [LN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/ln.md): Reference material for LN fu…
- [LOG](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/log.md): Reference material for LOG f…
- [MOD](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/mod.md): Reference material for MOD f…
- [PARAM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/param.md): Reference material for PARAM…
- [PI](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/pi.md): Reference material for PI fu…
- [POW](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/pow.md): Reference material for POW,…
- [RADIANS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/radians.md): Reference material for RADIA…
- [RANDOM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/random.md): Reference material for RANDO…
- [ROUND](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/round.md): Reference material for ROUND…
- [SIGN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/sign.md): Reference material for SIGN…
- [SIN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/sin.md): Reference material for SIN f…
- [SQRT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/sqrt.md): Reference material for SQRT…
- [TAN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/tan.md): Reference material for TAN f…
- [TRUNC](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/numeric/trunc.md): Reference material for TRUNC…
- [CURRENT_ACCOUNT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/session/current-account.md): Reference material for CURRE…
- [CURRENT_DATABASE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/session/current-database.md): Reference material for CURRE…
- [SESSION_USER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/session/session-user.md): Reference material for SESSI…
- [BTRIM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/btrim.md): Reference material for BTRIM…
- [CONCAT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/concat.md): Reference material for CONCA…
- [GEN_RANDOM_UUID_TEXT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/gen-random-uuid-text.md): Reference material for GEN_R…
- [ICU_NORMALIZE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/icu_normalize.md): Reference material for ICU_N…
- [ILIKE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/ilike.md): Reference material for ILIKE…
- [LENGTH](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/length.md): Reference material for LENGT…
- [LIKE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/like.md): Reference material for LIKE…
- [LOWER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/lower.md): Reference material for LOWER…
- [LPAD](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/lpad.md): Reference material for LPAD…
- [LTRIM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/ltrim.md): Reference material for LTRIM…
- [MD5](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/md5.md): Reference material for MD5 f…
- [MD5_NUMBER_LOWER64](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/md5-number-lower64.md): Reference material for MD5_N…
- [MD5_NUMBER_UPPER64](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/md5-number-upper64.md): Reference material for MD5_N…
- [NGRAM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/ngram.md): Reference material for NGRAM…
- [OCTET_LENGTH](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/octet_length.md): Reference material for OCTET…
- [POSITION](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/position.md): Reference material for POSIT…
- [REGEXP_EXTRACT_ALL](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/regexp-extract-all.md): Reference material for REGEX…
- [REGEXP_EXTRACT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/regexp-extract.md): Reference material for REGEX…
- [REGEXP_LIKE_ANY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/regexp-like-any.md): Reference material for REGEX…
- [REGEXP_LIKE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/regexp-like.md): Reference material for REGEX…
- [REGEXP_REPLACE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/regexp-replace.md): Reference material for REGEX…
- [REPEAT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/repeat.md): Reference material for REPEA…
- [REPLACE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/replace.md): Reference material for REPLA…
- [REVERSE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/reverse.md): Reference material for REVER…
- [RPAD](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/rpad.md): Reference material for RPAD…
- [RTRIM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/rtrim.md): Reference material for RTRIM…
- [SPLIT_PART](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/split-part.md): Reference material for SPLIT…
- [SOUNDEX](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/soundex.md): Reference material for SOUND…
- [STRING_TO_ARRAY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/string-to-array.md): Reference material for STRIN…
- [STRPOS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/strpos.md): Reference material for STRPO…
- [SUBSTRING, SUBSTR](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/substring.md): Reference material for SUBST…
- [TO_BIN](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/to_bin.md): Reference material for the T…
- [TO_OCT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/to_oct.md): Reference material for the T…
- [TRIM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/trim.md): Reference material for TRIM…
- [UPPER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/upper.md): Reference material for UPPER…
- [URL_DECODE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/url_decode.md): Reference material for URL_D…
- [URL_ENCODE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/string/url_encode.md): Reference material for URL_E…
- [Table-valued functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/table-valued.md): Reference for table-valued f…
- [GENERATE_SERIES](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/table-valued/generate-series.md): Reference material for GENER…
- [LIST_OBJECTS](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/table-valued/list-objects.md): Reference material for LIST_…
- [READ_AVRO](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/table-valued/read_avro.md): Reference material for READ_…
- [READ_CSV](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/table-valued/read_csv.md): Reference material for READ_…
- [READ_FILES](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/table-valued/read_files.md): Reference material for READ_…
- [READ_JSON](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/table-valued/read_json.md): Reference material for READ_…
- [READ_PARQUET](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/table-valued/read_parquet.md): Reference material for READ_…
- [PARQUET_METADATA](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/table-valued/parquet_metadata.md): Returns the row-group and co…
- [READ_STREAM](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/table-valued/read_stream.md): Reference material for READ_…
- [READ_TEXT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/table-valued/read_text.md): Reference material for READ_…
- [Vector functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/vector.md): Reference for vector functio…
- [VECTOR_ADD](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/vector/vector-add.md): Reference material for VECTO…
- [VECTOR_COSINE_DISTANCE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/vector/vector-cosine-distance.md): Reference material for VECTO…
- [VECTOR_COSINE_SIMILARITY](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/vector/vector-cosine-similarity.md): Reference material for VECTO…
- [VECTOR_EUCLIDEAN_DISTANCE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/vector/vector-euclidean-distance.md): Reference material for VECTO…
- [VECTOR_INNER_PRODUCT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/vector/vector-inner-product.md): Reference material for VECTO…
- [VECTOR_MANHATTAN_DISTANCE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/vector/vector-manhattan-distance.md): Reference material for VECTO…
- [VECTOR_SEARCH](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/vector/vector-search.md): Reference material for VECTO…
- [VECTOR_SQUARED_EUCLIDEAN_DISTANCE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/vector/vector-squared-euclidean-distance.md): Reference material for VECTO…
- [VECTOR_SUBTRACT](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/vector/vector-subtract.md): Reference material for VECTO…
- [Window functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window.md): Reference for window functio…
- [AVG OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/avg-window.md): Reference material for AVG f…
- [COUNT OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/count-window.md): Reference material for COUNT…
- [CUME_DIST OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/cume-dist.md): Reference material for CUME_…
- [DENSE_RANK OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/dense-rank.md): Reference material for DENSE…
- [FIRST_VALUE](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/first-value.md): Reference material for FIRST…
- [LAG OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/lag.md): Reference material for LAG f…
- [LEAD OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/lead.md): Reference material for LEAD…
- [MAX OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/max-window.md): Reference material for MAX f…
- [MIN OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/min-window.md): Reference material for MIN f…
- [NTH_VALUE OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/nth-value.md): Reference material for NTH_V…
- [NTILE OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/ntile.md): Reference material for NTILE…
- [PERCENT_RANK OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/percent-rank.md): Reference material for PERCE…
- [RANK OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/rank.md): Reference material for RANK…
- [ROW_NUMBER OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/row-number.md): Reference material for ROW_N…
- [SUM OVER](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/functions-reference/window/sum-window.md): Reference material for SUM f…
- [System settings](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-sql/system-settings.md): Lists Firebolt system settin…
- [BigQuery compatibility](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/overview.md): Run BigQuery GoogleSQL again…
- [Query syntax](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/query-syntax.md): BigQuery GoogleSQL query syn…
- [Pipe syntax](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/pipe-syntax.md): BigQuery pipe query syntax s…
- [Data types](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/data-types.md): BigQuery data types and thei…
- [Operators](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/operators.md): BigQuery operators supported…
- [Date and time functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/functions/date-and-time.md): BigQuery date, datetime, tim…
- [String functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/functions/string.md): BigQuery string and regular…
- [JSON functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/functions/json.md): BigQuery JSON functions and…
- [Array functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/functions/array.md): BigQuery array functions and…
- [Aggregate and approximate functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/functions/aggregate.md): BigQuery aggregate, statisti…
- [Math functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/functions/math.md): BigQuery mathematical functi…
- [Geography functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/functions/geography.md): BigQuery geography functions…
- [Conditional and conversion functions](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/functions/conditional-and-conversion.md): BigQuery conditional, conver…
- [Statements](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/compatibility-modes/bigquery/statements.md): BigQuery DDL, DML, transacti…
- [Release notes](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/release-notes.md): Latest release notes for the…
- [Release notes archive](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/release-notes/release-notes-archive.md): Release notes archive for th…
- [API reference](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-api.md): Learn how to use Firebolt pr…
- [Synchronous queries](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-api/using-sync-queries.md): Learn how to submit sync que…
- [Asynchronous queries](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-api/using-async-queries.md): Learn how to submit async qu…
- [Upload and query local files](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/reference-api/uploading-files.md): Send local files with a SQL…
- [Submit a sql statement for execution](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/api-reference/submit-a-sql-statement-for-execution.md)
- [Firebolt Data Portability & Switching Specifications](https://firebolt-aggregate-helm-docs-pr-80.mintlify.site/legal/data-portability-and-export.md): Technical reference regardin…

## OpenAPI Specs

- [firebolt_query_v2.3](https://raw.githubusercontent.com/firebolt-db/openapi/main/specification/yaml/firebolt_query_v2.3.yaml)