Column medicare.qc_admissions.NumDistinctBeneficaries Lineage SVG

medicare.qc_admissions.NumDistinctBeneficaries medicare.qc_admissions.NumDistinctBeneficaries (#(hll_add_agg(bene)))::BIGINT medicare.qc_adm_union.bene medicare.qc_adm_union.bene HLL hash (see https://en.wikipedia.org/w iki/HyperLogLog). Can be used to calculate number of beneficiaries satisfying a certain given condition Use #(hll_add_agg(bene)) or hll_cardinality(hll_add_agg(bene)) aggregator GENERATED ALWAYS AS (hll_hash_text(bene_id)) STORED medicare.qc_adm_union.bene->medicare.qc_admissions.NumDistinctBeneficaries  Transformed medicare.admissions.bene_id medicare.admissions.bene_id medicare.admissions.bene_id->medicare.qc_adm_union.bene Copied medicare.ip.bene_id medicare.ip.bene_id medicare.ip.bene_id->medicare.admissions.bene_id Copied medicare.ip.bene_id_parent 8 incoming links (columns) medicare.ip.bene_id_parent->medicare.ip.bene_id medicare.enrollments.bene_id medicare.enrollments.bene_id medicare.enrollments.bene_id->medicare.admissions.bene_id Copied medicare._enrollments.bene_id medicare._enrollments.bene_id medicare._enrollments.bene_id->medicare.enrollments.bene_id Copied medicare._ps.bene_id medicare._ps.bene_id medicare._ps.bene_id->medicare._enrollments.bene_id  Aggregated On bene_id, year, state medicare._beneficiaries.bene_id medicare._beneficiaries.bene_id medicare._ps.bene_id->medicare._beneficiaries.bene_id  Aggregated On bene_id medicare.ps.bene_id medicare.ps.bene_id medicare.ps.bene_id->medicare._ps.bene_id Copied medicare.ps.bene_id->medicare._ps.bene_id Copied medicare.ps.bene_id_parent 8 incoming links (columns) medicare.ps.bene_id_parent->medicare.ps.bene_id medicare.ps.bene_id_parent->medicare.ps.bene_id medicare.beneficiaries.bene_id medicare.beneficiaries.bene_id medicare.beneficiaries.bene_id->medicare.enrollments.bene_id Copied medicare._beneficiaries.bene_id->medicare.beneficiaries.bene_id Copied