> 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/2023/september-2023.md).

# September 2023

{% hint style="success" %}
**Release Notes Blog**

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

## Weekly Software Updates

The following software updates were released in September:

### 2023.09.13-12.16

#### :arrow\_up: **Enhancements**

* Support creating [query clusters](/content/reference-1/sql-commands/clusters/create-cluster.md#query-cluster) and attaching materialized views to query clusters in order to query them via HTTP API. 
* Add `IF EXISTS` syntax to `DROP` statements, e.g. `DROP TABLE IF EXISTS "my_table"`, to prevent the statement from failing if an entity does not exist. This applies to: 
  * [`DROP CLUSTER`](/content/reference-1/sql-commands/clusters/drop-cluster.md) 
  * [`DROP CONNECTION`](/content/reference-1/sql-commands/connections/drop-connection.md)
  * [`DROP TABLE`](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/Nsx7uQe8x5CPygo2kuDB)
  * [`DROP JOB`](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/N4PYR0Gwdas32aAklPYk) 
  * [`DROP MATERIALIZED VIEW`](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/3OeJWfMhRbXdXaLn5ZCC)
* Snowflake Jobs: 
  * Create the Snowflake table when there are no dynamic columns and the `CREATE_TABLE_IF_MISSING` option is **TRUE**.

***

### 2023.09.05-11.12

#### :sparkles: New Features

* Support is now available for using an external [Hive Metastore](/content/reference-1/sql-commands/connections/create-connection/hive-metastore.md) as a catalog. 
* Support added for **il-central-1** region. This region is currently only supported with private VPC deployments.

#### :arrow\_up: **Enhancements**

* PostgreSQL CDC: 
  * Tables that aren't included in the publication will not be part of the snapshot.
* Apache Kafka Jobs:
  * When copying data from Kafka topics, names are now treated as globs (stars match any number of characters, and a question mark matches one character).
* Elasticsearch Jobs: 
  * Write `timestamp` and `date` types as **ISO-8601** strings in jobs that write to Elasticsearch.

#### :wrench: **Bug Fixes**

* Fixed a bug in synchronized transformation jobs whereby a job with a smaller write interval than another job would not read the respective data.


---

# 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/2023/september-2023.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.