topic How do I programmatically get the database name in a DLT notebook? in Data Engineering

How do I programmatically get the database name in a DLT notebook?

Jennifer_Lu — Wed, 21 Dec 2022 18:19:58 GMT

I have configured a database in the settings of my DLT pipeline. Is there a way to retrieve that value programmatically from within a notebook? I want to do something like

spark.read.table(f"{database}.table")

Re: How do I programmatically get the database name in a DLT notebook?

Jfoxyyc — Thu, 29 Dec 2022 07:40:18 GMT

You could also set it as a config value as database:value, and then retrieve it in the notebook using spark.conf.get().

I'm hoping they update DLT to support UC, and then allow us to set database/schema at the notebook level in @dlt.table(schema_name, table_name).