> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Databricks using Personal Access Token Authentication V2

## Intro

Databricks is a cloud-based collaborative data science, data engineering, and data analytics platform that combines the best of data warehouses and data lakes into a lakehouse architecture.

With Databricks you can access all your data, analytics, and AI on a single lakehouse platform. This simple, open, and collaborative environment helps reduce the infrastructure complexity, controls your data, and makes it easy for your teams to partner across the entire data and workflow.

You can connect to your Databricks using Personal Access Token Authentication V2 account in the Data Center. This topic discusses the fields and menus that are specific to the Databricks using Personal Access Token Authentication V2 connector user interface. To add DataSets, set update schedules, and edit DataSet information, see [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").

## Prerequisites

To connect to your Databricks using Personal Access Token Authentication V2 account and create a DataSet, you must have the following:

* Host
* Port
* Personal Access Token
* HTTP Path

## Connecting to Your Databricks using Personal Access Token Authentication V2 Account

This section enumerates the options in the **Credentials** and **Details** panes in the Databricks using Personal Access Token Authentication V2 Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in great detail in [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").

## Credentials Pane

This pane contains fields for entering credentials to connect to your Databricks using Personal Access Token Authentication V2 account. The following table describes what is needed for each field:

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p><span class="s1"> Field </span></p></th><th colspan="1" rowspan="1"><p><span class="s1"> Description </span></p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> Host </p></td><td colspan="1" rowspan="1"> Enter the server host name. </td></tr><tr><td colspan="1" rowspan="1"><p> Port </p></td><td colspan="1" rowspan="1"> Enter the server host port number. </td></tr><tr><td colspan="1" rowspan="1"><p> Personal Access Token </p></td><td colspan="1" rowspan="1"> Enter the Personal Access Token. </td></tr><tr><td colspan="1" rowspan="1"><p> HTTP Path </p></td><td colspan="1" rowspan="1"> Enter the HTTP Path. </td></tr></tbody></table>

Once you have entered valid Databricks using Personal Access Token Authentication V2 credentials, you can use the same account any time to create a new Databricks using Personal Access Token Authentication V2 DataSet. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Manage Connector Accounts](https://domo-support.domo.com/s/article/360042926054?language=en_US "Manage Connector Accounts").

## Details Pane

<table border="1" data-aura-rendered-by="33:195;a"><tbody><tr><td colspan="1" rowspan="1"><b> Menu </b></td><td colspan="1" rowspan="1"><b> Description </b></td></tr><tr><td colspan="1" rowspan="1"> How would you like to import data into Domo? </td><td colspan="1" rowspan="1"> From the drop-down, select how you want to import your data. </td></tr><tr><td colspan="1" rowspan="1"> Catalogs </td><td colspan="1" rowspan="1"> Select the catalog. </td></tr><tr><td colspan="1" rowspan="1"> Database Name </td><td colspan="1" rowspan="1"> Select the database name. </td></tr><tr><td colspan="1" rowspan="1"> Query Type </td><td colspan="1" rowspan="1"><table border="1"><tbody><tr><td colspan="1" rowspan="1"><b> Query Type </b></td><td colspan="1" rowspan="1"><b> Description </b></td></tr><tr><td colspan="1" rowspan="1"> Custom Query </td><td colspan="1" rowspan="1"> Enter the query you want to execute. </td></tr><tr><td colspan="1" rowspan="1"> Query Builder </td><td colspan="1" rowspan="1"> Select a table and fields to autogenerate your query. </td></tr></tbody></table></td></tr><tr><td colspan="1" rowspan="1"> Query </td><td colspan="1" rowspan="1"> Enter your query. </td></tr><tr><td colspan="1" rowspan="1"> Database Tables </td><td colspan="1" rowspan="1"> From the drop-down list, select the table. </td></tr><tr><td colspan="1" rowspan="1"> Table Columns </td><td colspan="1" rowspan="1"> Select the columns. </td></tr><tr><td colspan="1" rowspan="1"> Query Helper </td><td colspan="1" rowspan="1"> The generated query appears. Edit the query if required. </td></tr><tr><td colspan="1" rowspan="1"> Upsert Key Column(s) </td><td colspan="1" rowspan="1"><p> Enter the upsert key column name or a comma separated list of upsert key column names. </p><p><b> Note: </b> This is required only when Import Data method is UPSERT. </p></td></tr><tr><td colspan="1" rowspan="1"> Partition Criteria </td><td colspan="1" rowspan="1"><p> Select if you want to partition your data using the date keys or meta query. </p></td></tr><tr><td colspan="1" rowspan="1"> Partition Query to determine partition tags </td><td colspan="1" rowspan="1"><p> Enter the partition meta query to determine the distinct partition tags(or keys). The column containing the <b> Date </b> data is your partition column. For example: SELECT DISTINCT(COLUMN\_NAME) FROM TABLENAME. </p></td></tr><tr><td colspan="1" rowspan="1"> Partition Column Name </td><td colspan="1" rowspan="1"><p> Select the partition column name. Only date fields will appear. </p></td></tr><tr><td colspan="1" rowspan="1"> Partition Support Format </td><td colspan="1" rowspan="1"><p> Select the partition format. </p></td></tr><tr><td colspan="1" rowspan="1"> Past Days </td><td colspan="1" rowspan="1"><p> Enter the number of past days for which you want to get the data. Value can be X, where X is a positive integer. For example: 30. </p></td></tr><tr><td colspan="1" rowspan="1"> Past Years </td><td colspan="1" rowspan="1"><p> Enter the number of past years for which you want to get the data. Value can be X, where X is a positive integer. For example: 30. </p></td></tr><tr><td colspan="1" rowspan="1"> Past Months </td><td colspan="1" rowspan="1"><p> Enter the number of past months for which you want to get the data. Value can be X, where X is a positive integer. For example: 30. </p></td></tr><tr><td colspan="1" rowspan="1"> Future Years </td><td colspan="1" rowspan="1"><p> Enter the number of future years for which you want to get the data. Value can be X, where X is a positive integer. For example: 30. </p></td></tr><tr><td colspan="1" rowspan="1"> Future Months </td><td colspan="1" rowspan="1"><p> Enter the number of future months for which you want to get the data. Value can be X, where X is a positive integer. For example: 30. </p></td></tr><tr><td colspan="1" rowspan="1"> Date Format </td><td colspan="1" rowspan="1"><p> Select or enter the correct date format as per the date format in the partition column. By default <b> yyyy-MM-dd </b> is used. </p></td></tr><tr><td colspan="1" rowspan="1"> Custom Date Format </td><td colspan="1" rowspan="1"><p> Enter the custom date format. </p></td></tr><tr><td colspan="1" rowspan="1"> Partition Non Date Key Column Name </td><td colspan="1" rowspan="1"><p> Select the partition column name. </p></td></tr><tr><td colspan="1" rowspan="1"> Fetch Size </td><td colspan="1" rowspan="1"><p> Enter the fetch size for memory performance. The default value will be used if the fetch size is not specified. If an <b> out of memory </b> error occurs, then retry by decreasing the fetch size. </p></td></tr></tbody></table>

## Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Connector").
