cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Can you provide steps for connecting to Tableau?

aladda
Databricks Employee
Databricks Employee
  1.  
1 ACCEPTED SOLUTION

Accepted Solutions

aladda
Databricks Employee
Databricks Employee
  1. Download & Install the Databricks ODBC Driver
  2. Get the hostname, port, HTTP Path as described here – there’s slightly different steps for cluster (DDE) or SQL endpoint (DSQL)
  3. Get a PAT token
  4. Use the curl command to validate the network settings using the information collected in steps 2 & 3. If you get the TTransportException, that validates the connection is being established. It’s a bit counter intuitive but that tells us we’re able to reach the databricks cluster or sql endpoint (depending on what you use for the httppath) and its just that we’re not using the right app to connect
    1. If you get a Timeout or Exception we may have to look into proxy settings, etc which is better handled over a working session. Hopefully that’s not needed 
    2. Proxy information can be specified in the "Advanced" tab of the Connection dialog 'ProxyHost=host;ProxyPort=123;ProxyUID=user;ProxyPWD=pass' 
  5. Once you have the validation, Follow Step 2 – Configure Databricks connection in Tableau described here
  6. Use the server hostname, HTTP Path and “Personal Access Token” from steps 2 & 3 and connect using the Personal Access Token Authentication method as shown below, 

View solution in original post

2 REPLIES 2

User16783855117
Contributor II
Nice glad to hear it! Good call on the proxy information, will keep that knowledge in my notes 🙂

aladda
Databricks Employee
Databricks Employee
  1. Download & Install the Databricks ODBC Driver
  2. Get the hostname, port, HTTP Path as described here – there’s slightly different steps for cluster (DDE) or SQL endpoint (DSQL)
  3. Get a PAT token
  4. Use the curl command to validate the network settings using the information collected in steps 2 & 3. If you get the TTransportException, that validates the connection is being established. It’s a bit counter intuitive but that tells us we’re able to reach the databricks cluster or sql endpoint (depending on what you use for the httppath) and its just that we’re not using the right app to connect
    1. If you get a Timeout or Exception we may have to look into proxy settings, etc which is better handled over a working session. Hopefully that’s not needed 
    2. Proxy information can be specified in the "Advanced" tab of the Connection dialog 'ProxyHost=host;ProxyPort=123;ProxyUID=user;ProxyPWD=pass' 
  5. Once you have the validation, Follow Step 2 – Configure Databricks connection in Tableau described here
  6. Use the server hostname, HTTP Path and “Personal Access Token” from steps 2 & 3 and connect using the Personal Access Token Authentication method as shown below, 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group