LogoLogo
OverviewQuickstartsHow To GuidesReferenceArticlesSupport
Overview
Overview
  • Welcome to Upsolver
  • GET STARTED
    • What is Upsolver?
    • Schedule a Demo
    • Start Your Free Trial
    • Apache Iceberg
  • RESOURCES
    • Reference
    • Iceberg Academy
    • Blog
    • Chill Data Summit
    • Community
    • Videos
  • RELEASE NOTES
    • March 2025
    • February 2025
    • January 2025
    • Earlier Releases
      • 2024
        • December 2024
        • November 2024
        • October 2024
        • September 2024
        • August 2024
        • July 2024
        • June 2024
        • May 2024
        • April 2024
        • March 2024
        • February 2024
        • January 2024
      • 2023
        • December 2023
        • November 2023
          • Deprecated Job Option
        • October 2023
        • September 2023
        • August 2023
        • July 2023
        • June 2023
        • May 2023
  • Legal
Powered by GitBook
On this page
  • Weekly Software Updates
  • 2023.08.29-15.15
  • 2023.08.17-13.30
  • 2023.08.16-07.42
  • 2023.08.02-01.57
  1. RELEASE NOTES
  2. Earlier Releases
  3. 2023

August 2023

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

Last updated 1 year ago

Weekly Software Updates

The following software updates were released in August:

2023.08.29-15.15

Enhancements

  • Snowflake: SELECT * will preserve the original case of field names in variant columns.

  • SQL: Allow altering property in tables.

  • Performance Improvement: Reduce the number of file operations when coordinating future table operations.

  • Write Timestamp and Date types as ISO-8601 strings in jobs that write to Elasticsearch.

  • Ingestion wizard: e (Preview).

Bug Fixes

  • Jobs: When using MAP_COLUMNS_BY_NAME, the EXCEPT columns list was fixed to be case-insensitive


2023.08.17-13.30

Enhancements

  • Write Timestamp and Date types as ISO-8601 strings in string output jobs, for example: Job to Elasticsearch, Job to Amazon S3 with format JSON/CSV.

  • Write Timestamp and Date types as ISO-8601 in RECORD_TO_JSON function.

  • Performance improvements in CDC jobs.

  • Performance improvements when querying the Upsolver Query Engine.


2023.08.16-07.42

  • Users can now omit the connection type when specifying a source or target in jobs (e.g. INSERT INTO S3 catalog LOCATION = '...' can be replaced in INSERT INTO catalog LOCATION = '...').

  • Improved the performance of CDC jobs reading from databases with a large number of tables.

  • Querying the information schema tables now returns Jobs and Materialized Views in deleting state.

  • Elasticsearch Jobs:

    • MERGE jobs now support deleting documents by using the WHEN MATCHED AND ... THEN DELETE syntax.

  • Upgraded Avro and Parquet libraries to the latest versions.

  • Major improvements when reading from a table with a large number of partitions.


2023.08.02-01.57

  • CDC Jobs:

  • Elasticsearch Jobs:

    • Support deleting documents with MERGE jobs.

Ingestion wizard: (Preview).

Bug Fixes

Enhancements

Bug Fixes

New Features

(Beta) Support replicating data from .

Enhancements

🔧
⬆️
🔧
✨
⬆️
⬆️
🔧
⬆️
Support CDC from Microsoft SQL Server source
MongoDB
Support CDC from MongoDB sourc
EXPOSE_IN_CATALOG