Excel file to Azure Synapse Analytics (SQL DW)

Поделиться
HTML-код
  • Опубликовано: 15 сен 2024
  • Automating the process of copying data from Excel files to Azure Synapse Analytics dedicated SQL Pool (SQL DW)

Комментарии • 10

  • @clintonrebeiro5598
    @clintonrebeiro5598 3 года назад +4

    Thank you so much for such a clear and informative video. Keep up the good work.

    • @databites_gn
      @databites_gn  3 года назад

      Thank you very much for feedback!

  • @tegampurearvind447
    @tegampurearvind447 2 года назад +1

    Awesome, this exactly what I wanted to setup, thank you.

  • @selairendri9997
    @selairendri9997 Месяц назад

    hello , thanks for your video, how can I Run my pipeline automatically when a new line is ad in my Excel file ?

  • @onebasket806
    @onebasket806 3 года назад +1

    Thank you for this insightful video @Data bites

    • @databites_gn
      @databites_gn  3 года назад

      Thank you very much for your feedback!

  • @naziaakhtar8575
    @naziaakhtar8575 2 года назад

    would this work if we add additional column and run it?

    • @naziaakhtar8575
      @naziaakhtar8575 2 года назад

      or if we remove a column?

    • @databites_gn
      @databites_gn  2 года назад

      @@naziaakhtar8575 Not without changing the data flow (by adding a new column or removing a column) in both the source and the sink code, and then publish it again. That's because the target is Data Warehouse (the sink), where the schema must be defined on the target tables. If the target is schema-less (let's say a parquet file in Data Lake) then it would be possible to construct a data flow that can accommodate the change of source/target structure (new columns/missing columns). I hope it make sense.