This page describes how to configure Databricks credentials for use by Census and why those permissions are needed.

Configuring a new Databricks connection

1. Visit the Connections section on Census, and press Add Data Warehouse Connection, selecting Databricks from the list.
2. Enter the hostname, port, and HTTP Path for your cluster. These can be found in the Databricks UI under Clusters โ†’ [Your Cluster] โ†’ Advanced Options โ†’ JDBC/ODBC. The Databricks documentation covers this in more detail.
3. Enter your Databricks Access Token. A token can be generated in the ๐Ÿ‘คโ†’ User Settings page in the Databricks UI.
4. Add the following configuration parameters to your cluster. This can be done under Clusters โ†’ [Your Cluster] โ†’ Advanced Options โ†’ Spark.
spark.hadoop.fs.s3n.impl.disable.cache true
spark.hadoop.fs.s3.impl.disable.cache true
spark.hadoop.fs.s3a.impl.disable.cache true
5. After the connection is saved, go ahead and press the Test button. This will validate that you've completed the above steps correctly. Once you've got a checkmark for all four steps, you're good to go!

๐Ÿš‘ Need help connecting to Databricks?

โ€‹Contact us via [email protected] or start a conversation with us via the in-app chat.