Executing SQL commands in the United Manufacturing Hub?
How to execute SQL commands on TimescaleDB using the Shell?
less than a minute
Instructions
First you need to be connected via UMHLens to the United Manufacturing Hub
Go to Pods and select the timescaledb pod


Open the pod shell


Execute the following commands:
psql
b.
\c factoryinsight
c. The SQL commands, e. g. the following commands fix a bug in in older version that processValues do not show up in Grafana (it may take some time until you can enter the next command):

d.
exit
Last modified February 17, 2023: update (#208) (ea731fc)