TimescaleDB utility

Telemetry metrics stored in a timescaleDB can be copied locally in a csv format. This file can be used to generate insights into key statistics in your cluster.

To customize the local copy of the timescale DB, fill out the below parameters in utils/timescaledb_utility/timescaledb_utility_config.yml.

Parameter	Details
column_name string Optional	Filters timescaleDB data by metric name and value. If this value is not provided, all metrics and their corresponding values will be stored in the file.
column_value string Optional	Filters timescaleDB data by metric name and value. If this value is not provided, all metrics and their corresponding values will be stored in the file.
start_time string Optional	Filters timescaleDB data by time of polling. If this value is not provided, all metric values collected will be stored.
stop_time string Optional	Filters timescaleDB data by time of polling. If this value is not provided, all metric values collected will be stored.
filename string Required	Target filepath where all timescaleDB will be backed up.

To initiate the backup to local file, run the following ansible playbook:

cd utils/timescaledb_utility
ansible-playbook timescaledb_utility.yml

If you have any feedback about Omnia documentation, please reach out at omnia.readme@dell.com.