- Home
- Unravel Documentation 4.8.2.x release
- Reference Guide
- Unravel Properties
- Snowflake
- Configure Polling (Snowflake)
Configure Polling (Snowflake)
The following properties can be configured for Polling in Snowflake.
Property/Description | Set by User | Unit | Default |
|---|---|---|---|
com.unraveldata.sf.warehouse Specifies the name of the warehouse allocated to Unravel. | Mandatory | String | - |
com.unraveldata.sf.overwrite.record By default, Unravel loads the data from the last loaded timestamp for each category (R - Realtime, H - History, L - Warehouse Load, and so on). Set this property to true if you want to re-load the data for the configured lookback period. The data is again polled for the configured lookback period. | Optional | Boolean | - |
com.unraveldata.sf.database Specifies the name of the database from which data is polled. | Optional | String | SNOWFLAKE |
com.unraveldata.sf.compute.base.poll.secs Sets the polling interval, in seconds, for warehouses and tables. | Optional | Seconds | 1800 |
com.unraveldata.sf.compute.events.poll.secs Specifies the polling interval, in seconds, for warehouse events. | Optional | Seconds | 900 |
com.unraveldata.sf.compute.load.poll.secs Sets the polling interval in seconds for querying warehouse load tables. | Optional | Seconds | 300 |
com.unraveldata.sf.compute.charge.poll.secs Specifies the polling interval, in seconds, for warehouse charge and metering tables. | Optional | Seconds | 3600 |
com.unraveldata.sf.query.rt.poll.secs Sets the polling interval, in seconds, to poll the real-time query_history (INFORMATION_SCHEMA) table. NoteWhen you configure the com.unraveldata.sf.query.rt.poll.secs property, 10,000 records are polled in the default 60 seconds by the real-time query pipeline (INFORMATION_SCHEMA). In case the polling time is increased, and there are more than 10,000 records, those excess records do not get polled. However, those records are polled in the query_history (ACCOUNT_USAGE) pipeline, which is configured using the com.unraveldata.sf.query.history.poll.secs property. | Optional | Seconds | 60 |
com.unraveldata.sf.query.history.poll.secs Specifies the polling interval, in seconds, for query_history (ACCOUNT_USAGE) table. | Optional | Seconds | 3600 |
com.unraveldata.sf.look.back.days Specifies the maximum number of days to look back when initially polling Snowflake for data. | Optional | Days | 60 |
com.unraveldata.sf.account.usage.poll.latency Sets a delay in polling the Account_Usage information from Snowflake. This introduces latency to ensure queries will not immediately reflect in Account_Usage, similar to real-time data. | Optional | Milli seconds | 900000 |
com.unraveldata.sf.login.account.user.query.enable Enables or disables Snowflake account user-related queries. By default, all user account-level queries are disabled and not shown on the user interface. | Optional | Boolean | False |