DDL script to upper environment

KKo — Thu, 16 Oct 2025 21:17:30 GMT

I have multiple databases created in unity catalog in a DEV databricks workspace, I used databricks UI/notebook and ran scripts to do it. Now, I want to have those databases in QA and PROD workspaces as well. What is the best way to run those DDLs in upper environments? I don't want to go QA/PROD worspace UI or create notebook on them and run scripts to create them, rather I want to promote DDL script from DEV and run in QA/PROD. Any advice on this, how to achieve this in a simple way?

Re: DDL script to upper environment

szymon_dybczak — Thu, 16 Oct 2025 21:44:22 GMT

Hi @KKo ,

The simplest way is to have a parametrized notebook which you can pass a name of your catalog as your parameter. Then you can use that parameter to prepare appropriate SQL statements responsible for creating catalogs/schemas/tables.

Alternatively, you can use tools like Flyway/Liquibase that can help with CI/CD process of database objects

topic DDL script to upper environment in Data Engineering

DDL script to upper environment

Re: DDL script to upper environment