Contents
Cirrus Link Resources
Cirrus Link Website
Contact Us (Sales/Support)
Forum
Cirrus Link Modules Docs for Ignition 7.9.x
Inductive Resources
Ignition User Manual
Knowledge Base Articles
Inductive University
Forum
...
Copy and paste the following SQL script into the center pane. Click the 'expand' button on the right to
Code Block | ||||
---|---|---|---|---|
| ||||
-- ========================= -- In this script, we are setting up assets related to the staging database -- and associated assets. These are: -- - Database -- - Staging schema -- The database & schema will be owned by SYSADMIN -- REPLACE THE SESSION VARIABLE ACCORDING TO YOUR ENVIRONMENT -- ========================= set cl_bridge_staging_db = 'CL_BRIDGE_STAGE_DB'; set staging_schema = 'stage_db'; -- >>>>>>>>>>>>>>>>>>>>>> DATABASE >>>>>>>>>>>>>>>>>>>>>>>>> use role sysadmin; create database if not exists identifier($cl_bridge_staging_db) -- DATA_RETENTION_TIME_IN_DAYS = 90 -- MAX_DATA_EXTENSION_TIME_IN_DAYS = 90 comment = 'used for storing messages received from CirrusLink Bridge' ; -- >>>>>>>>>>>>>>>>>>>>>> STAGING SCHEMA >>>>>>>>>>>>>>>>>>>>>>>>> use database identifier($cl_bridge_staging_db); create schema if not exists identifier($staging_schema) with managed access -- data_retention_time_in_days = 90 -- max_data_extension_time_in_days = 90 comment = 'Used for staging data direct from CirrusLink Bridge'; -- >>>>>>>>>>>>>>>>>>>>>> STAGING SCHEMA ASSETS >>>>>>>>>>>>>>>>>>>>>>>>> use schema identifier($staging_schema); -- ========================= -- Define tables -- ========================= create or replace table sparkplug_raw ( uuid varchar ,msg_topic varchar ,namespace varchar ,group_id varchar ,msg_type varchar ,edge_node_id varchar ,device_id varchar ,msg variant ,inserted_at number ) change_tracking = true cluster by (msg_type ,group_id ,edge_node_id ,device_id) comment = 'Used for storing json messages from sparkplug bridge/gateway' ; |
...