databrickslabs / lsql

Lightweight SQL execution wrapper only on top of Databricks SDK
https://pypi.org/project/databricks-labs-lsql/
Other
14 stars 4 forks source link

Change how `SchemaDeployer` repalces target database in view defintions #311

Open JCZuurmond opened 1 month ago

JCZuurmond commented 1 month ago

Problem description

Currently, the SchemaDeployer replaces the hardcoded "$inventory" value to overwrite the catalog and schema given during initialisation in the view definitions. We want to avoid such a hardcoded value.

Proposed solution

An approach where $inventory is NOT hardcoded, possibly using sqlglot as we do in the dasboard-as-code here