delta live table

[Rishabh264]

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 ?

[Ajay-Pandey]

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

[Rishabh264]

thanks ajay for the link

[Hubert-Dudek]

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

[Rishabh264]

thanks Hubert for answering the query

[Geeta1]

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

[Rishabh264]

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