Skip to content

clickhouse.lake/if_financeiros_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_financeiros_periodo
declared_by ciano_lake/gold/instituicoes/analitico.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)

Analytical IF.DATA financials, one row per institution and quarter. Identity + 81 curated metrics x 2 blocks (own, unsuffixed; _grupo = prudential conglomerate via cod_conglomerado_prudencial with per-metric own fallback) + _reportado for de-cumulated flows. Each metric is resolved PER METRIC across escopos (prudencial > financeiro > individual) so the AA..H history (financeiro) sits beside C1..C5 (prudencial). Served as a ClickHouse view over Parquet.

Grain: one row per (instituicao_id, periodo)

Units: BRL reais for monetary columns (NOT R$ mil); ratios are fractions (0.15 = 15%); perda_esperada_operacoes_credito is a contra-asset (negative); NULL = absent, never zero

Safe-join guidance:

  • Join if_indicadores_periodo / if_cobertura_periodo on (instituicao_id, periodo).
  • A _grupo column falls back to the own value per metric — check fonte_grupo / tem_grupo before reading it as a group fact; do not sum _grupo across siblings.

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

from to kind evidence
bacen.instituicoes.ifdata_valores/valores clickhouse.lake/if_financeiros_periodo curated ciano_lake/gold/instituicoes/analitico.py::_materialize_financeiros

Evidence references:

  • ciano_lake/gold/instituicoes/analitico.py
  • ciano_lake/gold/instituicoes/kpi_dictionary.yml (metric -> report_type/col_name)