publish.gold_bacen/fct_balance_sheet

Comece aqui: guia de acesso aos dados

Readiness (label, not a promise): declared (code) · materialized:unknown until a collector run or publisher check · queryable:unknown until publication

Declared (by code, not by catalog YAML)

field	value
table	fct_balance_sheet
declared_by	ciano_lake/publish/to_postgres.py::GOLD_TABLES
postgres_schema	gold_bacen

This table is part of the declared Postgres publish surface (ciano_lake/publish/to_postgres.py::GOLD_TABLES). It has no catalog entry — materialization and queryable state are publisher facts, filled at publication time.

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

Deep documentation (curated, grounded in the declarations above)

Long-format balance-sheet facts (report_type Resumo/Ativo/Passivo): silver valores joined to silver cadastro on (cod_inst, periodo, tipo_inst). Published to Postgres schema gold_bacen by publish-gold (TRUNCATE + COPY per table, per-table commit — a failed multi-table refresh can leave mixed vintages; check the publication record).

Grain: one row per (institution, quarter, report, column) for balance-sheet reports

Units: inherited from valores (per-column, report-scoped; see valores entry)

Safe-join guidance:

• cadastro_* columns come from the same-period cadastro row — already denormalized; do not re-join cadastro unless you need a different consolidation variant than the one carried in the fact row.

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

from	to	kind	evidence
bacen.instituicoes.ifdata_valores/valores	publish.gold_bacen/fct_balance_sheet	curated	ciano_lake/gold/instituicoes/fcts.py::_materialize_fct

Evidence references:

• ciano_lake/gold/instituicoes/fcts.py
• ciano_lake/publish/to_postgres.py (GOLD_TABLES, per-table commit)