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 past month 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.21.0

March 2023

• New features
• Enhancements, changes, and new integrations
• Resolved issues

New features

• Data manipulation commands now available (Beta release)

  Beta support is now available for data manipulation commands UPDATE and DELETE. A VACUUM has also been added to optimize frequently updated tables.

  For more information and known limitations in the beta release, please see linked documentation.

Enhancements, changes, and new integrations

• Updates to data types

  Firebolt now uses the following built-in type names in INFORMATION_SCHEMA.COLUMNS and in auto-generated aliases for CAST operations:

  Standard type	Synonyms
  TEXT	STRING, VARCHAR
  INTEGER	INT, INT4
  BIGINT	LONG, INT8
  REAL	FLOAT, FLOAT4
  DOUBLE PRECISION	DOUBLE, FLOAT8
  NUMERIC	DECIMAL

• Parquet, Avro and ORC support added for new data types

  These file types can now be used to ingest new PGDATE, TIMSTAMPNTZ and TIMESTAMPTZ data types. For more information see data type documention.

  Starting in the next version, you will have the option to use the type names DATE and TIMESTAMP instead of new type names PGDATE and TIMESTAMPNTZ, but data must be reingested using the new types before this option is enabled. TIMESTAMPTZ will remain the same, as that is a new type added. See here for instructions to reingest. Please raise any questions or feedback with your Customer Success team.

Resolved issues

• Fixed an error Cannot parse input: expected <END OF LINE> on ingest of large CSV files.

---