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

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 ก.ย. 2024

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

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

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

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

      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 2 ปีที่แล้ว +6

    very information session sir

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

      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.

  • @user-du5rg4em6i
    @user-du5rg4em6i 11 หลายเดือนก่อน +2

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

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

    Great video. thanks for sharing

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

      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.

  • @artus198
    @artus198 10 หลายเดือนก่อน +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 3 หลายเดือนก่อน

    Thank you this amazing video!!

    • @CloudLunchLearn
      @CloudLunchLearn  3 หลายเดือนก่อน +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 3 หลายเดือนก่อน

      @@CloudLunchLearn I did already. Thank you 😊

  • @smw999
    @smw999 9 หลายเดือนก่อน

    Very helpful and clear. Thanks for sharing this.

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

      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.

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

    nice video, a shame the resolution.

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

      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.

  • @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  ปีที่แล้ว

      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 2 ปีที่แล้ว +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  ปีที่แล้ว

      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 !!

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

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

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

      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 11 หลายเดือนก่อน

    I m surprised I can't see anything

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

    Can you please give us the csv files

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

    Your intro is too long