com.unraveldata.sf.user

Specifies the Snowflake user who polls the data.

Mandatory

String

com.unraveldata.sf.password

Specifies the Snowflake password.

Mandatory

String

com.unraveldata.sf.account

Specifies the Snowflake account information to log in to the Snowflake account.

Mandatory

String

com.unraveldata.sf.user.role

Specifies the role to use for polling Snowflake data into Unravel.

Optional

String

ACCOUNTADMIN

com.unraveldata.tenant.id

Specifies the Tenant ID for the current Unravel Session. The default is 1, representing the Unravel tenant. Other values can be given. For example, 2 can represent 12.34 or 3 can represent xyz.

Optional

String

1

com.unraveldata.sf.schema

Specifies a schema Unravel utilizes to create particular objects for data polling from Snowflake. For example, this schema may be used for creating a stored procedure, such as show_warehouses_with_id, which combines the results of the SHOW and SELECT commands to provide customized results.

Optional

unravelschema

com.unraveldata.sf.data.load.mode

Specifies the data loading mode, which can be set to one of the following values: live or snapshot.

Optional

String

live

com.unraveldata.sf.overwrite.record

Determines whether existing data should be overwritten while polling. If set to True, data will be polled and overwritten. Default value is True.

Optional

Boolean

True

com.unraveldata.sf.os.timezone.formatter

Specifies the date and time formatter used by the operating system.

Optional

String

yyyy-MM-dd HH:mm:ss.SSSZ

com.unraveldata.sf.cluster.size.mapping

Defines the mapping between T-shirt sizes and cluster sizes for a Snowflake account. The mapping is provided in JSON format and includes values for Snowpark-Optimized and Standard modes.

Optional

String

{"SNOWPARK-OPTIMIZED":{"MEDIUM":4,"LARGE":8,"XLARGE":16,"X-LARGE":16,"XXLARGE":32,"2XLARGE":32,"2X-LARGE":32,"XXXLARGE":64,"3XLARGE":64,"3X-LARGE":64,"X4LARGE":128,"4X-LARGE":128,"X5LARGE":256,"5X-LARGE":256,"X6LARGE":512,"6X-LARGE":512},"STANDARD":{"XSMALL":1,"X-SSMALL":1,"X-SMALL":1,"SMALL":2,"MEDIUM":4,"LARGE":8,"XLARGE":16,"X-LARGE":16,"XXLARGE":32,"2XLARGE":32,"2X-LARGE":32,"XXXLARGE":64,"3XLARGE":64,"3X-LARGE":64,"X4LARGE":128,"4X-LARGE":128,"X5LARGE":256,"5X-LARGE":256,"X6LARGE":512,"6X-LARGE":512}}

com.unraveldata.sf.query.tag

Specifies the query tag under which all Unravel queries are executed in the Snowflake account.

Optional

String

UNRAVEL_COST

unravel.saas

Specifies whether the environment is SaaS-based or not. Default value is False, signifying that the setup is not a Saas environment.

Optional

Boolean

False

com.unraveldata.sf.avg2max.ratio

Specifies the ratio used to determine whether to consider the average or maximum value for warehouse load. If the maximum value exceeds the specified average factor, the average is considered.

Optional

Double

0.3

com.unraveldata.sf.rs.page.size

Specifies the page size for querying the number of records in the pipeline.

Optional

Integer

10000

com.unraveldata.sf.log.events.initial.delay

Specifies the initial delay for updating LOG records in snapshot mode.

Optional

Seconds

60

com.unraveldata.sf.log.events.delay

Specifies the interval for updating LOG records in snapshot mode.

Optional

Seconds

60

com.unraveldata.sf.log.dataload.progress.step

This property specifies the number of records after which LOG data load progress is emitted.

Optional

Integer

1000