topic Re: delta live table in Data Engineering

delta live table

Rishabh-Pandey — Tue, 06 Dec 2022 08:14:28 GMT

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 ?

Re: delta live table

Ajay-Pandey — Tue, 06 Dec 2022 09:08:29 GMT

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

Re: delta live table

Hubert-Dudek — Tue, 06 Dec 2022 11:24:25 GMT

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

Re: delta live table

Geeta1 — Tue, 06 Dec 2022 12:08:07 GMT

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

Re: delta live table

Rishabh-Pandey — Tue, 06 Dec 2022 19:26:51 GMT

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

Re: delta live table

Rishabh-Pandey — Tue, 06 Dec 2022 19:27:10 GMT

thanks Hubert for answering the query

Re: delta live table

Rishabh-Pandey — Tue, 06 Dec 2022 19:27:21 GMT

thanks ajay for the link