Databricks
Connect Graphext to Databricks and be able to bring your data and write back to your data warehouse recurrently
Connect Graphext to Databricks
Guided steps
Connect to Databricks
Connect to Databricks
1
Create a project
Click on “New Project” (this will add the integration to your personal team) or the “Integrations” button inside the team you want to work on.
2
Select Databricks from the integrations list.
3
Head to the Databricks webpage
Go to SQL Warehouses, select the one you want to work with, and click on the connection details section
4
Get the server hostname
Copy the Server hostname, and paste it into the field labeled Host.
5
Find the HTTP path
Copy the HTTP path, and paste it into the corresponding field.
6
Head to the Databricks settings
Head to your Databricks User Settings, select the Access Tokens tab,and copy your token or generate a new one. Paste it into the appropriate field.
7
Create your SQL query
Using the Databricks SQL editor or your favorite editor, and paste it in the field labeled Query.
8
Allow write output to export data
If you want Graphext to write back the project’s output to Databricks. Select “Allow write output.” View more documentation about this step in our API Docs.
9
Save
Click on “Save and create project” to retrieve your data and begin exploring or “Save” the integration for later use.