which option is better

[Pratikmsbsvm]

Can anyone please help me which option is better and why ?

Thanks a lot

[radothede · Accepted solution]

Hi @Pratikmsbsvm 

We're still missing some context, but generally speaking I would say consuming silver layer data is the way.

Of course, it dependes of use-case and project needs, however, as I understand medallion architecture:

a) bronze layer data is "raw" data with no significant transformations or no transformations at all,

b) silver layer would be cleansed data, with possible business-logic transformations applied, perfectly in delta table format (ACID, time travel and all the other features). 

Please visit this topic also to dive deeper 🙂

Best,

Radek.

[Sharanya13]

+1 @radothede 

@Pratikmsbsvm How are you transforming from bronze to silver? DLT?