SKOOR Integration

The StabeleNet FDW can be integrated by creating a new data source in the Data & Objects section.

After saving, the lightbulb in the navigation should turn green.

The foreign tables can be inspected on the Data tab.

While some foreign tables can be inspected right away (e.g. stablenet_taggable_device), others need some mandatory qualifiers and can not be previewed. See table below for mandatory qualifiers.

Foreign Tables

Name	Fields	Qualifiers
`stablenet_info`	`server_id TEXT` `name TEXT` `version TEXT` `technical_version TEXT`
`stablenet_taggable`	`server_id TEXT` `domain TEXT` `id TEXT` `name TEXT` `display_name TEXT` `state TEXT` `attribute_tags JSONB` `custom_tags JSONB` `tag_filter TEXT`	`domain TEXT` (mandatory) `id BIGINT` `tag_filter TEXT`
`stablenet_taggable_device`	`server_id TEXT` `id TEXT` `name TEXT` `display_name TEXT` `state TEXT` `attribute_tags JSONB` `custom_tags JSONB` `tag_filter TEXT`	`id BIGINT` `tag_filter TEXT`
`stablenet_taggable_interface`	`server_id TEXT` `id TEXT` `name TEXT` `display_name TEXT` `state TEXT` `attribute_tags JSONB` `custom_tags JSONB` `tag_filter TEXT`	`id BIGINT` `tag_filter TEXT`
`stablenet_taggable_job`	`server_id TEXT` `id TEXT` `name TEXT` `display_name TEXT` `state TEXT` `attribute_tags JSONB` `custom_tags JSONB` `tag_filter TEXT`	`id BIGINT` `tag_filter TEXT`
`stablenet_taggable_link`	`server_id TEXT` `id TEXT` `name TEXT` `display_name TEXT` `state TEXT` `attribute_tags JSONB` `custom_tags JSONB` `tag_filter TEXT`	`id BIGINT` `tag_filter TEXT`
`stablenet_taggable_service`	`server_id TEXT` `id TEXT` `name TEXT` `display_name TEXT` `state TEXT` `attribute_tags JSONB` `custom_tags JSONB` `tag_filter TEXT`	`id BIGINT` `tag_filter TEXT`
`stablenet_taggable_agent`	`server_id TEXT` `id TEXT` `name TEXT` `display_name TEXT` `state TEXT` `attribute_tags JSONB` `custom_tags JSONB` `tag_filter TEXT`	`id BIGINT` `tag_filter TEXT`
`stablenet_tag_category`	`server_id TEXT` `domain TEXT` `id TEXT` `name TEXT` `description TEXT`	`domain TEXT` (mandatory) `id BIGINT`
`stablenet_measurement`	`server_id TEXT` `id TEXT` `name TEXT` `description TEXT` `tags JSONB` `dest_device_id TEXT` `dest_interface_id TEXT` `agent_id TEXT` `start_time TIMESTAMPTZ` `end_time TIMESTAMPTZ` `state TEXT` `type TEXT` `template_name TEXT` `permanent BOOL` `payload JSONB` `active BOOL` `tag_filter TEXT`	`tag_filter TEXT` `dest_device_id BIGINT`
`stablenet_measurement_metric`	`server_id TEXT` `measurement_id TEXT` `data_id BIGINT` `description TEXT` `expected_interval INT` `key TEXT` `name TEXT` `only_average BOOL` `unit TEXT`	`measurement_id BIGINT`
`stablenet_measurement_data`	`server_id TEXT` `measurement_id TEXT` `metric_key TEXT` `metric_name TEXT` `"start" TIMESTAMPTZ` `"end" TIMESTAMPTZ` `bucket_size INT` (seconds) `"timestamp" TIMESTAMPTZ` `min double precision` `max double precision` `avg double precision` `tag_filter TEXT`	`measurement_id BIGINT` `metric_key TEXT` `"start" TIMESTAMPTZ` (mandatory) `"end" TIMESTAMPTZ` (mandatory) `bucket_size INT` (mandatory) `tag_filter TEXT`

Although measurement_id and metric_key are optional, it’s not recommended to execute queries without. Doing so reads measurement data of all measurements and all metrics which might take a long time to read and puts some heavy load on the StableNet server. Only advisable for very short time ranges < 1h. If multiple measurements and metrics are needed, tables stablenet_measurement_data_... should be used.

Aggregated measurement data

Aggregated in different bucket sizes. Can be used to perform analytics queries over a wide range of measurements and over large time ranges.

Are basically Timescale hypertables (https://docs.timescale.com/ ).

Name	Fields
`stablenet_measurement_data_[minutely \| 5_minutely \| 15_minutely]`	`server_id TEXT` `measurement_type TEXT` `measurement_id TEXT` `metric_key TEXT` `"timestamp" TIMESTAMPTZ NOT NULL` `value_min double precision` `value_max double precision` `value_avg double precision`
`stablenet_measurement_data_[hourly \| daily \| weekly \| monthly \| quarterly \| yearly]`	`server_id TEXT` `measurement_type TEXT` `measurement_id` `metric_key TEXT` `timestamp TIMESTAMPTZ` `stats_agg STATSSUMMARY2D` `stats_agg_max STATSSUMMARY2D` `percentile_agg UDDSKETCH` `percentile_agg_max UDDSKETCH`