• Docs
Show / Hide Table of Contents
  • Introduction
  • OneSense.io
    • Login
    • Home page
    • GeoConfiguration
      • Regions
      • Locations
    • Devices
      • Device Profiles
      • Devices
      • Device Config
      • Device Groups
      • Pump Controller
      • Device Anomalies
    • Dashboards
      • Dashboards
      • Dashboard Templates
    • Operations
      • Rules
      • Sliding Window Rules
      • Timer Rules
      • Snowflake Rules
      • Alerts
      • Actions
      • Device Updates
    • Assets
    • Administration
      • Users
      • Roles
      • Subscription
      • Settings
  • OneSense BLE Application
    • OneSense BLE App
  • OneSense Monitoring Station
    • Assembly Guide

Snowflake Rules


Exporting Devices Data to Snowflake


Alt Text
Step 1 : Open the Operations component from the sidebar and click on Export.

Export Location


Alt Text
Step 2 : The Snowflake Rules page will open, listing all existing Snowflake rules with details like Device Name, Start Timestamp, Last Processed Timestamp, and Status (New Entry, Completed, Running).

Snowflake Rules List


Creating a New Snowflake Rule

Alt Text
Step 3 : Click on the Create New Snowflake button on the Snowflake Rules page.

Create New Snowflake


Alt Text
Step 4 : Select the devices you want to export. After selecting devices, a control box will appear with Device, Multiple Devices, Snowflake, and Action controls to configure the rule.

Snowflake Rule Controls


Alt Text
Step 5 : Fill in the Snowflake rule details:
  1. Select the Device and relevant Telemetries to be exported.
  2. If multiple devices are selected, choose the Multiple Devices option to group them.
  3. Configure the Snowflake export settings (such as database, schema, table, etc.).
  4. Add an Action to determine whether the export should start immediately or later.

Filled Snowflake Rule


Multiple Devices Grouping


Filled Snowflake Rule


Editing or Deleting a Snowflake Rule

Alt Text
Step 6 : To edit or delete a Snowflake rule, navigate to the Snowflake Rules page. Click on the settings (three dots) for the desired rule and select Edit or Delete.

Edit Delete Snowflake


Previous
Timer Rules
Next
Alerts