Index

_

__init__() (dwh_auditor.extractor.bigquery.BigQueryExtractor method)

A

access_count_30d (dwh_auditor.models.result.TableUsageProfile attribute) active_logical_bytes (dwh_auditor.models.table.TableStorage attribute) analyze_cost() (in module dwh_auditor.analyzer.cost) analyze_recurring_cost() (in module dwh_auditor.analyzer.recurring)

analyze_table_usage() (in module dwh_auditor.analyzer.zombie) analyzed_days (dwh_auditor.models.result.AuditResult attribute) AppConfig (class in dwh_auditor.config) AuditResult (class in dwh_auditor.models.result)

B

BigQueryExtractor (class in dwh_auditor.extractor.bigquery)

C

cache_hit (dwh_auditor.models.job.QueryJob attribute)

CostInsight (class in dwh_auditor.models.result) creation_time (dwh_auditor.models.job.QueryJob attribute)

D

dataset_id (dwh_auditor.models.table.TableStorage attribute) dbt (dwh_auditor.config.AppConfig attribute) DbtConfig (class in dwh_auditor.config) detect_full_scans() (in module dwh_auditor.analyzer.scan) dwh_auditor.analyzer.cost module dwh_auditor.analyzer.recurring module dwh_auditor.analyzer.runner module dwh_auditor.analyzer.scan module dwh_auditor.analyzer.zombie module dwh_auditor.config module

dwh_auditor.extractor.bigquery module dwh_auditor.models.job module dwh_auditor.models.result module dwh_auditor.models.table module dwh_auditor.reporter.console module dwh_auditor.reporter.json_out module dwh_auditor.reporter.markdown module

E

enabled (dwh_auditor.config.DbtConfig attribute)

estimated_cost_usd (dwh_auditor.models.result.CostInsight attribute) execution_count (dwh_auditor.models.result.RecurringCostInsight attribute)

F

full_scan_ratio_threshold (dwh_auditor.config.ThresholdsConfig attribute) full_scans (dwh_auditor.models.result.AuditResult attribute)

full_table_id (dwh_auditor.models.table.TableStorage property) FullScanInsight (class in dwh_auditor.models.result)

G

generate_json_report() (in module dwh_auditor.reporter.json_out) generate_markdown_report() (in module dwh_auditor.reporter.markdown) get_heavy_scan_jobs() (dwh_auditor.extractor.bigquery.BigQueryExtractor method)

get_recurring_cost_jobs() (dwh_auditor.extractor.bigquery.BigQueryExtractor method) get_table_storage() (dwh_auditor.extractor.bigquery.BigQueryExtractor method) get_table_usage_stats() (dwh_auditor.extractor.bigquery.BigQueryExtractor method) get_top_cost_jobs() (dwh_auditor.extractor.bigquery.BigQueryExtractor method)

I

ignore_full_scan_under_gb (dwh_auditor.config.ThresholdsConfig attribute)

is_zombie (dwh_auditor.models.result.TableUsageProfile attribute)

J

job (dwh_auditor.models.result.CostInsight attribute) (dwh_auditor.models.result.FullScanInsight attribute)

job_id (dwh_auditor.models.job.QueryJob attribute) job_label_key (dwh_auditor.config.DbtConfig attribute)

L

last_accessed_at (dwh_auditor.models.result.TableUsageProfile attribute)

last_executed_at (dwh_auditor.models.result.RecurringCostInsight attribute) load_config() (in module dwh_auditor.config)

M

model_config (dwh_auditor.config.AppConfig attribute) (dwh_auditor.config.DbtConfig attribute) (dwh_auditor.config.PricingConfig attribute) (dwh_auditor.config.ThresholdsConfig attribute) (dwh_auditor.models.job.QueryJob attribute) (dwh_auditor.models.result.AuditResult attribute) (dwh_auditor.models.result.CostInsight attribute) (dwh_auditor.models.result.FullScanInsight attribute) (dwh_auditor.models.result.RecurringCostInsight attribute) (dwh_auditor.models.result.TableUsageProfile attribute) (dwh_auditor.models.table.TableStorage attribute) module dwh_auditor.analyzer.cost dwh_auditor.analyzer.recurring dwh_auditor.analyzer.runner dwh_auditor.analyzer.scan dwh_auditor.analyzer.zombie dwh_auditor.config dwh_auditor.extractor.bigquery dwh_auditor.models.job dwh_auditor.models.result dwh_auditor.models.table dwh_auditor.reporter.console dwh_auditor.reporter.json_out dwh_auditor.reporter.markdown

P

pricing (dwh_auditor.config.AppConfig attribute) PricingConfig (class in dwh_auditor.config)

print_to_console() (in module dwh_auditor.reporter.console) project_id (dwh_auditor.models.result.AuditResult attribute) (dwh_auditor.models.table.TableStorage attribute)

Q

query (dwh_auditor.models.job.QueryJob attribute) query_hash (dwh_auditor.models.result.RecurringCostInsight attribute)

query_sample (dwh_auditor.models.result.RecurringCostInsight attribute) QueryJob (class in dwh_auditor.models.job)

R

recurring_expensive_queries (dwh_auditor.models.result.AuditResult attribute) RecurringCostInsight (class in dwh_auditor.models.result)

referenced_tables (dwh_auditor.models.job.QueryJob attribute) run_analysis() (in module dwh_auditor.analyzer.runner)

S

scanned_gb (dwh_auditor.models.result.FullScanInsight attribute) scanned_tb (dwh_auditor.models.result.CostInsight attribute)

size_gb (dwh_auditor.models.result.TableUsageProfile attribute) statement_type (dwh_auditor.models.job.QueryJob attribute)

T

table (dwh_auditor.models.result.TableUsageProfile attribute) table_id (dwh_auditor.models.table.TableStorage attribute) table_profiles (dwh_auditor.models.result.AuditResult attribute) TableStorage (class in dwh_auditor.models.table) TableUsageProfile (class in dwh_auditor.models.result) tb_scan_usd (dwh_auditor.config.PricingConfig attribute) thresholds (dwh_auditor.config.AppConfig attribute) ThresholdsConfig (class in dwh_auditor.config) top_expensive_queries (dwh_auditor.models.result.AuditResult attribute)

top_expensive_queries_limit (dwh_auditor.config.ThresholdsConfig attribute) top_users (dwh_auditor.models.result.TableUsageProfile attribute) total_bytes_billed (dwh_auditor.models.job.QueryJob attribute) total_estimated_usd (dwh_auditor.models.result.RecurringCostInsight attribute) total_jobs_analyzed (dwh_auditor.models.result.AuditResult attribute) total_logical_bytes (dwh_auditor.models.table.TableStorage attribute) total_physical_bytes (dwh_auditor.models.table.TableStorage attribute) total_scanned_tb (dwh_auditor.models.result.RecurringCostInsight attribute) total_tables_analyzed (dwh_auditor.models.result.AuditResult attribute)

U

user_email (dwh_auditor.models.job.QueryJob attribute)

Z

zombie_table_days (dwh_auditor.config.ThresholdsConfig attribute)