# tIcebergSQL properties for Apache Spark Batch

These properties are used to configure tIcebergSQL running in the Spark Batch Job framework.

The Standard tIcebergSQL component belongs to the Big Data family.

The component in this framework is available in all Talend products.

This component is available when you have installed the 8.0.1-R2025-05 Studio Monthly or a later one provided by Talend. For more information, check with your administrator.

## Basic settings

| Properties | Description |
| --- | --- |
| Action | Select the type of operation to perform from the drop-down list:<br><br><ul> <li><span>Create namespace</span></li> <li><span>Select operation</span></li> <li><span>Insert operation</span></li> </ul> |
| Namespace name | Enter the name of the namespace to be created or to be used for Input and<br>Output operations. |
| Schema | Select the type of schema from the drop-down list:<br><br><ul> <li> <p><span>Built-In</span>: You create and store the schema                              locally for this component only.</p> </li> <li> <p><span>Repository</span>: You have already created the schema                              and stored it in the Repository. You can reuse it in various projects                              and Job designs.</p> </li> </ul><br><br>Information noteImportant: In Dataset-mode Spark Batch Jobs on Databricks, if an Iceberg table contains a Spark VariantType column, define the corresponding column in the component schema as String. The VariantType value is materialized as JSON text.<br><br>This property is only available when you select Select<br>operation from the Action drop-down<br>list. |
| Edit schema | Click Edit schema to make changes to the schema. If you<br>make changes, the schema automatically becomes built-in.<br><br>This property is only available when you select Select<br>operation from the Action drop-down<br>list. |
| Select statement | Enter the SELECT query statement. Pay attention to correctly<br>sequence the fields in order to match the target table definition.<br><br>This property is only available when you select Select<br>operation from the Action drop-down<br>list. |
| Insert statement | Enter the INSERT query statement. Pay attention to correctly<br>sequence the fields in order to match the target table definition.<br><br>This property is only available when you select Insert<br>operation from the Action drop-down<br>list. |

## Global Variables

| Variables | Description |
| --- | --- |
| ERROR\_MESSAGE | The error message generated by the component when an error<br>occurs. This is an After variable and it returns a string. |

## Usage

| Usage guidance | Description |
| --- | --- |
| Usage rule | This component is generally used with other Iceberg components. |
| Storage providers | tIcebergSQL is enabled for Databricks and works with AWS, Google<br>Cloud Platform (GCP), and Azure as providers.<br><br>The following configurations must be done on the machine<br>running the Job:<br><br><ul> <li>For AWS, set the variables <span>AWS_REGION</span>,                              <span>AWS_ACCESS_KEY_ID</span>, and                              <span>AWS_SECRET_ACCESS_KEY</span> as environment variables, or                           use the AWS CLI to set the variables on the credentials and config                           files.</li> <li>For Google Cloud Platform (GCP), set the variable                              <span>GOOGLE_APPLICATION_CREDENTIALS</span> as environment                           variable. This variable should contain the path to GCP application                           credentials JSON file.</li> </ul> |