Add Databricks DDL for OMOP CDM v5.4
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 68/100
Research direction
Start by reviewing the attached OMOPCDM_databricks_5.4_ddl.sql, OMOPCDM_databricks_5.4_primary_keys.sql, and OMOPCDM_databricks_5.4_constraints.sql files against the repository’s existing OMOP CDM v5.4 DDL conventions. Check that the 39 tables, 30 primary keys, 89 foreign keys, and Unity Catalog statements are consistent and Databricks-compatible. Done means the three scripts are added in the expected locations and can be deployed with USE CATALOG and USE SCHEMA.
Written by the indexing model from the issue text.
Description
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:
- OMOPCDM_databricks_5.4_ddl.sql - All 39 CREATE TABLE statements
- OMOPCDM_databricks_5.4_primary_keys.sql - 30 primary key constraints
- 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
- Dominant language
- HTML
- Stars
- 1.1k
- Forks
- 513
- Avg merge
- 8d 3h
- Merged PRs (30d)
- 4
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from OHDSI/CommonDataModel
-
Difficulty 1/5 Under an hour Newbie friendliness 74/100
OHDSI/CommonDataModel#802 · 1 comment ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
OHDSI/CommonDataModel#799 ·
-
fix: mark cohort_definition_id as primary key in cohort_definition table for v5.3 and v5.4Possibly taken @rtmalikian claimed this 138 days ago. Open
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
OHDSI/CommonDataModel#787 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
OHDSI/CommonDataModel#784 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 55/100
OHDSI/CommonDataModel#823 ·
All issues in OHDSI/CommonDataModel
Similar issues
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
TUM-Dev/Campus-Backend#678 ·
Maintainers usually reply within 1 day
-
Gradle liquibaseDiffChangelog drops jhi_date_time_wrapperPossibly taken @mraible claimed this today. Openarea: triage theme: undefined
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
jhipster/generator-jhipster#35998 ·
Maintainers usually reply within 1 day
-
bug good first issue
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
Queries: Add MINUSOpenenhancement help wanted
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
elliotchance/vsql#983 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
paperclipai/paperclip#19077 ·
Maintainers usually reply within 1 day