Your Warehouses

Your Warehouses

View Managed & Unmanaged Warehouses

Slingshot Role: Approver/Reviewer, Org Admin, Tenant Admin, Warehouse Owner

Your Slingshot role and business org or business unit determine which warehouses appear in Your Warehouses.

For Approvers/Reviewers: You see Managed and Unmanaged warehouses for your business org.

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

View a warehouse

  1. From Your 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.

Assign an Unmanaged Warehouse

Unmanaged warehouses are warehouses that are not provisioned by Slingshot. Tenant Admins may find them in the Configuration menu.

From Assign Snowflake Objects, Tenant Admins can:

  • Assign an unmanaged warehouse to a business org
  • If they want to re-assign to another business org, go to the Unmanaged tab in Your Warehouses (re-assignment is only available when there is no in-flight management request)

View Unmanaged Warehouses

View your unmanaged warehouses by selecting the Unmanaged tab on the Your Warehouses page.

Manage an Unmanaged Warehouse

Similar to other warehouse requests, Warehouse Owners submit management requests. Warehouses listed here are not currently managed in Slingshot. Adding them to your managed warehouse list is as easy as completing a form.

  1. From the Unmanaged tab, select the Manage button for the warehouse you would like to manage and monitore via Slingshot.
  2. Select a Warehouse Environment from the drop-down menu.
  3. Then choose a Warehouse Template.
  4. Adjust the Statement Timeout.
  5. Select Continue.
  6. Set a schedule or create a new schedule by making the following selections (you can also use the default schedule):
    • End Time
    • Warehouse Size
    • Cluster Minimum
    • Cluster Maximum
    • Scaling Policy
    • Auto Suspend
    • Toggle Warehouse on or off
  7. Select Continue.
  8. Review the information and Submit the request for approval.
  9. Until the warehouse is approved, Management Pending replaces the Manage button for the warehouse you requested to manage.

Once approved, the warehouse appears in the Managed tab on the Your Warehouses page.

Create a New Warehouse

Warehouse owners may create warehouse provisioning requests.

Approvers are tasked with approving or denying warehouse provisioning requests.

  1. From the Managed tab select the + Create New Warehouse button.

  2. Click on the + Create New Warehouse button.

  3. Set the parameters for the new Warehouse. a. Organizational Level - The Organizational Level setting allows you to dictate which level of the organization the warehouse will exist at, for example Supervisory vs Executive.

    b. Warehouse Environment -Different environments can be created during the onboarding process, for example Production vs Test.

    c. Warehouse Template - Warehouse Template contains customized rules and warehouse parameters defined by admins.

    d. Snowflake Account - Snowflake account where the warehouse resides.

    e. Warehouse Name - The name of the newly created warehouse.

    f. Statement Timeout - Amount of time, in seconds, after which a running SQL statement (query, DDL, DML, etc.) is canceled by the system.

  4. Select Create schedule to set the warehouse schedule.

The Warehouse Scheduling screen allows you to set several parameters based on time and days of the week, permitting Snowflake to run in the most efficient manner possible, along with a max monthly cost.

  • Schedules - Slingshot allows Snowflake to be provisioned with 1 or more schedules with the following parameters
    • Start Time and End Times - Schedule begin and end times in ET
    • Warehouse Size - Determines the processing power and cost of the warehouse (See Warehouse size and cost)
    • Cluster Min/Max - The number of database instances (can vary from 1-10) devoted to processing
    • Scaling Policy - How the warehouse scales to meet demand
      • Standard - Minimizes queuing by starting warehouses when demand increases
      • Economy - Conserves costs by allowing warehouses to run fully loaded
    • Auto-Suspend - Automatically suspend the warehouse after a predetermined period of inactivity
      • When checked a field appears allowing you to set the period of inactivity (parameter varies based on the template settings). The warehouse will auto-suspend after this period expires with no activity.
      • If unchecked the warehouse runs continuously even if inactive.
        This results in greater cost.
      • Warehouse on toggle determines when the Snowflake Data Warehouse will be on or off.
    • To complete warehouse configuration, the schedule must be set for a 24-hour period comprising of 7 days.
  1. Select the Review schedule - the Warehouse Review screen displays all of the settings for the newly created warehouse details:
  • Organization
  • Snowflake Account
  • Warehouse Template
  • Warehouse Name
  • Statement Timeout
  • Approver(s) (if available)
  1. Click Submit for Approval to start the approval process, or Back to continue adjusting the schedule.
  2. Select Submit Request to confirm you’re ready to submit your request, or Back to Review to make additional changes before submitting.
  3. A success message appears confirming your submission.