> For the complete documentation index, see [llms.txt](https://docs.e6data.com/query-engine/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.e6data.com/query-engine/reference.md).

# Reference

- [Overview](https://docs.e6data.com/query-engine/reference/reference.md): Reference material for e6data - SQL functions, error codes, regions, limitations, and platform behavior.
- [Table of contents](https://docs.e6data.com/query-engine/reference/reference/summary.md)
- [SQL reference](https://docs.e6data.com/query-engine/reference/sql-reference.md): e6data supports the following categories of functions:
- [Supported Data Types](https://docs.e6data.com/query-engine/reference/sql-reference/data-types.md): This document contains the datatypes supported by e6data
- [Equivalent Functions & Operators](https://docs.e6data.com/query-engine/reference/sql-reference/function-mapping.md): Compare values and expressions for equality and similarity.
- [SQL commands](https://docs.e6data.com/query-engine/reference/sql-reference/sql-commands.md): SQL commands supported by e6data, including COPY INTO for unloading results and the supported query syntax.
- [Unload Function (Copy into)](https://docs.e6data.com/query-engine/reference/sql-reference/sql-commands/copy-into.md): Export query results to external storage efficiently.
- [Query Syntax](https://docs.e6data.com/query-engine/reference/sql-reference/sql-commands/query-syntax.md): Guidelines and structure for writing queries effectively.
- [General functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-commands/query-syntax/general-functions.md): Commonly used functions for data processing.
- [SQL functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions.md): e6data SQL functions by category - aggregate, array, date and time, JSON, mathematical, string, window, and more.
- [Aggregate Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/aggregate.md): Aggregate functions operate on multiple sets of values and return a single value.
- [Array Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/array.md): Array functions supported by e6data
- [Bitwise Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/bitwise.md): Bitwise functions supported by e6data
- [Cardinality Estimation Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/cardinality-estimation.md): pproximate the number of unique elements in a dataset.
- [Checksum Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/checksum.md): Generate and verify hash values for data integrity.
- [Comparison Operators & Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/comparison.md): This page contains the Comparison operators supported by e6data.
- [Conditional Expressions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/conditional.md): Execute logic-based operations based on specified conditions.
- [Conversion Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/conversion.md): This page contains the explicit conversion functions supported by e6data.
- [Date-Time Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/date-time.md): This document contains the date-time functions supported by e6data
- [Addition and Subtraction Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/date-time/addition-subtraction.md): Perform arithmetic operations on numerical and date values.
- [Constant Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/date-time/constants.md): Return fixed values that remain unchanged in computations.
- [Conversion Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/date-time/conversion.md): Transform data types and formats for compatibility.
- [Date Truncate Function](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/date-time/date-truncate.md): Trim date and time values to a specified precision.
- [Extraction Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/date-time/extraction.md): Retrieve specific components from dates, times, and strings.
- [Format Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/date-time/format.md): Modify the appearance of dates, numbers, and text values
- [Timezone Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/date-time/timezone.md): Convert and manipulate timestamps across different time zones.
- [Generate Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/generate.md): Create sequences, arrays, or structured data dynamically.
- [Geospatial Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/geospatial.md): SQL geospatial and H3 functions for working with location data - points, coordinates, polygons, and spatial indexes.
- [JSON Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/json.md): Parse, manipulate, and extract data from JSON structures.
- [Logical Operators](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/logical-operators.md): This page contains logical operators supported by e6data.
- [Mathematical Functions & Operators](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/mathematical.md): This page contains the Mathematical functions and operators supported by e6data.
- [Arithematic Operators](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/mathematical/arithmetic-operators.md): Perform mathematical operations in queries.
- [Exponential and Root Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/mathematical/exponential-root.md): Perform exponential calculations and extract roots of numbers.
- [Logarithmic Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/mathematical/logarithmic.md): Calculate logarithms using various bases for numerical analysis.
- [Rounding and Truncation Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/mathematical/rounding-truncation.md): Adjust numerical values by rounding or truncating.
- [Trigonometric Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/mathematical/trigonometric.md): Compute sine, cosine, tangent, and other trigonometric values.
- [Regular Expression Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/regex.md): Perform pattern matching and text manipulation using regex.
- [Statistical Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/statistical.md): Uncategorized additional functions supported by e6data
- [String Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/string.md): This document contains the string functions supported by e6data.
- [Struct Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/struct.md): Work with structured data by creating and manipulating nested fields.
- [Window Functions](https://docs.e6data.com/query-engine/reference/sql-reference/sql-functions/window.md): This page contains window functions supported by e6data.
- [Error codes](https://docs.e6data.com/query-engine/reference/error-codes.md): Error codes returned by e6data, organized by component. Each page lists codes, meanings, and fixes.
- [Catalog Errors](https://docs.e6data.com/query-engine/reference/error-codes/catalog.md): Address issues encountered while managing catalogs and metadata.
- [Cluster Errors](https://docs.e6data.com/query-engine/reference/error-codes/cluster.md): Troubleshoot failures and performance issues in cluster operations.
- [Connectivity Errors](https://docs.e6data.com/query-engine/reference/error-codes/connectivity.md): Troubleshoot network and connection-related issues.
- [Data Governance Errors](https://docs.e6data.com/query-engine/reference/error-codes/data-governance.md): Resolve issues related to access control, policies, and compliance.
- [General Errors](https://docs.e6data.com/query-engine/reference/error-codes/general.md): Identify and resolve common system and user-related issues.
- [Query Editor Errors](https://docs.e6data.com/query-engine/reference/error-codes/query-editor.md): Troubleshoot issues related to query execution and interface functionality.
- [Query History Errors](https://docs.e6data.com/query-engine/reference/error-codes/query-history.md): Address issues with logging, tracking, and retrieving query history.
- [REST API errors](https://docs.e6data.com/query-engine/reference/error-codes/rest-api.md): Error codes returned by the e6data REST API, what they mean, and how to fix them.
- [User Account Errors](https://docs.e6data.com/query-engine/reference/error-codes/user-account.md): Troubleshoot authentication, access, and profile-related issues.
- [Workspace Errors](https://docs.e6data.com/query-engine/reference/error-codes/workspace.md): Diagnose and resolve issues related to workspace setup and usage.
- [Known Limitations](https://docs.e6data.com/query-engine/reference/limitations.md): Identify current constraints and restrictions in the system.
- [Cloud provider](https://docs.e6data.com/query-engine/reference/limitations/cloud-provider.md): Cloud-provider-specific limits and constraints when running e6data.
- [Restart Triggers](https://docs.e6data.com/query-engine/reference/limitations/restart-triggers.md): Manage and configure conditions for automatic process restarts.
- [SQL Limitations](https://docs.e6data.com/query-engine/reference/limitations/sql.md): Understand constraints and unsupported features in SQL execution.
- [Other Limitations](https://docs.e6data.com/query-engine/reference/limitations/other.md): Recognize additional constraints affecting functionality and performance.
- [Services and dependencies](https://docs.e6data.com/query-engine/reference/services-and-dependencies.md): Supported cloud regions and external dependencies for e6data deployments.
- [AWS supported regions](https://docs.e6data.com/query-engine/reference/services-and-dependencies/aws-regions.md): This page lists the AWS regions where e6data can be deployed, ensuring optimal performance and compliance with regional requirements.
- [Azure regions](https://docs.e6data.com/query-engine/reference/services-and-dependencies/azure-regions.md): Azure regions supported for e6data Serverless and In Your VPC deployments.
- [Connectivity reference](https://docs.e6data.com/query-engine/reference/connectivity-reference.md)
- [JDBC parameters](https://docs.e6data.com/query-engine/reference/connectivity-reference/jdbc-parameters.md): Reference for the e6data JDBC connection URL and its parameters.
- [PostgreSQL protocol parameters](https://docs.e6data.com/query-engine/reference/connectivity-reference/postgresql-protocol-parameters.md): Reference for connecting to e6data over the PostgreSQL wire protocol - host, port, database encoding, and SSL.
- [REST v2 endpoints](https://docs.e6data.com/query-engine/reference/connectivity-reference/rest-v2-endpoints.md): Reference for the e6data HTTP REST v2 SQL endpoints, headers, and statement states.
- [Python connector reference](https://docs.e6data.com/query-engine/reference/connectivity-reference/python-connector-reference.md): Reference for the e6data Python connector - installation, connection parameters, and the cursor API.
- [Platform reference](https://docs.e6data.com/query-engine/reference/platform-reference.md)
- [Version upgrades](https://docs.e6data.com/query-engine/reference/platform-reference/version-upgrades.md): How to upgrade Platform Components and the Metadata Service for your workspace, and what to expect.
- [Release notes format](https://docs.e6data.com/query-engine/reference/platform-reference/release-notes-format.md): What each section of an e6data release note covers, so you can scan releases efficiently.
- [Permissions matrix](https://docs.e6data.com/query-engine/reference/platform-reference/permissions-matrix.md): The complete set of Control Plane named permissions, grouped by resource family, as a lookup table.
- [Resource naming conventions](https://docs.e6data.com/query-engine/reference/platform-reference/resource-naming-conventions.md): Naming rules for e6data workspaces, clusters, and catalogs - allowed characters, length limits, and how names are normalized.
- [Token reference](https://docs.e6data.com/query-engine/reference/token-reference.md)
- [Personal access token](https://docs.e6data.com/query-engine/reference/token-reference/personal-access-token.md): The structure of an e6data personal access token (PAT) and how it's stored.
- [Service account key format](https://docs.e6data.com/query-engine/reference/token-reference/service-account-key-format.md): The structure of an e6data service account API key and how it's stored.
- [Token lifecycle states](https://docs.e6data.com/query-engine/reference/token-reference/token-lifecycle-states.md): The states an e6data access token moves through - active, expired, and revoked - and how each is enforced.
- [Token expiry rules](https://docs.e6data.com/query-engine/reference/token-reference/token-expiry-rules.md): How access-token expiry works in e6data - units, defaults, maximums, and enforcement.
- [Cluster reference](https://docs.e6data.com/query-engine/reference/cluster-reference.md)
- [Cluster states](https://docs.e6data.com/query-engine/reference/cluster-reference/cluster-states.md): The lifecycle states an e6data cluster can be in, and what each means.
- [Scaling modes](https://docs.e6data.com/query-engine/reference/cluster-reference/scaling-modes.md): The cluster scaling modes in e6data - fixed, autoscaling, QPS-based, and scale-to-zero - at a glance.
- [Upgrade states](https://docs.e6data.com/query-engine/reference/cluster-reference/upgrade-states.md): The states a cluster or platform upgrade moves through, and the cluster upgrade deployment phases.
- [Configuration reference](https://docs.e6data.com/query-engine/reference/configuration-reference.md)
- [AWS configuration](https://docs.e6data.com/query-engine/reference/configuration-reference/aws-configuration.md): Reference for the AWS resources and configuration values used in an In-VPC e6data deployment on EKS.
- [Azure configuration](https://docs.e6data.com/query-engine/reference/configuration-reference/azure-configuration.md): Reference for the Azure resources and configuration values used in an In-VPC e6data deployment on AKS.
- [Kubernetes configuration](https://docs.e6data.com/query-engine/reference/configuration-reference/kubernetes-configuration.md): Reference for the Kubernetes resources an In-VPC e6data deployment installs - CRDs, storage class, node provisioning, and namespaces.
- [Helm values](https://docs.e6data.com/query-engine/reference/configuration-reference/helm-values.md): Reference for the key Helm values used to deploy the e6data operator and workspace components In Your VPC.
- [Environment variables](https://docs.e6data.com/query-engine/reference/configuration-reference/environment-variables.md): Environment variables used in an e6data In-VPC deployment and by client connectors.
- [Limits and quotas](https://docs.e6data.com/query-engine/reference/limits-and-quotas.md)
- [Workspace limits](https://docs.e6data.com/query-engine/reference/limits-and-quotas/workspace-limits.md): Naming rules and limits for workspaces, service accounts, and tokens in e6data.
- [Cluster limits](https://docs.e6data.com/query-engine/reference/limits-and-quotas/cluster-limits.md): Naming rules, sizing bounds, and scaling/suspension limits for e6data clusters.
- [Query limits](https://docs.e6data.com/query-engine/reference/limits-and-quotas/query-limits.md): Query timeout, result-display, and session limits for queries in e6data.
- [API limits](https://docs.e6data.com/query-engine/reference/limits-and-quotas/api-limits.md): Behaviors that shape API usage in e6data - pagination, result chunking, async polling, idempotency, and eventual consistency.
- [Token limits](https://docs.e6data.com/query-engine/reference/limits-and-quotas/token-limits.md): Limits and recommended practices for e6data access tokens - expiry bounds and per-consumer scoping.
- [Glossary](https://docs.e6data.com/query-engine/reference/glossary.md): Definitions of the core e6data terms used throughout the documentation and Console.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.e6data.com/query-engine/reference.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.