Azure Synapse Analytics- Interview Questions | Serverless SQL Pool VS Dedicated SQL Pool with Demo

Sdílet
Vložit
  • čas přidán 8. 09. 2024

Komentáře • 5

  • @smderoller
    @smderoller Před měsícem

    Great...thanks

  • @ugandarhari
    @ugandarhari Před 3 měsíci

    It was nice content. I had an interview question on performance issue of using Merge into query in Databricks and what is the best way to load the data using Spark SQL or PySpark.
    Could you please make a video on this?

    • @1HourBule
      @1HourBule Před 3 měsíci

      * for upserts use MERGE *
      MERGE INTO myTable USING myData
      * Loading via autoloader, you need to read the stream first *
      val df = spark.readStream.format("cloudFiles")
      .option("cloudFiles.format", "json")
      .load("/input/path")
      df.writeStream.trigger(Trigger.Once)
      .format("delta")
      .start("/output/path")

  • @ramjeeyadav5743
    @ramjeeyadav5743 Před 2 měsíci

    is there any future demand for Azure Synapse as Fabric is its successor? should we learn fabric instead as a Data engineer?

    • @ugandarhari
      @ugandarhari Před 2 měsíci +1

      You can learn the entire Microsoft Fabric in 3 hrs and become a Fabric expert after watching Mr. K's video.