# tDatabricksServerlessSQLWarehouseConnection Opens a connection to Databricks serverless SQL warehouse that can be reused by other Databricks serverless SQL warehouse components. ## tDatabricksServerlessSQLWarehouseConnection Standard properties These properties are used to configure tDatabricksServerlessSQLWarehouseConnection running in the Standard Job framework. The Standard tDatabricksServerlessSQLWarehouseConnection component belongs to the Databases family. This component provides native support for Databricks serverless SQL warehouse by using Databricks JDBC connectivity in Studio. The component in this framework is available in all Talend products. Information noteNote: This component is a specific version of a dynamic database connector. The properties related to database settings vary depending on your database type selection. For more information about dynamic database connectors, see [DB Generic components](https://help.qlik.com/talend/r/en-US/8.0/components/db-generic/db-generic-component). ## Basic settings | Properties | Description | | --- | --- | | Database | Select the desired database type from the list and click
Apply. | | Property Type | Select the way the connection details
will be set.

| | JDBC URL | The JDBC URL of the database to be used.

Information noteNote: There will be no migration operation for Databricks components when the
8.0.1-R2026-07 Talend Studio [Modules] monthly update or a later one delivered by Talend is installed. In this case, you may need to update the JDBC URL and other
related settings manually for existing Jobs to make sure the JDBC URL begins
with jdbc:databricks://. | | **Drivers** | Complete this table to load the driver JARs needed. To do
this, click the [+] button under the table to add
as many rows as needed, each row for a driver JAR, then select the cell and click the
[...] button at the right side of the cell to
open the Module dialog box from which you can select the driver JAR
to be used. For example, the driver jar RedshiftJDBC41-1.1.13.1013.jar for the Redshift database.

For more information, see [Importing a database driver](https://help.qlik.com/talend/r/en-US/8.0/components/jdbc/importing-database-driver).

Information noteNote: There will be no migration operation for Databricks components when the
8.0.1-R2026-07 Talend Studio [Modules] monthly update or a later one delivered by Talend is installed. In this case, you may need to update the JDBC URL and other
related settings manually for existing Jobs to make sure the JDBC URL begins
with jdbc:databricks://. | | **Driver Class** | Enter the class name for the specified driver between double
quotation marks. For example, for the RedshiftJDBC41-1.1.13.1013.jar driver, the name to be entered is
com.amazon.redshift.jdbc41.Driver.

Information noteNote: There will be no migration operation for Databricks components when the
8.0.1-R2026-07 Talend Studio [Modules] monthly update or a later one delivered by Talend is installed. In this case, you may need to update the JDBC URL and other
related settings manually for existing Jobs to make sure the JDBC URL begins
with jdbc:databricks://. | | User Id and Password | The database user authentication data.

To enter the password, click the [...] button
next to the password field, enter the password in double quotes in the pop-up dialog box,
and click OK to save the settings. | | Use or register a shared DB Connection | Select this checkbox to share
your database connection or fetch a database connection shared by a parent or
child Job, and in the Shared DB connection name field
displayed, enter the name for the shared database connection. This allows you
to share one single database connection (except the database schema setting)
among several database connection components from different Job levels that can
be either parent or child.

This option is
incompatible with the Use dynamic Job and Use an
independent process to run subJob options of the
tRunJob component. Using a shared connection together with a
tRunJob component with either of these two options enabled
will cause your Job to fail.

This checkbox is not available when the Specify a data source
alias checkbox is selected. | | Specify a data source alias | Select this checkbox and in the
Data source alias field displayed, specify the alias of
a data source created on Talend Runtime
side to use the shared connection pool defined in the data source configuration.
This option works only when you deploy and run your Job in Talend Runtime.

This checkbox is not available when the Use or register a shared DB
Connection checkbox is selected. | ## Advanced settings | Properties | Description | | --- | --- | | tStatCatcher Statistics | Select this checkbox to gather the Job processing metadata at the Job level
as well as at each component level. | | Use Auto-Commit | Select this checkbox to activate the auto commit mode. | | Auto Commit | Select this checkbox to commit any changes to the database automatically
upon the transaction.

With this checkbox selected, you cannot use the corresponding commit
component to commit changes to the database; likewise, when using the
corresponding commit component, this checkbox has to be cleared. By default, the
auto commit function is disabled and changes must be committed explicitly using
the corresponding commit component.

Note that the auto commit function commits each SQL statement as a
single transaction immediately after the statement is executed while the
commit component does not commit only until all of the statements are
executed. For this reason, if you need more room to manage your transactions
in a Job, it is recommended to use the commit component. | ## Global Variables | Variables | Description | | --- | --- | | ERROR\_MESSAGE | The error message generated by the component when an error
occurs. This is an After variable and it returns a string. | ## Usage | Usage guidance | Description | | --- | --- | | **Usage rule** | This component is commonly used with other Databricks serverless SQL warehouse components, especially tDatabricksServerlessSQLWarehouseInput, tDatabricksServerlessSQLWarehouseOutput, and tDatabricksServerlessSQLWarehouseRow. |