> 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/august-2023.md). # August 2023 ## Weekly Software Updates The following software updates were released in August: ### 2023.08.29-15.15 #### :arrow\_up: Enhancements * Snowflake: `SELECT *` will preserve the original case of field names in variant columns. * SQL: Allow altering [`EXPOSE_IN_CATALOG`](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/3g07e3Ev48sH2HZvx7da#expose_in_catalog-editable) 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: [Support CDC from MongoDB sourc](/content/reference-1/sql-commands/jobs/create-job/ingestion/mongodb.md)e (Preview). #### :wrench: Bug Fixes * Jobs: When using `MAP_COLUMNS_BY_NAME`, the `EXCEPT` columns list was fixed to be case-insensitive *** ### 2023.08.17-13.30 #### :arrow\_up: 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. * Ingestion wizard: [Support CDC from Microsoft SQL Server source](/content/reference-1/sql-commands/jobs/create-job/ingestion/microsoft-sql-server.md) (Preview). #### :wrench: Bug Fixes * Performance improvements in CDC jobs. * Performance improvements when querying the Upsolver Query Engine. *** ### 2023.08.16-07.42 #### :arrow\_up: Enhancements * 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. #### :wrench: Bug Fixes * Major improvements when reading from a table with a large number of partitions. *** ### 2023.08.02-01.57 #### :sparkles: New Features * CDC Jobs: * (Beta) Support replicating data from [MongoDB](/content/reference-1/sql-commands/jobs/create-job/ingestion/mongodb.md). #### :arrow\_up: Enhancements * Elasticsearch Jobs: * Support deleting documents with MERGE jobs. --- # 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/august-2023.md?ask=&goal= ``` `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.