# New features

## Shared features

| Feature | Description |
| --- | --- |
| Change of the default background color for subJobs and Joblets in the<br>canvas | SubJobs and Joblets are now hightlighted in a blue square by default. You<br>can change or remove the background color of a subJob or Joblet as needed.<br>![SubJob in the design workspace.](https://help.qlik.com/talend/en-US/release-notes/Resources/images/Highlight_job.png) |
| New Select and Move modes for canvas navigation | Talend Studio<br>now provides Select and Move modes for the graphical editor of Job, Joblet, Route,<br>and Routelet. For more information, see [Navigating the canvas](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/navigating-the-canvas). |
| Support for more components for Job lineage | Talend Studio<br>can now generate datasets and lineage for more components to Qlik Cloud. |

## Application integration

| Feature | Description |
| --- | --- |
| Support for Prometheus endpoint activation through Microservice<br>configuration | You can now use the<br>management.endpoint.prometheus.enabled=true/false parameter in<br>an additional properties file to activate or deactivate the Prometheus endpoint<br>for a Microservice. For more information, see [Running a Microservice](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/running-a-microservice). |
| Support for Batch Consumer and partitioning in cKafkaCommit<br>component | cKafkaCommit now supports Batch Consumer and use of partitions. |
| Display the folder structure of API definitions in API import<br>wizard | When importing an API definition from Talend Cloud API Designer, the API import wizard now reflects the folder structure of Talend Cloud API Designer. For more information, see [Creating a new REST API metadata from API<br>Designer](https://help.qlik.com/talend/en-US/studio-user-guide/8.0/creating-new-rest-api-metadata-from-api-designer).<br>![Import API definition dialog box with Import from API designer option selected.](https://help.qlik.com/talend/en-US/release-notes/Resources/images/api_import_from_designer.png) |

## Big Data

| Feature | Description |
| --- | --- |
| Support for CDP Private Cloud Base 7.1.7 with Spark Universal 3.3.x | Talend Studio<br>now supports CDP Private Cloud Base 7.1.7 (Spark 3.2) SP1 with JDK 11 with Spark<br>Universal 3.3.x in Spark Batch and Standard Jobs. |
| Availability-note[Beta](https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-beta)<br><br>Beta content<br><br>New tIcebergSQL component in Spark Batch Jobs | The new tIcebergSQL component is now available in Beta version in Spark Batch<br>Jobs allowing you to execute SQL queries for Polaris and Snowflake Open Catalog<br>managed Iceberg tables.<br><br>![tIcebergSQL Basics settings view in a Spark Batch Job.](https://help.qlik.com/talend/en-US/release-notes/Resources/images/ticebergsql-rn.png) |
| Support for Hive 3 in Impala components | Talend Studio<br>now supports Hive 3 in Impala components in Standard Jobs. |

## Data Integration

| Feature | Description |
| --- | --- |
| New tQVDOutput component in Standard Jobs | The new tQVDOutput component is now available in Standard Jobs, and allows<br>you to create QVD files. |
| New partition options in tKafkaInput in Standard Jobs | The Use offset partition option has been added to<br>tKafkaInput, allowing you to specify the partition to read from, and define the<br>starting offset for message retrieval. |

## Data Mapper

| Feature | Description |
| --- | --- |
| Support for EXISTS operator in DSQL maps | The EXISTS operator is now available in DSQL maps allowing<br>you to check if an argument is not empty nor null. The argument can be an array, a<br>record, a primitive, a choice or a map. |
| Support for arithmetic operation between string operands representing<br>numbers | Arithmetic operations like '2' + '1' are now calculated and<br>supported as numeric string operands. |
| Support for complex parameterized expressions in DSQL maps | Talend Studio<br>now supports complex parameterized expressions in DSQL map editor. You can now use<br>a block in a parameterized expression:<br>![Example of a parameterized expression using a block.](https://help.qlik.com/talend/en-US/release-notes/Resources/images/parameterized-expression-block.png)<br><br>And you can also use a query in a parameterized expression:<br>![Example of a parameterized expression using a query.](https://help.qlik.com/talend/en-US/release-notes/Resources/images/parameterized-expression-query.png) |
| New options to copy and paste expressions in DSQL maps | You now have the possibility to copy and paste expressions when you<br>right-click an output element in the DSQL map editor.<br>![New options when right-clicking an output element.](https://help.qlik.com/talend/en-US/release-notes/Resources/images/dsql-map-copy-paste-expressions.png) |
| Support for custom start index value in queries in DSQL maps | You can now use a custom start index value in your queries in DSQL maps by<br>defining an expression after the INDEX keyword. For example, you<br>can define your index to start at<br>1:<br><br>```<br>FROM customer INDEX $i 1<br>```<br><br>By default and if it is not<br>specified, the start index value is 0. |
| Support for the NOT operator in front of conditional<br>expressions in DSQL maps | The NOT and ! operators can now be<br>followed by a conditional expression:<br><br>```<br>FROM item<br>SELECT {<br>da = !(IF (hasValue(note)) true ELSE false),<br>}<br>``` |

## Data Quality

| Feature | Description |
| --- | --- |
| Availability-note[Beta](https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-beta)<br><br>Beta content<br><br>Support for new authentication methods for Snowflake<br>connection | When connecting to Snowflake as a database connection on the repository, you<br>can now use the key-pair and OAuth 2.0 authentication methods. |