Create and Manage Snowflake Project Workspaces

After workspaces are configured, project owners can enable workspaces within their projects. This feature allows project members to write data to the project and share this data with other users as derived data sources.

Requirement: You must own the project

Prerequisites:

• Snowflake integration configured with workspaces enabled.
• Snowflake tables are registered in Immuta.
• External IDs have been connected with an IAM or manually mapped in for Snowflake.
• Data sources registered by excepted roles: Snowflake workspaces generate static views with the credentials used to register the table as an Immuta data source. Those tables must be registered in Immuta by an excepted role so that policies applied to the backing tables are not applied to the project workspace views.

Create a Snowflake workspace

1. Navigate to the Policies tab and enable project equalization by clicking the Project Equalization slider to on.
2. Scroll to the Native Workspace section and click Create.
3. Select Snowflake from the Workspace Configuration dropdown menu.

4. Name the Workspace Schema. By default, the schema name is based off of the project name, but you can change it here. Your project workspace will exist within this schema under Snowflake under the database configured by the Application Admin.

5. Use the dropdown menu to select the Hostname. Projects can only be configured to use one Snowflake host.

6. Select one or more Warehouses to be available to project members when they are working in the Snowflake workspace.

7. Click Create to enable the workspace.

Delete a workspace

1. Scroll to the Native Workspace section on the policies tab and click the toggle to disable the workspace.

2. Click Delete in the native workspace section.

3. Choose one of the following options in the modal:

   • Purge Generic Workspace Data: Permanently delete data, while the data used by derived data sources is preserved. Note: If you created a derived data source that references a view on top of a table in Snowflake that isn't a derived data source, that table will be deleted and break the derived data source.
   • Purge Everything & Delete Derived Data Sources: Permanently delete data and purge all derived data sources.

4. Click Delete.