Roles

Your Slingshot role determines which permissions you have to manage warehouses, how those actions impact dashboard views, and which warehouses appear in My Warehouses. You could be assigned to multiple roles (e.g. Approver and Warehouse owner).

Slingshot roles include:

• Tenant Admins - Access to do everything an Approver, Org admin, and Warehouse owner can do in Slingshot with additional permissions to complete configuration and installation activities (e.g creating Slingshot tags, etc.).

• Approvers - Review, approve, deny requests, and search or view warehouses and dashboards.

• Org Admins - Have visibility of all warehouses in their org and their corresponding dashboards.

• Warehouse Owners - Manage warehouses by creating, modifying, assigning tags, etc.

• LOB Viewer - Tenant admins give teammates read only acess to specific lines of business in Slingshot.

Here’s an example of how Slingshot roles look once implemented in your business. In this example, the Data Platform Team are the Slingshot admins in the Tenant admin role overseeing 2 business orgs - Data Engineering and Business Intelligence. Each business org has an Org admin, Approvers, and Warehouse owners. As seen in the example, assigning more than one role is possible. Remember Tenant admins have exclusive access to perform all actions within your Slingshot tenant.

What can I do in Slingshot?

Everyone has permission to search and view warehouses. Your Slingshot role and business org or business unit determine which warehouses appear on My Warehouses page.

The Managed tab displays warehouses with an assigned schedule. The Unmanaged tab shows warehouses brought into Slingshot and need a schedule applied by the Warehouse owner.

View warehouses

To view a warehouse (managed or unmanaged)

1. From My Warehouses, select the Managed or Unmanaged tab.

2. View the warehouse details by pressing the warehouse name.

3. The Warehouse details appear.

4. Review the details. Press the X in the upper right corner to close the panel.

If you aren’t a warehouse owner, you see a message stating, “You do not have the warehouse owner permission to modify this warehouse.” Warehouse owners make adjustments to their assigned warehouses’ schedules and parameters.

Search the warehouse list

It’s a daunting task scrolling through several pages to find a particular warehouse. Slingshot’s responsive search makes finding a warehouse easier. Search by entering a warehouse name (or a portion of the name), role, size, cluster, max monthly cost, QAS, etc.

1. Enter search criteria into the Search box.
2. Review the results.
3. Clear the search by pressing the X.
4. With the search parameter cleared, the entire list of warehouses reappears.

Configuration & Setup

Slingshot role: Tenant Admin

Assign warehouses to a business org or unit

Tenant admins assign warehouses to business orgs and units. These assignments determine the parameters and warehouse templates applied to each warehouse.

1. Select Configuration from the top-navigation menu.
2. Choose the Assign Snowflake Objects card.
3. From the list of warehouses, check the box next to the warehouse name you’d like to assign. The Assign button becomes active.
4. Press Assign.
5. Select Business Organization or Business Unit from the drop-down menu.
6. Press the Assign button.
7. Review and Confirm Assignment. Or go back to choose another line of business.
8. A success message appears. Assign another warehouse or go to the homepage.

You’ll receive a notification once the migration completes, and it’ll be added to the My Warehouses page.

Once warehouses are assigned and added to My Warehouses, a Reassign button appears; allowing you to assign the warehouse to a different business org or unit.

For more configuration activities, visit Configuration.

Reassign a managed warehouse

Tenant admins reassign Business Organization, Warehouse Environment, or Warehouse Templates for managed warehouses. Managed means the warehouse has a defined schedule.

1. From My Warehouses, select the All Warehouses tab.
2. Use the Reassign button for the chosen warehouse.
3. Update the Business Organization, Warehouse Environment, or Warehouse Template from the corresponding drop-down menu.
4. Once you’re happy with your selection(s), press Continue.
5. Review the details, and Confirm.
6. After a few moments a success message appears.
7. Review other warehouses or make other reassignments.

Reassign an unmanaged warehouse

Tenant admins reassign Business Organization or Business Unit for unmanaged warehouses. Unmanaged means the warehouse has the option to apply a schedule. Applying a schedule moves the warehouse from unmanaged to managed.

1. From My Warehouses, select the Unmanaged tab.
2. Use the Reassign button for the chosen warehouse.
3. Update the Business Organization or Business Unit from the corresponding drop-down menu.
4. Once you’re happy with your selection, press Save.
5. After a few moments a success message appears.
6. Review other warehouses or make other reassignments.

Warehouse Management

Slingshot allows Warehouse owners, Tenant admins, and Org admins to make adjustments to warehouses. Approvers, like the name says, approve requests. To read more about warehouse management, visit My Warehouses.

Manage permissions for a warehouse

1. From My Warehouses, select the Managed tab.
2. View the warehouse permissions by pressing the warehouse name.
3. The warehouse details appear.
4. Select the Manage permissions tab.
5. In the User role name box, enter a role name or choose a selection from the drop-down list.
6. Save.
7. The role and status appear. After the role assignment processes successfully the status message changes from Processing to Granted.
8. Refresh the status to confirm that permissions were granted to the selected Role.
9. Review the details. Use the X in the upper right corner to close the window.

Remove permissions for a warehouse

1. From My Warehouses, select the Managed tab.

2. View the warehouse permissions by pressing the warehouse name.

3. The Warehouse details appear.

4. Select the Manage permissions tab.

5. From the User role list, check the box next to the role you’d like removed.

6. Use the Revoke access button.

7. Confirm.

8. Review the details. Use the X in the upper right corner to close the window.

Approvals

Approvers act as gatekeepers for various requests in the assigned business org or unit (e.g. warehouse provisioning requests, changing a current warehouse schedule, etc). As an Approver, you have the ability to approve, decline, and view assigned requests.

View requests

To view requests,

1. Press Requests on the left navigation menu.
2. Select the Pending, Approved, or Declined tab to see a list for requests with those statuses.

Or

1. From the homepage, scroll to the Approvals Inbox section.
2. Click the View Request button for the chosen request.
3. Review the Warehouse Modification Request details.
4. If necessary, add a message, then decline or approve the request. Always include an explanation for denied requests.

Approve or Decline requests

The Approvals Inbox provides you with tabs for

• Open Requests,
• In Progress requests,
• and Closed Requests.

The Closed Requests tab shows processed requests.

Each list includes the warehouse name, request type, status, requestor, maximum monthly cost, and request date.

To approve or decline requests

1. Scroll down to the Approvals Inbox on the Homepage or select Approvals Inbox from the left navigation menu.
2. Use the Approve button to approve a request - or - use the Decline button to deny the request and add a message explaining the denial.
3. Select Decline Request (if necessary).
4. The list refreshes and the request disappears from the Approvals Inbox.