get-select/dbt-snowflake-monitoring

Issues

• Replace `service_type = 'COMPUTE'` filters with `service_type = 'WAREHOUSE_METERING'` due to Snowflake backend change

  #150 opened 2 months ago by stumelius
  4

• Probably broken after latest changes in RATE_SHEET_DAILY

  #149 opened 2 months ago by littleK0i
  1

• Empty records in `query_history_enriched.sql` and `dbt_queries.sql`

  #145 opened 3 months ago by zhuohanl
  1

• Query comment not parsed in query_history_enriched

  #147 opened 3 months ago by grahamwetzler
  1

• Overwriting the source macro

  #146 opened 3 months ago by gperronegofundme
  0

• `dbt_queries` incremental fails unique key (dupes in stg_query_history)

  #144 opened 4 months ago by austintidmoreplace
  6

• Limit on fill-refresh history date

  #131 opened 6 months ago by smitsrr
  5

• ❓ Question around query_tag configuration

  #132 opened 6 months ago by bdtoole
  3

• Aliasing table reference in cost_per_query and hourly_spend models

  #133 opened 6 months ago by saurasingh
  3

• Add in Snowflake's new `query_parameterized_hash` column

  #136 opened 7 months ago by sidhreddy
  3

• Seeking Help with Implementation Deps + Recursion errors

  #126 opened 8 months ago by sfc-gh-rbacastow
  1

• Is there a way to only load the current month/year data from snowflake?

  #130 opened 8 months ago by albertwangnz
  4

• Bug on comment for dynamic tables

  #129 opened 9 months ago by kaarthik108
  0

• Add credit consumption to cost per query

  #65 opened a year ago by ian-whitestone
  6

• maximum recursion depth exceeded while calling a Python object

  #122 opened a year ago by sfc-gh-rkato
  5

• Filter all inputs in daily_rates to the same max date

  #101 opened a year ago by ian-whitestone
  1

• Package errors when quoting=true

  #52 opened a year ago by cristianivanoff
  2

• Column Name mismatch in query_direct_table_access docs

  #117 opened a year ago by kirk-dave
  4

• Add WAREHOUSE_METERING_READER to daily_spend

  #115 opened a year ago by NiallRees
  0

• Compiled SQL errors

  #111 opened a year ago by sakce
  9

• Max LOB size (16777216) exceeded in example query for top 10 costliest queries in the last 30 days

  #112 opened a year ago by pratik60
  1

• Compilation errors with dbt-core v1.5.0

  #102 opened a year ago by aleix-cd
  3

• Cost Currency

  #99 opened a year ago by calleo
  1

• Silly Question: How do you create the models with the query data?

  #94 opened a year ago by dweaver33
  2

• Stale daily rates holds up daily_spend model

  #76 opened a year ago by ian-whitestone
  0

• Using this package in a non-organization account

  #85 opened a year ago by jelledv
  4

• Specify schema to place dbt-snowflake-monitoring objects

  #93 opened a year ago by mjahammel
  3

• dbt_queries.sql - Unknown functions VAR, VAR

  #89 opened a year ago by rossserven
  2

• Cater for https://emea.dbt.com/ dbt server in dbt_queries model

  #79 opened a year ago by jesska-f
  1

• Exclude stored procedures from attributed query costs?

  #86 opened a year ago by ian-whitestone
  0

• Query History Enriched doesn't work with a custom target schema

  #82 opened a year ago by PedramNavid
  1

• Attribute "adj for cloud services credits" to warehouses

  #49 opened a year ago by NiallRees
  0

• Remove dependency on dbt-utils

  #53 opened a year ago by ian-whitestone
  0

• Add thread_id to query comment macro

  #74 opened a year ago by ian-whitestone
  0

• daily_rates not handling Organisation with duplicate account_locator

  #81 opened a year ago by seediang
  1

• Different usage of daily_rates in daily_spend vs cost_per_query

  #75 opened a year ago by john-jerome
  1

• First time compile fails

  #69 opened a year ago by alanmcruickshank
  0

• Improve freshness of cost_per_query and query_history_enriched models

  #57 opened a year ago by ian-whitestone
  0

• Incrementalize cost per query

  #41 opened a year ago by ian-whitestone
  2

• Add note about gitlab package & our package maintenance

  #51 opened a year ago by ian-whitestone
  0

• Properly account for overage rates

  #55 opened a year ago by ian-whitestone
  5

• Add note about how you can just use the query comment macro from this package

  #56 opened a year ago by ian-whitestone
  0

• Discrepancy in compute spend on the day the account entered overage

  #60 opened a year ago by ian-whitestone
  0

• Add docs/blurb about accuracy against Snowflake bill

  #50 opened a year ago by ian-whitestone
  0

• Create new model(s) for dbt performance monitoring

  #46 opened a year ago by ian-whitestone
  0

• Models for organization_usage

  #44 opened a year ago by GtheSheep
  1

• Package not working

  #45 opened a year ago by lijol
  2

• Incrementalize warehouses_type2_dimension

  #42 opened a year ago by ian-whitestone
  0

• Testing and alerting

  #38 opened a year ago by matt-winkler
  4

• Improve query workload identification

  #39 opened a year ago by ian-whitestone
  0