topic Re: Databricks database in Get Started Discussions

Databricks database

greengil — Wed, 21 Jan 2026 02:25:27 GMT

In Oracle, I create schemas and tables and link tables together via the primary/foreign key to do SQL queries.

In Databricks, I notice that I can create tables, but how do I link tables together for querying? Does Databricks queries need the key in the table columns just like Oracle to query for data?

Re: Databricks database

pradeep_singh — Wed, 21 Jan 2026 02:46:03 GMT

Databricks supports primary and foreign key constraints on Unity Catalog Delta tables, but these are informational and not enforced; queries do not depend on them to be able to join tables .
To query all related data from multiple tables you will need to use join between all the related tables with right join condition .

Re: Databricks database

greengil — Wed, 21 Jan 2026 05:44:05 GMT

Hi @pradeep_singh - Thank you for your reply. So to join the 2 tables, similar to the relational database SQLs, I will still need to specify the unique keys in each table and join the tables accordingly? Thanks!

Re: Databricks database

tharple135 — Wed, 21 Jan 2026 20:26:30 GMT

@greengil you treat your joins in Databricks the same way you would in any other relational database. Join 2+ tables together using the primary/foreign keys from each of those tables.

Re: Databricks database

greengil — Wed, 21 Jan 2026 21:30:51 GMT

thank you for the info!

Re: Databricks database

balajij8 — Sat, 24 Jan 2026 14:13:01 GMT

Primary & Foreign Keys are informational unlike Oracle. You can use Unity Catalog Lineage Graph for easily finding the relationships between tables in Databricks.