Data Warehousing With Identity, Primary Key and Foreign Key

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.install('identity-pk-fk')

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 README.md 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.