Tag: Snowflake
All the articles with the tag "Snowflake".
-
Building a member-month churn panel in dbt without leaking the future
Turn eligibility, medical and pharmacy claims into a leak-free member-month training table for disenrollment prediction, with dbt tests and Snowflake ML.
-
Snowflake SSO from the terminal: CLI, dbt Core and DBeaver
One Entra ID SSO login, cached for 4 hours and shared by the Snowflake CLI, dbt Core and DBeaver. The errors on the way and the config that fixed them.
-
Connecting Clinical and Operational Data to Tuva with dbt
How to map EHR and operational sources into the Tuva Input Layer with dbt, and where to join what Tuva does not model.
-
Where Agents Schema fits in a dbt → Snowflake → Looker pipeline
Agents Schema doesn't replace dbt, semantic views or LookML. It indexes them inside the warehouse for agents. Where it fits, what it costs, when to skip it.
-
What's new in cms_hcc v1.0.0: the payer grain fix nobody's docs warned you about
cms_hcc v1.0.0 fixes a silent grain mismatch between int_members and int_disease_factors that dropped every disease factor for members who switched payers mid-year.
-
Load data from Snowflake to S3
If you want to load data from Snowflake to S3 should try to use the COPY INTO command so, you run something like this command in the snowflake Web App: copy into @my_ext_unload_stage/d1 from mytable;