Skip to content

Add Databricks DDL for OMOP CDM v5.4 #781

@tenbosch

Description

@tenbosch

Hello, I've created Databricks-compatible DDL scripts for OMOP CDM v5.4. These scripts support Unity Catalog with USE CATALOG / USE SCHEMA for deployment flexibility.

Scripts

Three files:

  1. OMOPCDM_databricks_5.4_ddl.sql - All 39 CREATE TABLE statements
  2. OMOPCDM_databricks_5.4_primary_keys.sql - 30 primary key constraints
  3. OMOPCDM_databricks_5.4_constraints.sql - 89 foreign key constraints

OMOPCDM_databricks_5.4_primary_keys.sql
OMOPCDM_databricks_5.4_ddl.sql
OMOPCDM_databricks_5.4_constraints.sql

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions