Connect Databricks to your Data App with Plotly Studio
Meet the Speaker
Adam Schroeder
Adam Schroeder is a Community Manager at Plotly.
This video continues the series on connecting data sources to dashboards using Plotly Studio and focuses on working with Databricks. The walkthrough starts in Plotly Studio and shows how to connect to a Databricks SQL warehouse instead of a flat file like a CSV or Parquet file. The presenter explains the required credentials, including the server host name, HTTP path, and a personal access token, all retrieved from the Databricks console under the SQL warehouse and access token settings.
Once the credentials are saved, Plotly Studio connects successfully and displays available schemas and datasets. The demo uses a sample New York City taxi trips dataset stored in Databricks. Plotly Studio uses the configured credentials to connect directly to that dataset and loads a preview showing columns like trip distance and trip metadata.
With the data connected, the video moves into chart creation using Explore mode. Plotly Studio suggests possible visualizations, such as trip count over time. Adamr reviews the generated prompt, confirms the chart setup, and creates a line chart showing taxi trip volume by hour of day. While the app builds, Plotly Studio automatically generates a dashboard title, description, summary cards, a data table, and the chart.
The video closes by showing how additional charts can be added with natural language prompts and how the finished dashboard can be published to Plotly Cloud and shared publicly.
Key points covered
- Connecting securely to Databricks using SQL warehouses and tokens
- Previewing and selecting datasets directly inside Plotly Studio
- Building dashboards with English prompts and publishing them online
Watch the video to follow along and see the full Databricks workflow in action.
