com.unraveldata.sf.max.join.limit

Specifies the maximum limit for the number of joins in Snowflake queries.

Optional

Integer

3

com.unraveldata.sf.max.row.count.limit

Sets the maximum limit for the number of rows allowed for a specific query in Snowflake.

Optional

Integer

100000

com.unraveldata.sf.warehouse.insights.period.days

Specifies the number of days of data to consider for generating warehouse and compute insights in Snowflake.

Optional

Days

15

com.unraveldata.sf.suspend.insights.interval.secs

Sets the interval, in seconds, to capture the count of suspended warehouses, which is used in the insights for warehouses.

Optional

Seconds

60

com.unraveldata.sf.suspend.insights.interval.secs

Sets the interval to measure the warehouse suspend events within a specified duration.

Optional

Seconds

60000

com.unraveldata.sf.schedule.test.suspend.weekends

Specifies whether to suspend the schedule on the test environment during weekends. By default, this feature is disabled.

Optional

Boolean

False

com.unraveldata.sf.schedule.test.suspend.time

Specifies the time intervals during which the schedule on the test environment should be suspended on workdays.

Optional

String

20:00-08:00

com.unraveldata.sf.avg.queued.to.running.ratio

Specifies the average queued-to-running ratio to assess warehouse load, indicating whether it is overloaded or consolidated.

Optional

Double

0.2

com.unraveldata.sf.expensive.query.by.cost

Marks a query as expensive when its cost exceeds the configured threshold in the specified currency.

Optional

Integer

10

com.unraveldata.sf.warehouse.cost.look.back.days

Specifies the number of days to look back when analyzing warehouse cost data.

Optional

Days

30