How can we improve Microsoft Azure SQL Data Warehouse ?

SET TRANSACTION ISOLATION LEVEL

Supporting "READ COMMITTED"

9 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        I am sorry for late replay.
        Many table data has "delete" and "insert" of merge processing all day.
        In the case of dirty read, referring to the "delete" processing table will cause data to be missing.
        If "READ COMMITTED" is supported, data loss can be avoided.

      • joeyong commented  ·   ·  Flag as inappropriate

        Thanks for the request.

        Questions:
        1. What is your use case? Do you have a mixed workload where updates happen alongside reads?
        2. Will Read Committed Snapshot Isolation work for you?

      Feedback and Knowledge Base