Skip to content

README.md

Latest commit

 

History

History
54 lines (40 loc) · 1.51 KB

README.md

File metadata and controls

54 lines (40 loc) · 1.51 KB

Databricks app with OLTP database

This example demonstrates how to define a Databricks app backed by an OLTP Postgres in a bundle.

It includes and deploys an example application that uses Python and Dash and a database instance. When application is started it provisions its own schema and demonstration data in the OLTP database.

For more information about Databricks Apps see the documentation. For more information about Databricks database instances see the documentation.

Prerequisites

  • Databricks CLI v0.267.0 or above

Usage

  1. Deploy the bundle:
databricks bundle deploy -t dev

Please note that after this bundle gets deployed, the database instance starts running immediately, which incurs cost.

  1. Run the app:
databricks bundle run my_app
  1. Open the app: Run the following command to navigate to the deployed app in your browser:
databricks bundle open my_app

Alternatively, run databricks bundle summary to display its URL.

  1. Query the app data:

Run the following command to display the data generated by the app:

databricks psql example-database-instance -- --dbname example_database -c "select * from holidays.holiday_requests"
  1. Explore the app data: Run the following command to navigate to the Unity Catalog in your browser:
databricks bundle open my_catalog

Clean up

To remove the provisioned resources run

databricks bundle destroy