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

# June 2023

## Weekly Software Updates

The following software updates were released in June:

### 2023.06.26-03.44

#### :sparkles: New Features

* User information and organization name are now displayed on the main pages with the ability to switch between organizations

#### :arrow\_up: Enhancements

* \[BREAKING CHANGE] Changed `$row_number` system field from 0-based to 1-based 
* Added `$row_number` system column to transformation jobs 
* Added `$item_index` system column, representing the source batch's row index. For example, in S3 sources, it will be the row index in a file 
* Amazon S3 outputs now support the inclusion of the shard number in the target path. This allows the use of output shards without overwriting the output files 

#### :wrench: Bug Fixes 

* Fixed a bug in the [`IS_DUPLICATE`](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/GbSiayXdbeCeiHNAGfSF) function that caused the wrong results when the job is running with an interval higher than 1 minute 
* Fixed a bug reading Avro and Parquet files that caused fields of type `Date` to be ignored 

***

### 2023.06.19-10.37

#### :sparkles: New Features

* Snowflake table statistics are now available

#### :wrench: Bug Fixes 

* Fixed an issue reading from empty Kafka topics that contain empty partitions 
* Fixed a bug reading Avro files that use a named type more than once 

***

### 2023.06.12-08.57

#### :sparkles: New Features

* Ingestion wizard - easy ingest to Snowflake, including: 
  * Support [Amazon S3](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/source-set-up/amazon-s3.md) as a source
  * Support CDC from [PostgreSQL](/content/quickstarts-1/data-ingestion-wizard/using-the-wizard/source-set-up/postgresql.md) as a source 
* [Manage Data Quality - Ingest data with expectations](/content/how-to-guides-1/jobs/advanced-use-cases/managing-data-quality-ingesting-data-with-expectations.md) 

#### :arrow\_up: Enhancements

* [Job monitoring](/content/reference-1/monitoring/system-catalog/monitoring.md) improvements

#### :wrench: Bug Fixes  

* Snowflake Merge Jobs: enforce the `ON` clause expression to prevent creating an array

***

### 2023.06.05-11.39

#### :arrow\_up: Enhancements

* PostgreSQL jobs:
  * With partitioned tables, expose `data.full_partition_table_name` field specifying the name of the event's original partition 
* [Job status](broken://spaces/WKMq8oT1OPM3KjP8vlg2/pages/jEzA8OoJhnxS7qfIgVF0) page improvements


---

# 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/june-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.