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