# 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 - [Submit a sql statement for execution](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/api-reference/submit-a-sql-statement-for-execution.md) - [Firebolt Core](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core.md): Firebolt Core is a free, self-hosted… - [Architecture](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-architecture.md): Overview of the high-level architect… - [Connect](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-connect.md): Learn how clients connect to a Fireb… - [Connect via CLI](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-connect/firebolt-core-connect-cli.md): Use the official Firebolt CLI to con… - [Connect With Go](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-connect/firebolt-core-connect-go.md): Connect to Firebolt Core using the o… - [Connect With JDBC](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-connect/firebolt-core-connect-jdbc.md): Connect to Firebolt Core using the o… - [Connect With Node.js](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-connect/firebolt-core-connect-nodejs.md) - [Connect With Python](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-connect/firebolt-core-connect-python.md): Connect to Firebolt Core using the P… - [Connect via UI](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-connect/firebolt-core-connect-ui.md): Use the web UI interface to connect… - [Process Data](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-data-processing.md): Learn how to import, manage, and exp… - [Differences between Firebolt Core and Managed Firebolt](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-differences.md): Key differences between the self-hos… - [Frequently Asked Questions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-faq.md): Answers to common questions about Fi… - [Get Started](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-get-started.md): Get started with Firebolt Core by ru… - [Apache Superset with Firebolt Core](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-integrate/firebolt-core-connect-apache-superset.md): Learn about connecting Apache Supers… - [dbt](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-integrate/firebolt-core-connect-with-dbt.md): Use dbt (Data Build Tool) with Fireb… - [Deployment and Operational Guide](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-operation.md): Configuration options and operationa… - [Deployment using Docker Compose](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-operation/firebolt-core-deployment-compose.md): Deploy a multi-node Firebolt Core cl… - [Deployment on Kubernetes](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-operation/firebolt-core-deployment-k8s.md): Deploy a multi-node Firebolt Core cl… - [Fault tolerance](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-operation/firebolt-core-fault-tolerance.md): Fault tolerance characteristics of F… - [Amazon S3](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-operation/firebolt-core-object-storage-access/firebolt-core-object-storage-access-s3.md): Configure Amazon S3 as the backing o… - [Roadmap](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-roadmap.md): Planned features and upcoming improv… - [Troubleshoot](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/firebolt-core/firebolt-core-troubleshooting.md): Troubleshooting tools and support ch… - [Firebolt Agent](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/ai/firebolt-agent.md): Use Firebolt Agent to get answers, g… - [Getting started with AI](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/ai/getting-started-with-ai.md): Leverage AI within your SQL queries - [Use AWS roles to access Bedrock](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/ai/use-aws-roles-to-access-bedrock.md): Learn how to use AWS IAM roles to al… - [Go](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/developing-with-firebolt/connecting-with-go.md): Learn about using the Go SDK for Fir… - [JDBC](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/developing-with-firebolt/connecting-with-jdbc.md): How to use the Firebolt JDBC driver - [.NET SDK](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/developing-with-firebolt/connecting-with-net-sdk.md): Learn about using the .NET SDK for F… - [Node.js](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/developing-with-firebolt/connecting-with-nodejs.md): Learn about using the Node.js SDK fo… - [Python](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/developing-with-firebolt/connecting-with-python.md): Learn about using the Python SDK for… - [Rust](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/developing-with-firebolt/connecting-with-rust.md): Learn about using the Rust SDK for F… - [SQLAlchemy](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/developing-with-firebolt/connecting-with-sqlalchemy.md): Learn about using the Firebolt adapt… - [Parametrized queries](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/developing-with-firebolt/parametrized-queries.md): Learn how to use parametrized querie… - [REST API](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/developing-with-firebolt/using-the-api.md): Learn about using the Firebolt API t… - [Export data](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/exporting-data.md): Export query results from Firebolt t… - [Get started](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/getting-started.md): Follow this getting started tutorial… - [Get started using a wizard](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/getting-started/get-started-load-data-wizard.md): Use the Load data wizard to create a… - [Resources beyond getting started](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/getting-started/get-started-next.md): Additional resources and next steps… - [Get started using SQL](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/getting-started/get-started-sql.md) - [Use Web UI](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/getting-started/using-the-develop-workspace.md): Learn how to navigate and use the de… - [Integrate with Firebolt](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations.md): Connect Firebolt to your favorite to… - [Airbyte](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/airbyte.md): Connecting Airbyte and Firebolt. - [Airflow](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/airflow.md): Learn how to use the Apache Airflow… - [AWS Glue](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/aws-glue.md): Learn how to use AWS Glue with Fireb… - [Apache Superset](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/connecting-to-apache-superset.md): Learn about connecting Apache Supers… - [DataBrain](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/connecting-to-databrain.md): Learn about connecting DataBrain to… - [Paradime](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/connecting-to-paradime.md): Connect Paradime to Firebolt. - [Preset](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/connecting-to-preset.md): Learn about connecting Preset to Fir… - [Cube.js](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/cube-js.md): Learn how to connect Cube.js to Fire… - [DBeaver](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/dbeaver.md): Configure DBeaver to connect to Fire… - [dbt - Firebolt adapter (core only)](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/dbt-firebolt-adaptor.md): Learn how to connect dbt to Firebolt… - [dbt - PostgreSQL adapter (cloud and core)](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/dbt-postgres-adaptor.md): Learn how to connect dbt to Firebolt… - [Dot](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/dot.md): Connect Dot AI Data Analyst to Fireb… - [Embeddable](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/embeddable.md): Learn about connecting Embeddable to… - [Estuary](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/estuary.md): Using Estuary to transfer data to Fi… - [Hex](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/hex.md): Learn how to connect Hex to Firebolt… - [Kafka Sink Connector](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/kafka-sink-connector.md): Learn about moving data from Apache… - [LangChain](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/langchain.md): Connect LangChain to Firebolt using… - [Lightdash](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/lightdash.md): Learn how to connect dbt to Firebolt… - [Looker Cloud](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/looker-cloud.md): Connect Looker Cloud to Firebolt usi… - [Looker On-Prem](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/looker-on-prem.md): Connect Looker On-Prem to Firebolt u… - [MCP Server](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/mcp.md): Use Firebolt MCP Server to enable AI… - [Metabase Cloud](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/metabase-cloud.md): Connecting Metabase Cloud and Firebo… - [Metabase On Prem](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/metabase-on-prem.md): Connecting Metabase and Firebolt. - [Omni](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/omni.md): Learn how to connect Omni to Firebol… - [OpenTelemetry Exporter](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/otel-exporter.md): Learn how to enable Firebolt OpenTel… - [Pandas](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/pandas.md): Use Pandas to analyze data in Firebo… - [Power BI](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/power-bi.md): Connecting Power BI and Firebolt. - [AWS QuickSight](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/quicksight.md): Connecting AWS QuickSight and Firebo… - [Tableau](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/tableau.md): Connecting Tableau and Firebolt. - [TextQL](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/textql.md): Use TextQL to query Firebolt with na… - [ThoughtSpot](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/thoughtspot.md): Connecting ThoughtSpot and Firebolt. - [Wirekite](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/integrations/wirekite.md): Use Wirekite to migrate databases or… - [Load data](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/loading-data.md): Understand options for loading data… - [Use AWS roles to access S3](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/loading-data/configuring-aws-role-to-access-amazon-s3.md): Learn how to use AWS IAM roles to al… - [Creating Access Key and Secret ID in AWS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/loading-data/creating-access-keys-aws.md): Understand how to create security cr… - [Load data using SQL](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/loading-data/loading-data-sql.md): Understand options for loading data… - [Load data using a wizard](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/loading-data/loading-data-wizard.md): Understand options for loading data… - [Query DuckLake tables with Firebolt Core](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/loading-data/querying-ducklake-tables.md): Step-by-step guide to setting up a D… - [Work with external tables](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/loading-data/working-with-external-tables.md): Understand the role of external tabl… - [Work with semi-structured data](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/loading-data/working-with-semi-structured-data.md): Learn how to handle semi-structured… - [Load semi-structured JSON data](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/loading-data/working-with-semi-structured-data/load-json-data.md): Learn how to map semi-structured dat… - [Load semi-structured Parquet data](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/loading-data/working-with-semi-structured-data/load-parquet-data.md): Learn how to load Parquet data into… - [Manage organization](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/managing-your-organization.md): Learn about user permissions and how… - [Billing](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/managing-your-organization/billing.md): Understand how Firebolt bills for co… - [Register to Firebolt](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/managing-your-organization/creating-an-organization.md): Learn how to create an organization. - [Manage accounts](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/managing-your-organization/managing-accounts.md): Learn about how to add and remove ac… - [Manage logins](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/managing-your-organization/managing-logins.md): Learn about user permissions and how… - [Manage users and roles](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/managing-your-organization/managing-users.md): Learn about user permissions and how… - [Manage programmatic access](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/managing-your-organization/service-accounts.md): Create and manage programmatic acces… - [Migrate to Firebolt](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/migration-guides.md): Learn how to migrate your workflow i… - [Migrate from Amazon Redshift](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/migration-guides/redshift.md): Learn how to migrate your workflow f… - [Engine Warmpools](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/operate-engines/engine-warmpools.md): Learn about engine warmpools and wha… - [Release settings](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/operate-engines/engines-release-settings.md): Learn how to control the release upg… - [Governing Engines](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/operate-engines/rbac-for-engines.md): Learn how to use Role Based Access C… - [Sizing Engines](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/operate-engines/sizing-engines.md): Learn how to size engines initially… - [System Engine](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/operate-engines/system-engine.md): System engine documentation - [Understanding Autoscaling](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/operate-engines/understand-autoscaling.md): Learn how autoscaling works in Fireb… - [Warming Up Engines](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/operate-engines/warming-up-engines.md): Learn how to warm up engines for opt… - [Work with engines](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/operate-engines/working-with-engines-using-ddl.md): Learn how to create, modify and run… - [Column-level security](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/column-level-security.md): Learn how to use column-level securi… - [Multi-factor authentication](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/enabling-mfa.md): Learn about how to enable and disabl… - [LOCATION objects](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/location.md): Learn about LOCATION objects in Fire… - [Network policies](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/network-policies.md): Learn about creating and managing ne… - [Ownership](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/ownership.md): Learn about object Ownership in Fire… - [AWS PrivateLink](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/privatelink.md): Learn how to set up and use AWS Priv… - [Role-based access control (RBAC)](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/rbac.md): Learn about managing RBAC authorizat… - [Using secure views](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/rbac-views-security.md): Learn how to use views with Firebolt… - [Configure SSO](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/sso.md): Learn about how to set up SSO authen… - [Auth0](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/sso/auth0.md): Learn how to configure Auth0 as your… - [Custom Identity Provider](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/sso/custom-sso.md): Learn how to configure a custom Iden… - [Okta](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/sso/okta.md): Learn how to configure Okta as your… - [OneLogin](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/sso/onelogin.md): Learn how to configure OneLogin as y… - [PingFederate](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/sso/pingfederate.md): Learn how to configure PingFederate… - [Salesforce](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/security/sso/salesforce.md): Learn how to configure Salesforce as… - [Arrays](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/sql-dialect/arrays.md): Learn techniques to manipulate and t… - [Collations](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/sql-dialect/collations.md): Learn how to work with collations in… - [Parametrized queries](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/sql-dialect/parametrized-queries.md): Learn how to write parametrized SQL… - [SQL Pipe syntax](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/guides/sql-dialect/sql-pipe-syntax.md): Reference and syntax for SQL Pipe sy… - [What is Firebolt?](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/intro.md): Product overview - [Platform capabilities](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/intro/product-platform.md): Firebolt platform capabilities - [Firebolt Data Portability & Switching Specifications](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/legal/data-portability-and-export.md): Technical reference regarding data p… - [Architecture](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/architecture-overview.md): Discover how the decoupled compute a… - [Pricing and billing](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/billing.md): How Firebolt bills for usage - [Data management](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/data-management.md): Explore how Firebolt supports the da… - [Engine Fundamentals](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/engine-fundamentals.md): Learn fundamental concepts about Fir… - [Engine Consumption](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/engine-fundamentals/engine-consumption.md): Understand Firebolt's consumption me… - [Data modeling](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/indexes.md): Understand how to organize data from… - [Organizations and accounts](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/organizations-accounts.md): Learn about Firebolt organization an… - [Queries](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/queries.md): Learn about running queries, improvi… - [Subresult reuse and result caching](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/queries/understand-query-performance-subresult.md): How to understand subresult reuse an… - [Spilling](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/queries/understand-spilling.md): How to understand spilling and reaso… - [Security](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security.md): Introduction to Firebolt security fe… - [Role-Based Access Control](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac.md): Learn about role-based access contro… - [Account Permissions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/account-permissions.md): Learn about account-level permission… - [Check Assigned Privileges](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/check-privileges.md): Learn how to view and verify assigne… - [Database permissions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/database-permissions.md): Understand the permissions that can… - [Schema permissions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/database-permissions/schema-permissions.md): Learn about the permissions that can… - [Table permissions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/database-permissions/table-permissions.md): Learn about the permissions that can… - [View permissions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/database-permissions/view-permissions.md): Learn about the permissions that can… - [Engine Permissions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/engine-permissions.md): Learn about engine-level permissions… - [Location Permissions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/location-permissions.md): Learn about location-related permiss… - [Ownership](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/ownership.md): Learn about ownership in Firebolt &… - [Role Management](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/role-management.md): Learn about role management in Fireb… - [Custom Roles](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/role-management/custom-roles.md): Learn how to create and manage custo… - [Default System Roles](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/role-management/system-roles.md): Learn about the default system roles… - [Role Permissions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/role-permissions.md): Learn about role-level permissions i… - [User Permissions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/overview/security/rbac/user-permissions.md): Learn about user-level permissions i… - [Overview](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability.md): Guides to optimizing performance in… - [Iceberg and External Data](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/iceberg-and-external-data.md): Guide to understanding and tuning Ic… - [Query Planning](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning.md): Guides to understanding and tuning t… - [Automated Column Statistics (ACS)](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/automated-column-statistics.md): Learn how to use automated column st… - [Create tables with column statistics](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/automated-column-statistics/table-with-statistics.md): How to create a table that automatic… - [Infer from user created indexes](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/automated-column-statistics/user-created-indexes.md): How to configure automated column st… - [Cardinality estimation](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/cardinality-estimation.md): Understand and control how statistic… - [History-Based Statistics](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/history-based-statistics.md): How to use statistics about past que… - [Inspecting query plans](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/inspecting-query-plans.md): Learn on how to inspect the executio… - [Join pruning](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/join-pruning.md): Use one side of a join to prune the… - [Late materialization](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/late-materialization.md): Speed up your top-k queries with lat… - [Query hints](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/query-hints.md): Influence the planner behavior using… - [No join ordering](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/query-hints/no-join-ordering.md): You can disable join order optimizat… - [No partial aggregation](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/query-hints/no-partial-aggregation.md): You can disable partial aggregation… - [Optimize for single row window partitions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/query-hints/optimize-for-single-row-window-partitions.md): Avoid expensive window operations fo… - [Unique columns](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/query-hints/unique-columns.md): You can mark a column as unique usin… - [UNIQUE constraints as query hints](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/unique-constraint.md): Understand how the UNIQUE constraint… - [User-guided mode](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/query-planning/user-guided-mode.md): Learn how to take full control over… - [Storage and indexing](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/storage-and-indexing.md): How Firebolt stores managed tables o… - [Aggregating index](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/storage-and-indexing/aggregating-index.md): Aggregating index overview - [Data skipping index](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/storage-and-indexing/data-skipping-index.md): Skip granules that cannot match a pr… - [Full-text search index](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/storage-and-indexing/full-text-search-index.md): Speed up substring and pattern match… - [Inverted index](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/storage-and-indexing/inverted-index.md): Speed up token matching and text fil… - [Primary index](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/storage-and-indexing/primary-index.md): Primary index overview - [Table and Column Compression](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/storage-and-indexing/table-and-column-compression.md): Learn about custom compression for m… - [Vector search index](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/performance-and-observability/storage-and-indexing/vector-search-index.md): Vector search index overview - [API reference](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-api.md): Learn how to use Firebolt programmat… - [Upload and query local files](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-api/uploading-files.md): Send local files with a SQL statemen… - [Asynchronous queries](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-api/using-async-queries.md): Learn how to submit async queries an… - [Synchronous queries](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-api/using-sync-queries.md): Learn how to submit sync queries and… - [SQL commands](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands.md): Reference for SQL commands and opera… - [ALTER DEFAULT PRIVILEGES](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/alter-default-privileges.md): Reference and syntax for the ALTER D… - [ALTER LOGIN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/alter-login.md): Reference and syntax for the ALTER L… - [ALTER NETWORK POLICY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/alter-network-policy.md): Reference and syntax for the ALTER N… - [ALTER ORGANIZATION ROLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/alter-organization-role.md): Reference and syntax for the ALTER O… - [ALTER ROLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/alter-role.md): Reference and syntax for the ALTER R… - [ALTER SERVICE ACCOUNT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/alter-service-account.md): Reference and syntax for the ALTER S… - [ALTER USER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/alter-user.md): Reference and syntax for the ALTER U… - [CREATE LOGIN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/create-login.md): Reference and syntax for the CREATE… - [CREATE NETWORK POLICY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/create-network-policy.md): Reference and syntax for the CREATE… - [CREATE ORGANIZATION ROLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/create-organization-role.md): Reference and syntax for the CREATE… - [CREATE ROLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/create-role.md): Reference and syntax for the CREATE… - [CREATE SERVICE ACCOUNT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/create-service-account.md): Reference and syntax for the CREATE… - [CREATE USER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/create-user.md): Reference and syntax for the CREATE… - [DROP LOGIN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/drop-login.md): Reference and syntax for the DROP LO… - [DROP NETWORK POLICY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/drop-network-policy.md): Reference and syntax for the DROP NE… - [DROP ORGANIZATION ROLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/drop-organization-role.md): Reference and syntax for the DROP OR… - [DROP ROLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/drop-role.md): Reference and syntax for the DROP RO… - [DROP SERVICE ACCOUNT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/drop-service-account.md): Reference and syntax for the DROP SE… - [DROP USER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/drop-user.md): Reference and syntax for the DROP US… - [GRANT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/grant.md): Reference and syntax for the GRANT c… - [GRANT ORGANIZATION ROLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/grant-organization-role.md): Reference and syntax for the GRANT O… - [REVOKE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/revoke.md): Reference and syntax for the REVOKE… - [REVOKE ORGANIZATION ROLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/access-control/revoke-organization-role.md): Reference and syntax for the REVOKE… - [ALTER ACCOUNT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/alter-account.md): Reference and syntax for the ALTER A… - [ALTER DATABASE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/alter-database.md): Reference and syntax for the ALTER D… - [ALTER LOCATION](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/alter-location.md): Reference and syntax for the ALTER L… - [ALTER ORGANIZATION](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/alter-organization.md): Reference and syntax for the ALTER O… - [ALTER SCHEMA](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/alter-schema.md): Reference and syntax for the ALTER S… - [ALTER TABLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/alter-table.md): Reference and syntax for the ALTER T… - [ALTER VIEW](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/alter-view.md): Reference and syntax for the ALTER V… - [COMMENT ON](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/comment-on.md): Reference and syntax for the COMMENT… - [CREATE ACCOUNT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-account.md): Reference and syntax for the CREATE… - [CREATE AGGREGATING INDEX](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-aggregating-index.md): Syntax for the CREATE AGGREGATING IN… - [CREATE DATABASE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-database.md): Reference and syntax for the CREATE… - [CREATE EXTERNAL TABLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-external-table.md): Reference and syntax for the CREATE… - [CREATE TABLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-fact-dimension-table.md): Reference and syntax for the CREATE… - [CREATE TABLE AS SELECT (CTAS)](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-fact-dimension-table-as-select.md): Reference and syntax for the CTAS SQ… - [CREATE FUNCTION](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-function.md): Reference and syntax for the CREATE… - [CREATE ICEBERG TABLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-iceberg-table.md): Reference and syntax for the CREATE… - [CREATE ICEBERG TABLE AS SELECT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-iceberg-table-as-select.md): Reference and syntax for the CREATE… - [CREATE INDEX](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-index.md): Syntax for CREATE INDEX ... USING, c… - [CREATE LOCATION](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-location.md): Reference and syntax for the CREATE… - [CREATE LOCATION (Amazon Bedrock)](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-location-bedrock.md): Reference and syntax for creating Am… - [CREATE LOCATION (DuckLake)](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-location-ducklake.md): Reference and syntax for creating Du… - [CREATE LOCATION (Iceberg)](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-location-iceberg.md): Reference and syntax for creating Ic… - [CREATE LOCATION (Amazon S3)](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-location-s3.md): Reference and syntax for creating Am… - [CREATE SCHEMA](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-schema.md): Reference and syntax for the CREATE… - [CREATE STREAM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-stream.md): Reference and syntax for the CREATE… - [CREATE TABLE CLONE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-table-clone.md): Reference and syntax for the CLONE S… - [CREATE VECTOR SEARCH INDEX](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-vector-search-index.md): Learn how to create and optimize vec… - [CREATE VIEW](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/create-view.md): Reference and syntax for the CREATE… - [DROP ACCOUNT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/drop-account.md): Reference and syntax for the DROP AC… - [DROP DATABASE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/drop-database.md): Reference and syntax for the DROP DA… - [DROP FUNCTION](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/drop-function.md): Reference and syntax for the DROP FU… - [DROP INDEX](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/drop-index.md): Reference and syntax for the DROP IN… - [DROP LOCATION](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/drop-location.md): Reference and syntax for the DROP LO… - [DROP SCHEMA](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/drop-schema.md): Reference and syntax for the DROP SC… - [DROP TABLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/drop-table.md): Reference and syntax for the DROP TA… - [DROP VIEW](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/drop-view.md): Reference and syntax for the DROP VI… - [USE DATABASE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-definition/use-database.md): Reference and syntax for the USE DAT… - [COPY FROM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-management/copy-from.md): Reference and syntax for the COPY co… - [COPY TO](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-management/copy-to.md): Reference and syntax for the COPY TO… - [DELETE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-management/delete.md): Reference and syntax for the DELETE… - [INSERT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-management/insert.md): Reference and syntax for the INSERT… - [MERGE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-management/merge.md): Reference and syntax for the MERGE c… - [TRUNCATE TABLE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-management/truncate-table.md): Reference and syntax for the TRUNCAT… - [UPDATE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-management/update.md): Reference and syntax for the UPDATE… - [VACUUM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/data-management/vacuum.md): Reference and syntax for the VACUUM… - [Engine commands](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/engines.md): Reference for engine commands - [ALTER ENGINE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/engines/alter-engine.md): Reference and syntax for the ALTER E… - [CLEAR CACHE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/engines/clear-cache.md): Reference and syntax for the CLEAR C… - [CREATE ENGINE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/engines/create-engine.md): Reference and syntax for the CREATE… - [DROP ENGINE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/engines/drop-engine.md): Reference and syntax for the DROP EN… - [START ENGINE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/engines/start-engine.md): Reference and syntax for the START E… - [STOP ENGINE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/engines/stop-engine.md): Reference and syntax for the STOP EN… - [USE ENGINE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/engines/use-engine.md): Reference and syntax for the USE ENG… - [DESCRIBE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/metadata/describe.md): Reference and syntax for the DESCRIB… - [SHOW CACHE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/metadata/show-cache.md): Reference and syntax for the SHOW CA… - [SHOW CATALOGS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/metadata/show-catalogs.md): Reference and syntax for the SHOW CA… - [SHOW COLUMNS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/metadata/show-columns.md): Reference and syntax for the SHOW CO… - [SHOW ENGINES](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/metadata/show-engines.md): Reference and syntax for the SHOW EN… - [SHOW INDEXES](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/metadata/show-indexes.md): Reference and syntax for the SHOW IN… - [SHOW TABLES](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/metadata/show-tables.md): Reference and syntax for the SHOW TA… - [SHOW VIEWS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/metadata/show-views.md): Reference and syntax for the SHOW VI… - [CANCEL QUERY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/queries/cancel.md): Cancel a running query within the Fi… - [Cross-database queries](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/queries/cross-database-queries.md): Query across multiple databases with… - [EXPLAIN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/queries/explain.md): Analyze and display query execution… - [SELECT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/commands/queries/select.md): Reference and syntax for SELECT quer… - [Data types](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/data-types.md): Provides the SQL data types availabl… - [BYTEA data type](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/data-types/bytea.md): Describes the Firebolt implementatio… - [DATE data type](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/data-types/date.md): Describes the Firebolt implementatio… - [GEOGRAPHY data type](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/data-types/geography.md): Describes the Firebolt implementatio… - [JSON Data Type](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/data-types/json.md): Describes Firebolt's implementation… - [NUMERIC data type](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/data-types/numeric.md): Describes the Firebolt implementatio… - [STRUCT data type](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/data-types/struct.md): Describes the Firebolt implementatio… - [TIMESTAMP data type](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/data-types/timestampntz.md): Describes the Firebolt implementatio… - [TIMESTAMPTZ data type](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/data-types/timestamptz.md): Describes the Firebolt implementatio… - [Explicit Transactions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/explicit-transactions.md): Reference for Explicit Transactions… - [SQL functions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference.md): Reference for SQL functions availabl… - [ANY_VALUE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/any_value.md): Reference material for ANY_VALUE - [APPROX_COUNT_DISTINCT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/approx-count-distinct.md): Reference material for APPROX_COUNT_… - [ARRAY_AGG](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/array-agg.md): Reference material for ARRAY_AGG fun… - [AVG](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/avg.md): Reference material for AVG - [BIT_AND](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/bit_and.md): Reference material for BIT_AND - [BIT_OR](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/bit_or.md): Reference material for BIT_OR - [BIT_XOR](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/bit_xor.md): Reference material for BIT_XOR - [BOOL_AND](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/bool_and.md): Reference material for BOOL_AND - [BOOL_OR](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/bool_or.md): Reference material for BOOL_OR - [CORR](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/corr.md): Reference material for CORR - [COUNT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/count.md): Reference material for COUNT - [COUNTING_HLL_COUNT_DISTINCT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/counting-hll-count-distinct.md): Reference material for COUNTING_HLL_… - [COVAR_POP](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/covar-pop.md): Reference material for COVAR_POP - [COVAR_SAMP](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/covar-samp.md): Reference material for COVAR_SAMP - [GROUPING](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/grouping.md): Reference material for GROUPING - [HASH_AGG](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/hash-agg.md): Reference material for HASH_AGG - [HLL_COUNT_BUILD](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/hll-count-build.md): Reference material for HLL_COUNT_BUI… - [HLL_COUNT_DISTINCT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/hll-count-distinct.md): Reference material for HLL_COUNT_DIS… - [HLL_COUNT_MERGE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/hll-count-merge.md): Reference material for HLL_COUNT_MER… - [MAX](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/max.md): Reference material for MAX - [MAX_BY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/max-by.md): Reference material for MAX_BY - [MEDIAN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/median.md): Reference material for MEDIAN - [MIN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/min.md): Reference material for MIN - [MIN_BY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/min-by.md): Reference material for MIN_BY - [PERCENTILE_CONT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/percentile-cont.md): Reference material for PERCENTILE_CO… - [STDDEV_POP](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/stddev-pop.md): Reference material for STDDEV_POP - [STDDEV_SAMP](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/stddev-samp.md): Reference material for STDDEV_SAMP - [SUM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/sum.md): Reference material for SUM - [VAR_POP](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/variance-pop.md): Reference material for VAR_POP - [VAR_SAMP](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/aggregation/variance-samp.md): Reference material for VAR_SAMP - [AI functions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/ai.md): Reference for AI functions - [AI_EMBED_TEXT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/ai/ai-embed-text.md): Generate a text embedding with an Am… - [AI_QUERY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/ai/ai-query.md): Invoke an LLM endpoint and return th… - [AWS_BEDROCK_AI_QUERY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/ai/aws-bedrock-ai-query.md): Invoke an Amazon Bedrock model and r… - [ARRAY_CONCAT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-concat.md): Reference material for ARRAY_CONCAT… - [ARRAY_CONTAINS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-contains.md): Reference material for ARRAY_CONTAIN… - [ARRAY_COUNT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-count.md): Reference material for ARRAY_COUNT f… - [ARRAY_COUNT_DISTINCT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-count-distinct.md): Reference material for ARRAY_COUNT_D… - [ARRAY_DISTINCT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-distinct.md): Reference material for ARRAY_DISTINC… - [ARRAY_INTERSECT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-intersect.md): Reference material for ARRAY_INTERSE… - [ARRAY_LENGTH](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-length.md): Reference material for ARRAY_LENGTH… - [ARRAY_MAX](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-max.md): Reference material for ARRAY_MAX fun… - [ARRAY_MIN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-min.md): Reference material for ARRAY_MIN fun… - [ARRAY_REVERSE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-reverse.md): Reference material for ARRAY_REVERSE… - [ARRAY_REVERSE_SORT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-reverse-sort.md): Reference material for ARRAY_REVERSE… - [ARRAY_SLICE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-slice.md): Reference material for ARRAY_SLICE f… - [ARRAY_SORT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-sort.md): Reference material for ARRAY_SORT fu… - [ARRAY_SUM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-sum.md): Reference material for ARRAY_SUM fun… - [ARRAY_TO_STRING](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-to-string.md): Reference material for ARRAY_TO_STRI… - [ARRAY_UPPER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/array-upper.md): Reference material for ARRAY_UPPER f… - [ARRAYS_OVERLAP](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/arrays-overlap.md): Reference material for ARRAYS_OVERLA… - [ARRAY_FLATTEN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/flatten.md): Reference material for ARRAY_FLATTEN… - [INDEX_OF](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/array/index-of.md): Reference material for INDEX_OF func… - [CONVERT_FROM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/bytea/convert-from.md): Reference material for CONVERT_FROM… - [DECODE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/bytea/decode.md): Reference material for DECODE functi… - [ENCODE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/bytea/encode.md): Reference material for ENCODE functi… - [CASE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/case.md): Reference material for CASE function - [CAST](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/cast.md): Reference material for CAST function - [CITY_HASH](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/city-hash.md): Reference material for CITY_HASH fun… - [COALESCE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/coalesce.md): Reference material for COALESCE func… - [GREATEST](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/greatest.md): Reference material for GREATEST func… - [HASH](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/hash.md): Reference material for HASH function - [IF](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/if.md): Reference material for IF function - [IFNULL](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/ifnull.md): Reference material for IFNULL functi… - [LEAST](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/least.md): Reference material for LEAST function - [NULLIF](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/nullif.md): Reference material for NULLIF functi… - [TRY_CAST](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/try-cast.md): Reference material for TRY_CAST func… - [TYPEOF](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/typeof.md): Reference material for TYPEOF functi… - [VERSION](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/conditional-and-miscellaneous/version.md): Reference material for VERSION funct… - [DataSketches functions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/datasketches.md): Reference for datasketches functions - [APACHE_DATASKETCHES_HLL_BUILD](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/datasketches/apache-datasketches-hll-build.md): Reference material for APACHE_DATASK… - [APACHE_DATASKETCHES_HLL_ESTIMATE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/datasketches/apache-datasketches-hll-estimate.md): Reference material for APACHE_DATASK… - [APACHE_DATASKETCHES_HLL_MERGE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/datasketches/apache-datasketches-hll-merge.md): Reference material for APACHE_DATASK… - [AGO](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/ago.md): Reference material for AGO function - [CURRENT_DATE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/current-date.md): Reference material for CURRENT_DATE… - [CURRENT_TIMESTAMP](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/current-timestamptz.md): Reference material for CURRENT_TIMES… - [DATE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/date.md): Reference material for DATE function - [DATE_ADD](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/date-add.md): Reference material for DATE_ADD func… - [DATE_DIFF](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/date-diff.md): Reference material for DATE_DIFF fun… - [DATE_TRUNC](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/date-trunc.md): Reference material for the DATE_TRUN… - [EXTRACT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/extract.md): Reference material for the EXTRACT f… - [LOCALTIMESTAMP](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/localtimestamp.md): Reference material for LOCALTIMESTAM… - [TO_CHAR](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/to-char.md): Reference material for TO_CHAR funct… - [TO_DATE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/to-date.md): Reference material for TO_DATE funct… - [TO_TIMESTAMP](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/to-timestamp.md): Reference material for TO_TIMESTAMP… - [TO_YYYYMM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/to-yyyymm.md): Reference material for the TO_YYYYMM… - [TO_YYYYMMDD](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/date-and-time/to-yyyymmdd.md): Reference material for the TO_YYYYMM… - [DuckLake functions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/ducklake/ducklake.md): Reference for DuckLake functions - [LIST_DUCKLAKE_FILES](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/ducklake/list_ducklake_files.md): Reference and syntax for the LIST_DU… - [READ_DUCKLAKE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/ducklake/read_ducklake.md): Reference and syntax for the READ_DU… - [Functions glossary](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/functions-glossary.md): Reference for SQL functions availabl… - [ST_ASBINARY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_asbinary.md): Reference material for ST_ASBINARY f… - [ST_ASEWKB](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_asewkb.md): Reference material for ST_ASEWKB fun… - [ST_ASGEOJSON](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_asgeojson.md): Reference material for ST_ASGEOJSON… - [ST_ASTEXT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_astext.md): Reference material for ST_ASTEXT fun… - [ST_CONTAINS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_contains.md): Reference material for ST_CONTAINS f… - [ST_COVERS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_covers.md): Reference material for ST_COVERS fun… - [ST_DISTANCE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_distance.md): Reference material for ST_DISTANCE f… - [ST_GEOGFROMGEOJSON](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_geogfromgeojson.md): Reference material for ST_GEOGFROMGE… - [ST_GEOGFROMTEXT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_geogfromtext.md): Reference material for ST_GEOGFROMTE… - [ST_GEOGFROMWKB](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_geogfromwkb.md): Reference material for ST_GEOGFROMWK… - [ST_GEOGPOINT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_geogpoint.md): Reference material for ST_GEOGPOINT… - [ST_INTERSECTS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_intersects.md): Reference material for ST_INTERSECTS… - [ST_S2CELLIDFROMPOINT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_s2cellidfrompoint.md): Reference material for ST_S2CELLIDFR… - [ST_X](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_x.md): Reference material for ST_X function - [ST_Y](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/geospatial/st_y.md): Reference material for ST_Y function - [Iceberg functions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/iceberg.md): Reference for Iceberg functions - [ICEBERG_BUCKET](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/iceberg/partitioning/iceberg_bucket.md): Hash value into a bucket according t… - [ICEBERG_DAY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/iceberg/partitioning/iceberg_day.md): Extract day as days from 1970-01-01… - [ICEBERG_HOUR](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/iceberg/partitioning/iceberg_hour.md): Extract hour as hours from 1970-01-0… - [ICEBERG_MONTH](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/iceberg/partitioning/iceberg_month.md): Extract month as months from 1970-01… - [ICEBERG_TRUNCATE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/iceberg/partitioning/iceberg_truncate.md): Truncate value to a width according… - [ICEBERG_YEAR](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/iceberg/partitioning/iceberg_year.md): Extract year as years from 1970 acco… - [READ_ICEBERG](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/iceberg/read_iceberg.md): Reference material for READ_ICEBERG… - [JSON functions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json.md): Reference for JSON functions - [CHECK_JSON](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/check-json.md): Reference material for CHECK_JSON fu… - [JSON_EXTRACT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/json-extract.md): Reference material for JSON_EXTRACT… - [JSON_EXTRACT_ARRAY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/json-extract-array.md): Reference material for JSON_EXTRACT_… - [JSON_FORMAT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/json-format.md): Reference for JSON_FORMAT function f… - [JSON_IS_VALID](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/json-is-valid.md): Reference material for JSON_IS_VALID… - [JSON Operators](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/json-operators.md): Reference material for JSON operators - [JSON_POINTER_EXTRACT_KEYS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/json-pointer-extract-keys.md): Reference material for JSON_POINTER_… - [JSON_POINTER_EXTRACT_TEXT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/json-pointer-extract-text.md): Reference material for JSON_POINTER_… - [JSON_POINTER_EXTRACT_VALUES](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/json-pointer-extract-values.md): Reference material for JSON_POINTER_… - [JSON_VALUE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/json-value.md): Reference material for JSON_VALUE fu… - [JSON_VALUE_ARRAY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/json-value-array.md): Reference material for JSON_VALUE_AR… - [TO_JSON](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/to-json.md): Reference material for the TO_JSON f… - [TO_JSON_STRING](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/json/to-json-string.md): Reference material for TO_JSON_STRIN… - [Lambda functions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/lambda.md): Reference for lambda functions - [ARRAY_ALL_MATCH](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/lambda/array-all-match.md): Reference material for ARRAY_ALL_MAT… - [ARRAY_ANY_MATCH](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/lambda/array-any-match.md): Reference material for ARRAY_ANY_MAT… - [ARRAY_FIRST](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/lambda/array-first.md): Reference material for ARRAY_FIRST f… - [ARRAY_FILTER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/lambda/filter.md): Reference material for ARRAY_FILTER… - [ARRAY_TRANSFORM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/lambda/transform.md): Reference material for ARRAY_TRANSFO… - [ABS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/abs.md): Reference material for ABS function - [ACOS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/acos.md): Reference material for ACOS function - [ARRAY_ENUMERATE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/array-enumerate.md): Reference material for ARRAY_ENUMERA… - [ASIN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/asin.md): Reference material for ASIN function - [ATAN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/atan.md): Reference material for ATAN function - [ATAN2](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/atan2.md): Reference material for ATAN2 function - [BIT_SHIFT_LEFT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/bit_shift_left.md): Reference material for BIT_SHIFT_LEFT - [BIT_SHIFT_RIGHT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/bit_shift_right.md): Reference material for BIT_SHIFT_RIG… - [CEIL](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/ceil.md): Reference material for CEIL, CEILING… - [COS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/cos.md): Reference material for COS function - [COT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/cot.md): Reference material for COT function - [DEGREES](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/degrees.md): Reference material for DEGREES funct… - [EXP](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/exp.md): Reference material for EXP function - [FLOOR](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/floor.md): Reference material for FLOOR function - [HLL_COUNT_ESTIMATE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/hll-count-estimate.md): Reference material for HLL_COUNT_EST… - [IS_FINITE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/is_finite.md): Reference material for the IS_FINITE… - [IS_INFINITE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/is_infinite.md): Reference material for the IS_INFINI… - [LN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/ln.md): Reference material for LN function - [LOG](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/log.md): Reference material for LOG function - [MOD](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/mod.md): Reference material for MOD function - [PARAM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/param.md): Reference material for PARAM function - [PI](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/pi.md): Reference material for PI function - [POW](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/pow.md): Reference material for POW, POWER fu… - [RADIANS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/radians.md): Reference material for RADIANS funct… - [RANDOM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/random.md): Reference material for RANDOM functi… - [ROUND](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/round.md): Reference material for ROUND function - [SIN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/sin.md): Reference material for SIN function - [SQRT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/sqrt.md): Reference material for SQRT function - [TAN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/tan.md): Reference material for TAN function - [TRUNC](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/numeric/trunc.md): Reference material for TRUNC function - [CURRENT_ACCOUNT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/session/current-account.md): Reference material for CURRENT_ACCOU… - [CURRENT_DATABASE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/session/current-database.md): Reference material for CURRENT_DATAB… - [CURRENT_ENGINE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/session/current-engine.md): Reference material for CURRENT_ENGIN… - [SESSION_USER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/session/session-user.md): Reference material for SESSION_USER… - [BTRIM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/btrim.md): Reference material for BTRIM functio… - [CONCAT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/concat.md): Reference material for CONCAT functi… - [GEN_RANDOM_UUID_TEXT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/gen-random-uuid-text.md): Reference material for GEN_RANDOM_UU… - [ICU_NORMALIZE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/icu_normalize.md): Reference material for ICU_NORMALIZE… - [ILIKE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/ilike.md): Reference material for ILIKE function - [LENGTH](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/length.md): Reference material for LENGTH functi… - [LIKE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/like.md): Reference material for LIKE function - [LOWER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/lower.md): Reference material for LOWER function - [LPAD](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/lpad.md): Reference material for LPAD function - [LTRIM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/ltrim.md): Reference material for LTRIM function - [MD5](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/md5.md): Reference material for MD5 function - [MD5_NUMBER_LOWER64](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/md5-number-lower64.md): Reference material for MD5_NUMBER_LO… - [MD5_NUMBER_UPPER64](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/md5-number-upper64.md): Reference material for MD5_NUMBER_UP… - [NGRAM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/ngram.md): Reference material for NGRAM function - [OCTET_LENGTH](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/octet_length.md): Reference material for OCTET_LENGTH… - [POSITION](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/position.md): Reference material for POSITION func… - [REGEXP_EXTRACT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/regexp-extract.md): Reference material for REGEXP_EXTRAC… - [REGEXP_EXTRACT_ALL](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/regexp-extract-all.md): Reference material for REGEXP_EXTRAC… - [REGEXP_LIKE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/regexp-like.md): Reference material for REGEXP_LIKE f… - [REGEXP_LIKE_ANY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/regexp-like-any.md): Reference material for REGEXP_LIKE_A… - [REGEXP_REPLACE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/regexp-replace.md): Reference material for REGEXP_REPLAC… - [REPLACE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/replace.md): Reference material for REPLACE funct… - [REVERSE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/reverse.md): Reference material for REVERSE funct… - [RPAD](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/rpad.md): Reference material for RPAD function - [RTRIM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/rtrim.md): Reference material for RTRIM function - [SOUNDEX](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/soundex.md): Reference material for SOUNDEX funct… - [SPLIT_PART](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/split-part.md): Reference material for SPLIT_PART fu… - [STRING_TO_ARRAY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/string-to-array.md): Reference material for STRING_TO_ARR… - [STRPOS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/strpos.md): Reference material for STRPOSR funct… - [SUBSTRING, SUBSTR](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/substring.md): Reference material for SUBSTRING fun… - [TO_BIN](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/to_bin.md): Reference material for the TO_BIN fu… - [TO_OCT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/to_oct.md): Reference material for the TO_OCT fu… - [TRIM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/trim.md): Reference material for TRIM function - [UPPER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/upper.md): Reference material for UPPER function - [URL_DECODE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/url_decode.md): Reference material for URL_DECODE fu… - [URL_ENCODE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/string/url_encode.md): Reference material for URL_ENCODE fu… - [Table-valued functions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/table-valued.md): Reference for table-valued functions - [GENERATE_SERIES](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/table-valued/generate-series.md): Reference material for GENERATE_SERI… - [LIST_OBJECTS](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/table-valued/list-objects.md): Reference material for LIST_OBJECTS… - [READ_AVRO](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/table-valued/read_avro.md): Reference material for READ_AVRO fun… - [READ_CSV](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/table-valued/read_csv.md): Reference material for READ_CSV func… - [READ_PARQUET](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/table-valued/read_parquet.md): Reference material for READ_PARQUET… - [READ_STREAM](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/table-valued/read_stream.md): Reference material for READ_STREAM f… - [READ_TEXT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/table-valued/read_text.md): Reference material for READ_TEXT fun… - [Vector functions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/vector.md): Reference for vector functions - [VECTOR_ADD](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/vector/vector-add.md): Reference material for VECTOR_ADD fu… - [VECTOR_COSINE_DISTANCE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/vector/vector-cosine-distance.md): Reference material for VECTOR_COSINE… - [VECTOR_COSINE_SIMILARITY](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/vector/vector-cosine-similarity.md): Reference material for VECTOR_COSINE… - [VECTOR_EUCLIDEAN_DISTANCE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/vector/vector-euclidean-distance.md): Reference material for VECTOR_EUCLID… - [VECTOR_INNER_PRODUCT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/vector/vector-inner-product.md): Reference material for VECTOR_INNER_… - [VECTOR_MANHATTAN_DISTANCE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/vector/vector-manhattan-distance.md): Reference material for VECTOR_MANHAT… - [VECTOR_SEARCH](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/vector/vector-search.md): Reference material for VECTOR_SEARCH… - [VECTOR_SQUARED_EUCLIDEAN_DISTANCE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/vector/vector-squared-euclidean-distance.md): Reference material for VECTOR_SQUARE… - [VECTOR_SUBTRACT](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/vector/vector-subtract.md): Reference material for VECTOR_SUBTRA… - [Window functions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window.md): Reference for window functions - [AVG OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/avg-window.md): Reference material for AVG function - [COUNT OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/count-window.md): Reference material for COUNT function - [DENSE_RANK OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/dense-rank.md): Reference material for DENSE_RANK fu… - [FIRST_VALUE](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/first-value.md): Reference material for FIRST_VALUE f… - [LAG OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/lag.md): Reference material for LAG function - [LEAD OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/lead.md): Reference material for LEAD function - [MAX OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/max-window.md): Reference material for MAX function - [MIN OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/min-window.md): Reference material for MIN function - [NTILE OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/ntile.md): Reference material for NTILE function - [PERCENT_RANK OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/percent-rank.md): Reference material for PERCENT_RANK… - [RANK OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/rank.md): Reference material for RANK function - [ROW_NUMBER OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/row-number.md): Reference material for ROW_NUMBER fu… - [SUM OVER](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/functions-reference/window/sum-window.md): Reference material for SUM function - [Information Schema](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema.md): Reference for Information Schema vie… - [Account info](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/account_info.md): Use this reference to learn about ac… - [Accounts](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/accounts.md): Use this reference to learn about th… - [Applicable roles](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/applicable-roles.md): Use this reference to learn about th… - [Catalogs](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/catalogs.md): Use this reference to learn about th… - [Columns](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/columns.md): Use this reference to learn about th… - [Enabled roles](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/enabled-roles.md): Use this reference to learn about th… - [Engine caches](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/engine-caches.md): Query the information_schema.engine_… - [Engine history](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/engine-history.md): Query the information_schema.engine_… - [Engine metering history](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/engine-metering-history.md): Query the information_schema.engine_… - [Engine metrics history](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/engine-metrics-history.md): Use this reference to learn about th… - [Engine query history](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/engine-query-history.md): Use this reference to learn about th… - [Engine running queries](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/engine-running-queries.md): Use this reference to learn about th… - [Engine user query history](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/engine-user-query-history.md): Use this reference to learn about th… - [Engines](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/engines.md): Query the information_schema.engines… - [Indexes](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/indexes.md): Use this reference to learn about th… - [Locations](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/locations.md): Use this reference to learn about th… - [Logins](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/logins.md): Use this reference to learn about th… - [Network policies](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/network_policies.md): Use this reference to learn about th… - [Object default privileges](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/object-default-privileges.md): Reference for the information_schema… - [Object privileges](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/object-privileges.md): Use this reference to learn about th… - [Organization](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/organization.md): Use this reference to learn about th… - [Quotas](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/quotas.md): Use this reference to learn about ac… - [Routines](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/routines.md): Use this reference to learn about th… - [Schemata](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/schemata.md): Use this reference to learn about th… - [Service accounts](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/service-accounts.md): Use this reference to learn about th… - [Streams](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/streams.md): Use this reference to learn about th… - [Tables](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/tables.md): Use this reference to learn about th… - [Transactions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/transactions.md): Use this reference to learn about th… - [Transitive applicable roles](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/transitive-applicable-roles.md): Use this reference to learn about th… - [Users](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/users.md): Use this reference to learn about th… - [Views](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/information-schema/views.md): Use this reference to learn about th… - [Lexical structure](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/lexical-structure.md): Describes the lexical structure of S… - [ANY/ALL (array)](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/lexical-structure/any-all-array.md): Reference for ANY(array) and ALL(arr… - [Object identifiers](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/lexical-structure/object-identifiers.md): Provides requirements and guidance f… - [Operators](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/lexical-structure/operators.md): Reference for SQL operators availabl… - [Reserved words](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/lexical-structure/reserved-words.md): Provides a list of reserved SQL wor… - [System settings](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference-sql/system-settings.md): Lists Firebolt system settings that… - [Available regions](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference/available-regions.md): Provides the AWS regions available i… - [Engine configuration reference](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference/engine-configuration.md): Reference for the YAML configuration… - [Release notes](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference/release-notes.md): Latest release notes for the Firebol… - [Release notes archive](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference/release-notes/release-notes-archive.md): Release notes archive for the Firebo… - [Support](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/reference/support.md): Describes the options of the Firebol… - [Self-Managed](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed.md): Documentation for running Firebolt c… - [Architecture](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/architecture.md): High-level architecture for Firebolt… - [FireboltEngine CRD reference](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/crd-reference/engine-crd-reference.md): Spec, phases, and conditions for the… - [FireboltEngineClass CRD reference](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/crd-reference/fireboltengineclass-crd-reference.md): Spec, status, inherited engine setti… - [FireboltInstance CRD reference](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/crd-reference/instance-crd-reference.md): Spec, status, and conditions for the… - [Auto-stop and wake-up](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/engine/auto-stop-and-wake-up.md): Operator-driven FireboltEngine auto-… - [Engine reconciliation](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/engine/engine-reconciliation.md): FireboltEngine reconcile loop, phase… - [Engine rollouts](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/engine/engine-rollouts.md): Rollout strategies and drain checks… - [Engine Scaling](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/engine/engine-scaling.md): Scale up, scale down, and stop a Fir… - [Amazon S3](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/engine/object-storage/amazon-s3.md): Configure Amazon S3 as the backing o… - [Azure Blob Storage](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/engine/object-storage/azure-blob-storage.md): Configure Azure Blob Storage as the… - [Google Cloud Storage](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/engine/object-storage/google-cloud-storage.md): Configure Google Cloud Storage as th… - [Engine overview](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/engine/overview.md): A FireboltEngine is the compute reso… - [FireboltEngineClass design](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/engineclass/fireboltengineclass-design.md): FireboltEngineClass namespacing, pod… - [FireboltEngineClass overview](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/engineclass/overview.md): Optional namespaced classes of share… - [Installation](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/installation.md): Install the Firebolt Operator and it… - [Gateway query routing](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/instance/gateway/gateway-query-routing.md): Envoy gateway routing, retry behavio… - [Gateway sizing](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/instance/gateway/gateway-sizing.md): Size Envoy gateway replicas and memo… - [Gateway overview](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/instance/gateway/overview.md): Per-instance Envoy gateway for query… - [Instance reconciliation](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/instance/instance-reconciliation.md): FireboltInstance reconciliation for… - [Metadata overview](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/instance/metadata/overview.md): Stores and services engine metadata. - [Instance overview](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/instance/overview.md): Shared infrastructure the Firebolt O… - [Monitoring](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/monitoring.md): Prometheus metrics exposed by the Fi… - [Quickstart](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/quickstart.md): Create a Firebolt instance and engin… - [Security model](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/security.md): Operator vs. platform responsibiliti… - [Troubleshooting](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/firebolt-operator/troubleshooting.md): Common Firebolt Operator failure mod… - [Monitoring](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/monitoring.md): Engine and gateway Prometheus metric… - [Operator upgrade path](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/operator-upgrade-path.md): Capabilities that warrant graduating… - [Firebolt instance Helm chart](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/overview.md): Architecture, components, and scope… - [Prerequisites](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/prerequisites.md): Kubernetes cluster, local tooling, a… - [Quickstart](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/quickstart.md): Install the firebolt-instance Helm c… - [Security model](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/security.md): Pod-hardening defaults the chart app… - [Troubleshooting](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/troubleshooting.md): Common failure modes when installing… - [External PostgreSQL](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/usage/external-postgres.md): Connecting the Metadata Service to a… - [Image overrides](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/usage/image-overrides.md): Engine and metadata image tag overri… - [Multi-engine](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/usage/multi-engine.md): Two or more named Firebolt engines u… - [Amazon S3](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/usage/object-storage/amazon-s3.md): Amazon S3 and S3-compatible object s… - [Azure Blob Storage](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/usage/object-storage/azure-blob-storage.md): Azure Blob Storage object storage fo… - [Google Cloud Storage](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/usage/object-storage/google-cloud-storage.md): Google Cloud Storage object storage… - [Single engine](https://firebolt-aggregate-helm-docs-pr-4.mintlify.app/self-managed/helm-chart/usage/single-engine.md): Default install of the firebolt-inst… ## OpenAPI Specs - [firebolt_query_v2.3](https://raw.githubusercontent.com/firebolt-db/openapi/main/specification/yaml/firebolt_query_v2.3.yaml) ## Optional - [📰 Blog](https://www.firebolt.io/knowledge-center/blog)