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
...
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 ( uuidmsg_id varchar ,msg_topic varchar ,namespace varchar ,group_id varchar ,msgmessage_type varchar ,edge_node_id varchar ,device_id varchar ,msg variant ,inserted_at number ) change_tracking = true cluster by (msgmessage_type ,group_id ,edge_node_id ,device_id) comment = 'Used for storing json messages from sparkplug bridge/gateway' ; |
...