added telegraf schema to hypertables

UncleGravity · Jul 2, 2023 · 30818f2 · 30818f2
1 parent fede5f3
commit 30818f2
Showing 1 changed file with 8 additions and 0 deletions.
diff --git a/telegraf/telegraf.conf b/telegraf/telegraf.conf
@@ -152,6 +152,14 @@
   #   '''CREATE TABLE {{ .table }} ({{ .columns }})''',
   # ]
 
+  create_templates = [
+    '''CREATE TABLE {{ .table }} ({{ .columns }})''',
+    '''ALTER TABLE {{ .table }} ALTER COLUMN time TYPE timestamp with time zone''',
+    '''SELECT create_hypertable({{ .table|quoteLiteral }}, 'time')''',
+    # '''ALTER TABLE {{ .table }} SET (timescaledb.compress, timescaledb.compress_segmentby = 'tag_id')''',
+    '''SELECT add_retention_policy({{ .table|quoteLiteral }}, INTERVAL '7 days')'''
+  ]
+
   # # Templated statements to execute when adding columns to a table.
   # # Set to an empty list to disable. Points containing tags for which there is no column will be skipped. Points
   # # containing fields for which there is no column will have the field omitted.