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 recued-core.snowflake.warehouse.search

Search warehouse on snowflake

■ 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

▼

Output

summary card

table wh_table

Settings 1 configurable

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

idle threshold setting = 600