Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-04-2021 01:35 PM
1 ACCEPTED SOLUTION
Accepted Solutions
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-19-2021 08:24 PM
- Download & Install the Databricks ODBC Driver
- Get the hostname, port, HTTP Path as described here – there’s slightly different steps for cluster (DDE) or SQL endpoint (DSQL)
- Get a PAT token
- 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
- 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
- Proxy information can be specified in the "Advanced" tab of the Connection dialog 'ProxyHost=host;ProxyPort=123;ProxyUID=user;ProxyPWD=pass'
- Once you have the validation, Follow Step 2 – Configure Databricks connection in Tableau described here
- 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,
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2021 08:03 AM
Nice glad to hear it! Good call on the proxy information, will keep that knowledge in my notes 🙂
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-19-2021 08:24 PM
- Download & Install the Databricks ODBC Driver
- Get the hostname, port, HTTP Path as described here – there’s slightly different steps for cluster (DDE) or SQL endpoint (DSQL)
- Get a PAT token
- 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
- 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
- Proxy information can be specified in the "Advanced" tab of the Connection dialog 'ProxyHost=host;ProxyPort=123;ProxyUID=user;ProxyPWD=pass'
- Once you have the validation, Follow Step 2 – Configure Databricks connection in Tableau described here
- 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,