New Object type: Workspace

[kokorin]

Snowsight UI recently switched to Wrokspaces as a replacement for Worksheets.

To create Shared Workspace one needs CREATE WORKSPACE ON SCHEMA privilege.

GRANT OWNERSHIP ON ALL WORKSPACES IN SCHEMA.. is not supported, and most probably ON FUTURE WORKSPACES isn't too.

Theoretically we need only owner_create_grants, not owner_future_grants.

[littleK0i]

Added WORKSPACE in 0.63.0+. It can be used for owner_create_grants.

I've checked if future grants are supported, and the answer is negative. In my view, this feature likely requires future grants to work properly. Otherwise shared workspaces are technically "owned" directly by their creators instead of schema owner roles.

In theory, we could try to create & manage shared workspaces via SnowDDL and assign proper grants at the time of creation. But SQL commands for this do not seem to be documented (yet?). Snowflake clearly wants this feature to work via GUI.