DatabricksNew
Setting up the connection
Before connecting Databricks to Causal you might have to white list the following IP addresses in your Databricks database:
- 146.148.57.218
- 35.184.187.183
- 35.224.101.145
Go to the Causal data page and create a new Databricks data source
Click "+ New Connection" and fill in the database credentials
Once the connection’s created you’ll see the source configuration form:
To configure your Databricks data source you will need to specify the query, the date column, and any variable columns. The date column should be one of Databricks' date formats and the variable columns should be numeric.
Any columns that aren't a date or variable column will be considered a category, and should have a string type. An exception is the 'cohort' category, which should be a date, with the column header explicitly labelled Cohort.
For more details about how to write queries for Causal data sources check out Table Format.