clickhouse.lake/if_indicadores_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_indicadores_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)
Derived, explainable ratios per institution and quarter (own + _grupo): pl_sobre_ativo, alavancagem, roa, roe, credito_sobre_depositos, liquidez_sobre_depositos, capital_principal_sobre_rwa, perda_esperada_sobre_carteira, participacao_c1..c5, etc. No score/ranking.
Grain: one row per (instituicao_id, periodo)
Units: ratios are fractions; numerator and denominator always from the same block
Safe-join guidance:
- A NULL or zero denominator yields NULL (never zero) — do not COALESCE to 0.
Curated, evidence-backed lineage (not Bruin ordering):
| from | to | kind | evidence |
|---|---|---|---|
clickhouse.lake/if_financeiros_periodo |
clickhouse.lake/if_indicadores_periodo |
derived | ciano_lake/gold/instituicoes/analitico.py::_ratio_sql |
Evidence references:
ciano_lake/gold/instituicoes/analitico.py::_materialize_indicadores