Configure Profile (Snowflake)

The following properties can be customized for Profile in Snowflake.

Propert/Description	Set by User	Unit	Default
com.unraveldata.sf.cartesian.join.threshold Sets the threshold for identifying a Cartesian join or row explosion, which occurs when a query returns more output rows compared to input rows after a join operation.	Optional	Integer	10
com.unraveldata.sf.expensive.query.by.cost Generates a cost insight when a query contains Join or Cartesian Join nodes with a specified cost percentage. You can specify any double value. For example, 10.00.	Optional	Double	0
com.unraveldata.sf.time.to.generate.cost.saving Specifies the overall percentage time to generate cost savings for Join queries. You can specify a decimal value. For example, 10.00.	Optional	Double	0

Propert/Description

Set by User

Unit

Default

com.unraveldata.sf.cartesian.join.threshold

Sets the threshold for identifying a Cartesian join or row explosion, which occurs when a query returns more output rows compared to input rows after a join operation.

Optional

Integer

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

Generates a cost insight when a query contains Join or Cartesian Join nodes with a specified cost percentage. You can specify any double value. For example, 10.00.

Optional

Double

com.unraveldata.sf.time.to.generate.cost.saving

Specifies the overall percentage time to generate cost savings for Join queries. You can specify a decimal value. For example, 10.00.

Optional

Double

In this section:

Home

Configure Profile (Snowflake)

Search results