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.