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

KKirkpatrick

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?

[Deleted User]

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