Open jeffersonroth opened 7 months ago
Store DWH statistics in metrics db. Redshift: SVV_TABLE_INFO, STV_BLOCKLIST, STV_NODE_STORAGE_CAPACITY, STV_TBL_PERM, STV_SLICES, PG_DATABASE, PG_ATTRIBUTE, PG_CLASS, PG_NAMESPACE, PG_TYPE. Snowflake: https://docs.snowflake.com/en/sql-reference/info-schema/table_storage_metrics https://www.montecarlodata.com/blog-how-to-extract-snowflake-data-observability-metrics-using-sql/ Postgres: https://www.postgresql.org/docs/current/sql-analyze.html https://www.postgresql.org/docs/current/monitoring-stats.html
Store DWH statistics in metrics db. Redshift: SVV_TABLE_INFO, STV_BLOCKLIST, STV_NODE_STORAGE_CAPACITY, STV_TBL_PERM, STV_SLICES, PG_DATABASE, PG_ATTRIBUTE, PG_CLASS, PG_NAMESPACE, PG_TYPE. Snowflake: https://docs.snowflake.com/en/sql-reference/info-schema/table_storage_metrics https://www.montecarlodata.com/blog-how-to-extract-snowflake-data-observability-metrics-using-sql/ Postgres: https://www.postgresql.org/docs/current/sql-analyze.html https://www.postgresql.org/docs/current/monitoring-stats.html