Is it possible to restrict/limit the amount of disk space (or licenced space) of indivual users

Now and then a novice user mistakenly runs a CTAS that fetches far more data than intended.

CREATE TABLE T AS SELECT * FROM MASSIVE_TABLE;

 

Is there a user setting, resource pool setting, or schema setting that can be used to restrict the amount of disk space an individual user might consume?

Comments

  • No, it is not possible. There is a feature request similar to this but it is not on the roadmap. I will add your interest so PM can prioritize it. 

     

    Eugenia

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file