- 4854 Views
- 1 replies
- 1 kudos
Please help me for database Objects Naming Convention and coding standard for Bronze, Silver and Gold Layers
- 4854 Views
- 1 replies
- 1 kudos
Latest Reply
Hi @Arun Sharma Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers y...
by
Mado
• Valued Contributor II
- 3608 Views
- 4 replies
- 0 kudos
Assume that I have a data source that is ingested to a few bronze tables, and transformed to a silver table. Ans next, a gold table is created by aggregating the silver table. If new records arrive in the data source, bronze and silver tables are upd...
- 3608 Views
- 4 replies
- 0 kudos
Latest Reply
Mado
Valued Contributor II
Hi @Vidula Khanna The answer didn't fit my question. In the case of using Merge, I found a good article here:https://medium.com/@avnishjain22/simplify-optimise-and-improve-your-data-pipelines-with-incremental-etl-on-the-lakehouse-61b279afadea
3 More Replies
by
Daba
• New Contributor III
- 6917 Views
- 3 replies
- 4 kudos
I'm trying to build gold level streaming live table based on two streaming silver live tables with left join.This attempt fails with the next error:"Append mode error: Stream-stream LeftOuter join between two streaming DataFrame/Datasets is not suppo...
- 6917 Views
- 3 replies
- 4 kudos
Latest Reply
Thanks Fatma,I do understand the need for watermarks, but I'm just wondering if this supported by SQL syntax?
2 More Replies
- 2897 Views
- 4 replies
- 3 kudos
Hello Community,I am currently working on populating gold layer tables. Source for these gold layer tables are silver layer tables. A query is going to run on silver layer tables, spark sql query contains joins between multiple tables.ex:select colum...
- 2897 Views
- 4 replies
- 3 kudos
Latest Reply
Hi @bodempudi venkat Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.T...
3 More Replies
- 1343 Views
- 0 replies
- 1 kudos
I have a DB-savvy customer who is concerned their silver/gold layer is becoming too expensive. These layers are heavily denormalized, focused on logical business entities (customers, claims, services, etc), and maintained by MERGEs. They cannot pre...
- 1343 Views
- 0 replies
- 1 kudos
