Recued
Menu
← Back to recipes

Which warehouses bill while nobody is using them

by recued-core v1 10 views

Use “Which warehouses bill while nobody is using them” in Recued. It carries out the named workflow using the connections and settings you choose.

How it works 17 steps

Inspect the data fetches, transforms, gates, and output this recipe runs.

Process (17 steps)
warehouses_raw ?
warehouses default
Apply default
wh_count count
Count items in warehouses
have_warehouses template
Generate text from a template
fail: step.warehouses is_empty
suspends filter
Filter by condition
suspend_count count
Count items in suspends
never_suspend_count math
Calculate: {{step.wh_count}} - {{step.suspend_count}}
slow_suspend filter
Filter by condition
slow_count count
Count items in slow suspend
multi_cluster filter
Filter by condition
multi_count count
Count items in multi cluster
running filter
Filter by condition
running_count count
Count items in running
unmonitored filter
Filter by condition
unmonitored_count count
Count items in unmonitored
card to_summary
Format results as a summary card
wh_table to_table
Format results as a data table
Settings 2 configurable

Configurable at install. Defaults shown — change them anytime in Recued.

snowflake setting =
idle threshold setting = 600

Trust & control

What installing this recipe would let it do. Recued grants these permissions at install — review them there before approving.

Permissions it requires

Read your Snowflake connection
Declared by the recipe — Recued grants these at install, where you review them before approving.

About

Tags

snowflake snowflakedatawarehousecostcreditsread-only

Details

17 steps 2 configurable settings recipe_id: review-warehouse-cost-snowflake