September 2023

Upsolver new features, enhancements, and bug fixes for September 2023.

Release Notes Blog

For more detailed information on these updates, check out the Upsolver October 2023 Feature Summary blog.

Weekly Software Updates

The following software updates were released in September:

2023.09.13-12.16

⬆️ Enhancements

• Support creating query clusters 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

  • DROP CONNECTION

  • DROP TABLE

  • DROP JOB

  • DROP MATERIALIZED VIEW

• 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

✨ New Features

• Support is now available for using an external Hive Metastore as a catalog.
• Support added for il-central-1 region. This region is currently only supported with private VPC deployments.

⬆️ 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.

🔧 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.