# Databricks

## Establishing a Connection <a href="#default" id="default"></a>

### Authenticating Using Personal Access Token <a href="#authenticating-using-personal-access-token" id="authenticating-using-personal-access-token"></a>

To authenticate, set the following:

* AuthScheme: Set this to **PersonalAccessToken**.
* Token: The token used to access the Databricks server. It can be obtained by navigating to the **User Settings** page of your Databricks instance and selecting the **Access Tokens** tab.

### Authenticating to Azure Active Directory <a href="#authenticating-to-azure-active-directory" id="authenticating-to-azure-active-directory"></a>

To authenticate to Databricks using Azure Service Principal:

* AuthScheme: Set this to **AzureServicePrincipal**.
* AzureTenantId: Set this to the tenant ID of your Microsoft Azure Active Directory.
* AzureClientId: Set to the application (client) ID of your Microsoft Azure Active Directory application.
* AzureClientSecret: Set to the application (client) secret of your Microsoft Azure Active Directory application.
* AzureSubscriptionId: Set this to the Subscription id of your Microsoft Azure Databricks Service Workspace.
* AzureResourceGroup: Set this to the Resource Group name of your Microsoft Azure Databricks Service Workspace.
* AzureWorkspace: Set this to the name of your Microsoft Azure Databricks Service Workspace.

### Connecting to Databricks <a href="#connecting-to-databricks" id="connecting-to-databricks"></a>

To connect to a Databricks cluster, set the properties as described below.

**Note**: The needed values can be found in your Databricks instance by navigating to **Clusters**, and selecting the desired cluster, and selecting the **JDBC/ODBC** tab under **Advanced Options**.

* Database: Set to the name of the Databricks database.
* Server: Set to the **Server Hostname** of your Databricks cluster.
* HTTPPath: Set to the HTTP Path of your Databricks cluster.
* Token: Set to your personal access token (this value can be obtained by navigating to the **User Settings** page of your Databricks instance and selecting the **Access Tokens** tab).

### Cloud Storage Configuration <a href="#cloud-storage-configuration" id="cloud-storage-configuration"></a>

The provider supports DBFS, Azure Blob Storage, and AWS S3 for uploading CSV files.

#### DBFS Cloud Storage <a href="#dbfs-cloud-storage" id="dbfs-cloud-storage"></a>

To use DBFS for cloud storage, set the following:

* CloudStorageType: Set this to **DBFS**.
* StoreTableInCloud: Set this to **True** to store tables in cloud storage when creating a new table.

#### Authenticating to Azure Blob Storage <a href="#authenticating-to-azure-blob-storage" id="authenticating-to-azure-blob-storage"></a>

Set the following to use Azure Blob Storage for cloud storage:

* CloudStorageType: Set this to **Azure Blob storage**.
* StoreTableInCloud: Set this to **True** to store tables in cloud storage when creating a new table.
* AzureStorageAccount: Set this to the name of your Azure storage account.
* AzureAccessKey: Set to the storage key associated with your Databricks account. Find this via the azure portal (using the root acoount). Select your storage account and click **Access Keys** to find this value.
* AzureBlobContainer: Set to the name of you Azure Blob storage container.

#### Authenticating to AWS S3 <a href="#authenticating-to-aws-s3" id="authenticating-to-aws-s3"></a>

Set the following to use AWS S3 for cloud storage:

* CloudStorageType: Set this to **AWS S3**.
* StoreTableInCloud: Set this to **True** to store tables in cloud storage when creating a new table.
* AWSAccessKey: The AWS account access key. This value is accessible from your AWS security credentials page.
* AWSSecretKey: Your AWS account secret key. This value is accessible from your AWS security credentials page.
* AWSS3Bucket: Set to the name of your AWS S3 bucket.
* AWSRegion: The hosting region for your Amazon Web Services. The AWS Region value can be obtained by navigating to the Buckets List page of your Amazon S3 service, such as: us-east-1.