> For the complete documentation index, see [llms.txt](https://upsolver.gitbook.io/content/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://upsolver.gitbook.io/content/release-notes/earlier-releases/2024/may-2024.md).

# May 2024

{% hint style="info" %}
**Release Notes Blog**&#x20;

For more detailed information on these updates, check out the [Upsolver June 2024 Feature Summary](https://www.upsolver.com/blog/upsolver-june-2024-feature-summary) blog.
{% endhint %}

## 2024.05.28-11.58&#x20;

⬆️ **Enhancements**&#x20;

* [Schema evolution](/content/articles-1/data/schema-evolution/redshift-schema-evolution.md) and replication support for jobs writing to [Amazon Redshift](/content/quickstarts-1/jobs/transformation/data-targets/output-to-amazon-redshift.md)

🔧 **Bug Fixes**&#x20;

* Fixed an issue where 2-minute merge files were sometimes not properly deleted when deleting Materialized Views&#x20;
* Fixed a bug where temporary files wouldn't be deleted in the index creation task when the task failed&#x20;
* Transformation jobs:&#x20;
  * Made `GROUP BY` expressions case insensitive relative to the SELECT expressions&#x20;
* Minor bug fixes

***

## 2024.05.23-08.45

⬆️ **Enhancements**&#x20;

* Upgraded the Amazon Redshift driver&#x20;

🔧 **Bug Fixes**

* Fixed CDC client sometimes becoming temporarily stuck after server replacement&#x20;
* Minor bug fixes

***

## 2024.05.19-13.23

🔧 **Bug Fixes**&#x20;

* Replication jobs:
  * Fixed snapshotting of tables sometimes being stuck in CDC process&#x20;
* Fixed a bug in jobs writing to Iceberg tables where using CAST to JSON type expressions caused double encoding of fields inside the JSON string&#x20;
* Minor bug fixes

***

## 2024.05.12-10.26

⬆️ **Enhancements**&#x20;

* Upgraded libraries to include recent security patches, enhancing system security and stability
* Non-sync jobs can now write to managed Iceberg tables&#x20;
* API: Enabled casting to JSON in jobs writing to [Amazon Redshift](/content/reference-1/sql-commands/jobs/create-job/transformation/job-options/amazon-redshift.md)&#x20;

🔧 **Bug Fixes**

* Minor bug fixes

***

## 2024.05.09-08.33 <a href="#id-2024.05.09-08.33" id="id-2024.05.09-08.33"></a>

⬆️ **Enhancements**

* Upgraded libraries to include recent security patches, enhancing system security and stability
* Information Schema:
  * Added `is_external` column to the system table [`system.information_schema.tables`](/content/reference-1/monitoring/system-catalog/information-schema/tables.md) to flag whether this is an Iceberg table that is managed by Upsolver, but is not a target for an Upsolver ingestion job

🔧 **Bug Fixes**

* Ingestion Jobs to Snowflake
  * Use the given commit interval. This change is applied only to jobs created from now on and will not apply to old jobs

***

## 2024.05.02-15.37

:arrow\_up: **Enhancements**

* Snowflake Output: If the target schema does not exist, it will now be automatically created before the table is created
* Iceberg:
  * Delete dangling files from Iceberg tables
  * Expire old snapshots in Iceberg tables
* Libraries upgrade to include security patches

:wrench: **Bug Fixes**

* Fixed an error while reading positional delete files duration Iceberg compaction tasks


---

# 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://upsolver.gitbook.io/content/release-notes/earlier-releases/2024/may-2024.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.
