GCP - BigQuery CDC delta load logic (Change Data Capture) - DIY#8

Поділитися
Вставка
  • Опубліковано 14 лис 2024

КОМЕНТАРІ • 7

  • @natitt6780
    @natitt6780 4 роки тому +2

    Thank you for making this video. Specially, breaking it down to the point its so easy to understand.

  • @sandeepgondela9090
    @sandeepgondela9090 2 роки тому

    thanks for your efforts and posting this content

  • @umeshkul74
    @umeshkul74 3 роки тому

    Very nice video. Thank you

  • @santicodaro
    @santicodaro 2 роки тому

    Thanks!!

  • @prachitaksali3879
    @prachitaksali3879 3 роки тому

    really good video

  • @abdulmunaf4941
    @abdulmunaf4941 3 роки тому +1

    Rather writing SP and doing comparison to find insert update delete, you can update what received from source and update to target, having SP is additional performance overhead

    • @turi104
      @turi104 3 роки тому

      yes sp eats when table is huge as it compares whole record.How to handle situation when before merging your sp reads more than 10gb of data