Building a Data Warehouse Dimensional Model using Azure Synapse Analytics SQL Serverless

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ธ.ค. 2024

ความคิดเห็น • 26

  • @BaGua79
    @BaGua79 2 ปีที่แล้ว +5

    13min in, already obvious this is a fantastic video. Thanks for doing this!

    • @CloudLunchLearn
      @CloudLunchLearn  2 ปีที่แล้ว

      Thank you @BaGua79. We are happy you enjoyed it. Please help us promote it, by sharing it with your colleagues and friends using your social accounts. Have a great day.

  • @MrArsalan1988
    @MrArsalan1988 3 ปีที่แล้ว +6

    very information session sir

    • @CloudLunchLearn
      @CloudLunchLearn  2 ปีที่แล้ว

      Thank you @Arsalan. We are happy you enjoyed it. Please help us promote it, by sharing it with your colleagues and friends using your social accounts. Have a great day.

  • @kenpoken1
    @kenpoken1 2 ปีที่แล้ว +5

    Great video. thanks for sharing

    • @CloudLunchLearn
      @CloudLunchLearn  2 ปีที่แล้ว

      Thank you @Ken. We are happy you enjoyed it. Please help us promote it, by sharing it with your colleagues and friends using your social accounts. Have a great day.

  • @demdemdem-g6j
    @demdemdem-g6j ปีที่แล้ว +2

    i enjoyed watching this video but please get us 1080p or 4K going forward. THANKS

  • @smw999
    @smw999 ปีที่แล้ว

    Very helpful and clear. Thanks for sharing this.

    • @CloudLunchLearn
      @CloudLunchLearn  5 หลายเดือนก่อน

      Glad you liked it. Help us promoting the video by sharing it on your social networks and tagging us. Follow us on LinkedIn and X to receive our updates about Cloud and Tech.

  • @artus198
    @artus198 ปีที่แล้ว +2

    How do you take care of scd 1 , scd 2 etc ? Coming from traditional SQL server background, this all sounds f'ed up to me. They talk about external table, then views , then CSV files 😯 ?? W t f is going on

  • @AHMEDALDAFAAE1
    @AHMEDALDAFAAE1 7 หลายเดือนก่อน

    Thank you this amazing video!!

    • @CloudLunchLearn
      @CloudLunchLearn  7 หลายเดือนก่อน +1

      Thank you for your support Ahmed. We appreciate it. If you have a few minutes, please share the session on your social so your friends and contacts can watch it as well. And you can tag the Cloud Lunch and Learn group. Have a great day!

    • @AHMEDALDAFAAE1
      @AHMEDALDAFAAE1 7 หลายเดือนก่อน

      @@CloudLunchLearn I did already. Thank you 😊

  • @geehaf
    @geehaf 2 ปีที่แล้ว +3

    Great session - really like your "show it for real" demo style. So the use of external tables in this session is primarily to easily transform CSV to Parquet format? Also, for adding new partitions to the view, it relies on the Parquet file remaining after a Drop External table has been issued?

    • @CloudLunchLearn
      @CloudLunchLearn  2 ปีที่แล้ว

      Thank you @George. We are happy you enjoyed it. Please help us promote it, by sharing it with your colleagues and friends using your social accounts. Have a great day.

  • @RodrigoBocanegraCruz
    @RodrigoBocanegraCruz 3 ปีที่แล้ว +4

    Great, thanks for sharing! I was trying to implement a DataVault logical DWH but there is no hashbytes :| I hope this feature will be supported in the future

    • @DatahaiBI
      @DatahaiBI 2 ปีที่แล้ว

      Hi, the HASHBYTES function is now supported in Serverless SQL Pools

    • @CloudLunchLearn
      @CloudLunchLearn  2 ปีที่แล้ว

      Thank you @Rodrigo. We are happy you enjoyed it. Please help us promote it, by sharing it with your colleagues and friends using your social accounts. Have a great day.

  • @valentinloghin4004
    @valentinloghin4004 ปีที่แล้ว +1

    Super nice !! I is there any way to have the scripts and source files ? Thank you !!

  • @joshuaandresblancojerez6455
    @joshuaandresblancojerez6455 2 ปีที่แล้ว +6

    nice video, a shame the resolution.

    • @CloudLunchLearn
      @CloudLunchLearn  2 ปีที่แล้ว

      Thank you @Joshua. We are happy you enjoyed it. Please help us promote it, by sharing it with your colleagues and friends using your social accounts. Have a great day.

  • @nandarajm880
    @nandarajm880 6 หลายเดือนก่อน

    Can you please give us the csv files

  • @Rothbardo
    @Rothbardo 3 ปีที่แล้ว +2

    Would looping through a series of dates be synchronous? Is there a way to do that asynchronously?

    • @DatahaiBI
      @DatahaiBI 3 ปีที่แล้ว

      This could be done using Pipelines/Data Factory to iterate and trigger the SP asynchronously. The external table name would need to be unique (dynamic sql to generate the table creation syntax)

  • @sanishthomas2858
    @sanishthomas2858 ปีที่แล้ว

    I m surprised I can't see anything

  • @Mac-vn5rf
    @Mac-vn5rf 2 ปีที่แล้ว +2

    Your intro is too long