Data Warehousing With Identity, Primary Key and Foreign Key

Demo Type

Product Tutorial




What you’ll learn

To simplify SQL operations and support migrations from on-prem and alternative warehouses, Databricks Lakehouse now provides convenient ways to build Entity Relationship Diagrams that are simple to maintain and evolve. In this demo, we'll cover:

  • The ability to automatically generate auto-incrementing identify columns. Just insert data and the engine will automatically increment the ID.
  • Support for defining primary key
  • Support for defining foreign key constraints

Databricks Lakehouse is the best data warehouse.


To install the demo, get a free Databricks workspace and execute the following two commands in a Python notebook

%pip install dbdemos
import dbdemos

Dbdemos is a Python library that installs complete Databricks demos in your workspaces. Dbdemos will load and start notebooks, Delta Live Tables pipelines, clusters, Databricks SQL dashboards, warehouse models … See how to use dbdemos


Dbdemos is distributed as a GitHub project.

For more details, please view the GitHub file and follow the documentation.
Dbdemos is provided as is. See the 
License and Notice for more information.
Databricks does not offer official support for dbdemos and the associated assets.
For any issue, please open a ticket and the demo team will have a look on a best-effort basis. 


demo thumb


AI Functions: Query LLMs With DB SQL

demo thumb


Feature Store and Online Inference

demo thumb


Build Your Chatbot With Dolly