cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Can you provide steps for connecting to Tableau?

aladda
Honored Contributor II
Honored Contributor II
  1.  
1 ACCEPTED SOLUTION

Accepted Solutions

aladda
Honored Contributor II
Honored Contributor II
  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
Honored Contributor II
Honored Contributor II
  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, 

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.