delta live table

Rishabh-Pandey
Databricks MVP

If i have two stages bronze and silver and when i create delta live tables we need to give the target schema to store the results , but i need to store tables in two databases bronze AND silver , for this i need to create two different delta live tables ?

Rishabh Pandey

Ajay-Pandey
Databricks MVP

Hi @Rishabh Pandey​ please refer to this link, it may help u with this.

Ajay Kumar Pandey

thanks ajay for the link

Rishabh Pandey

Hubert-Dudek
Databricks MVP

As you prefer, I would choose a separate database/schema for bronze, silver, and gold.


My blog: https://databrickster.medium.com/

thanks Hubert for answering the query

Rishabh Pandey

Geeta1
Databricks Partner

Hi @Rishabh Pandey​ , yes you have to create 2 DLT tables

thanks for letting me know , so you mean to say that i have to create two dLT pipelines with two different target databases one is for bronze and one is for silver

Rishabh Pandey