How can we improve Microsoft Azure Data Lake?

Allow a READONLY EXCLUDE clause

Listing the read-only columns for a UDO is fine when there is a known, small set of columns, but is really annoying when more of the columns are read-only than not. It would be nice if we could specify something like `READONLY EXCLUDE col2, col3`, where I specify only the columns that I know are going to be updated.

If a column was added to the source table, the developer has to remember to update all UDOs or not have ideal optimization. With a READONLY EXCLUDE clause, the code can run fully optimized regardless of whether surrounding columns are added or removed.

1 vote
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

    Dan Friedman shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

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

      Feedback and Knowledge Base