Release notes

Firebolt continuously releases updates so that you can benefit from the latest and most stable service. These updates might happen daily, but we aggregate release notes to cover a longer time period for easier reference. The most recent release notes from the latest version are below.

• See the Release notes archive for earlier-version release notes.

Firebolt might roll out releases in phases. New features and changes may not yet be available to all accounts on the release date shown.

DB version 3.33

April 2024

• Enhancements, changes, and new integrations
• Resolved issues

Enhancements, changes and new integrations

Removed ‘element_at’ Function

The element_at function for arrays has been removed and replaced with the [] operator.

Change of return type from BIGINT to INTEGER

The index_of/array_position function now returns INTEGER instead of BIGINT.

Removed LIMIT DISTINCT syntax

The LIMIT_DISTINCT syntax is no longer supported by Firebolt.

Resolved issues

• Fixed a bug in array_position where searching for NULL in an array with non-null elements incorrectly returned a match in some cases.

---