Fine Tuning JDBC Connection for Databricks SQL¶
Optimizing JDBC connection parameters can help improve the stability and performance of your Databricks SQL Analytics integrations. This guide provides general recommendations and steps for adjusting JDBC connection settings to best suit your environment and workload requirements.
Configuration Properties¶
Feature | Description | Default Value | Possible Values |
---|---|---|---|
JDBC Socket Timeout | The number of seconds that the TCP socket waits for a response from the server before raising an error on the request. | 18000 seconds | Any positive integer (in seconds) |
Setup¶
Warning
Replace the <PLEASE_CHANGE>
placeholder with appropriate values for your environment.
To configure the JDBC socket timeout, update the following property in Privacera Manager:
-
SSH to the instance where Privacera Manager is installed.
-
Run the following command to open the
.yml
file to be edited:If you have multiple connectors, then replace
instance1
with the appropriate connector instance name.Bash -
Set the following property to configure the JDBC socket timeout:
-
Once the property is configured, run the following commands to update your Privacera Manager platform instance:
Step 1 - Setup which generates the helm charts. This step usually takes few minutes.
Step 2 - Apply the Privacera Manager helm charts. Step 3 - Post-installation step which generates Plugin tar ball, updates Route 53 DNS and so on.
-
In PrivaceraCloud portal, navigate to Settings -> Applications.
-
On the Connected Applications screen, select Databricks SQL.
-
Click the pen icon or the Account Name to modify the settings.
-
On the Edit Application screen, go to Access Management -> ADVANCED tab.
-
Under Add New Custom Properties, add the following property:
Bash -
Click SAVE to apply the changes.
- Prev topic: Advanced Configuration