Skip to content

clickhouse.lake/if_confiabilidade_periodo

Comece aqui: guia de acesso aos dados

Readiness (label, not a promise): declared (code) · materialized:gold-if / gold-confiabilidade build · queryable:ClickHouse view over Parquet

Declared (by code, not by catalog YAML)

field value
table if_confiabilidade_periodo
declared_by ciano_lake/gold/instituicoes/confiabilidade.py
clickhouse_schema lake

This table is part of the declared ClickHouse gold surface (lake schema): a view over the Parquet materialized by the gold builder (ciano_lake/gold/instituicoes/). It has no catalog entry — materialization is a build fact, queryable state is a ClickHouse fact.

Explore in Metabase: https://bi.cianoinvestimentos.space (internal, Tailscale-only).

Deep documentation (curated, grounded in the declarations above)

Credit-reliability scorecard — the analyst "goto" table for how trustworthy an institution is to honour its credit (CDB/LF/LCI/debentures; institutional funds, so FGC is out of scope). Interpretable and decomposable: peer percentiles (q_, 100=best) within a familia x porte peer group + absolute regulatory caps (Res. CMN 4.958/4.955/4.957/4.615, Res. BCB 352). Levels + trends (d_, the "video") + pillar subscores + score_confiabilidade (0-100) + faixa_confiabilidade (A..E) + bank_zscore. NOT a black-box model. Insufficient coverage publishes score=NULL + flag, never a false band. Capital/quality default to the _grupo prudential block so issuers are gradable.

Grain: one row per (instituicao_id, periodo), 1:1 with if_financeiros_periodo

Units: ratios fractions; d_ in % (stocks) or pp (ratios); q_ and score 0-100; faixa_confiabilidade A..E (NULL = insufficient coverage, not "worst")

Safe-join guidance:

  • Read faixa_confiabilidade with cobertura_score; a NULL band means 'no data', not 'E'. Cross-check if_observacoes_periodo for flags before acting on a score.
  • cet1_gap (basileia - CET1) signals reliance on non-core capital; a _grupo value may back the issuer — see fonte_capital/fonte_qualidade.

Curated, evidence-backed lineage (not Bruin ordering):

from to kind evidence
clickhouse.lake/if_financeiros_periodo clickhouse.lake/if_confiabilidade_periodo derived ciano_lake/gold/instituicoes/confiabilidade.py::_build_base
clickhouse.lake/if_indicadores_periodo clickhouse.lake/if_confiabilidade_periodo derived ciano_lake/gold/instituicoes/confiabilidade.py (roa/roe/pl_sobre_ativo)
clickhouse.lake/if_cobertura_periodo clickhouse.lake/if_confiabilidade_periodo curated ciano_lake/gold/instituicoes/confiabilidade.py (tem_/fam_)

Evidence references:

  • ciano_lake/gold/instituicoes/confiabilidade.py
  • ciano_lake/gold/instituicoes/scoring.yml (weights, bands, caps, peer groups)
  • docs/methodology/if-confiabilidade-scoring.md (methodology + references)