Create a Delta Table with PK and FK constraints for a streaming source data

Dharinip
Contributor

1. How to create a Delta Table with PK and FK constraints for a streaming source data?

2. When the streaming data in the silver layer gets updated, will the delta table also be updated?

My use case is:

We have a streaming data in the silver layer as SCD type 2. And we want to create a Delta Table with Primary key and foreign key constraints in the Gold Layer having SCD Type 1.

 

DHARINI PARGUNAN