Modeling


Topic Replies Activity
About the Modeling category 1 August 31, 2018
Structure Snowflake database, schema 12 April 24, 2019
On the limits of incrementality 7 April 11, 2019
Check if variable exists in dbt 1 April 9, 2019
Should I move my CTEs into separate models? 1 April 3, 2019
Help! I'm seeing "require-dbt-version was unexpected" 1 March 26, 2019
Finding active days for a subscription/user/account (date spining) 1 March 18, 2019
Implementing a Persistent Staging Area with a dynamic incremental model 8 March 6, 2019
Validating the SQL in a Redshift late-binding view 1 December 21, 2018
Looker vs Tableau Online 1 February 13, 2019
Generating Supernatural (Guaranteed Unique) Keys in Snowflake 2 February 10, 2019
Is Kimball dimensional modeling still relevant in a modern data warehouse? 6 February 9, 2019
Preventing name conflicts 5 February 1, 2019
A dbt highlighter for Atom! ⚛️ 5 November 20, 2018
FAQ: Handling timezone conversion (and timestamp truncation) in data warehouses 1 September 27, 2018
How to create group identifiers with repeating grouping criteria? 2 October 30, 2018
How to identify rows in between rows with certain values? 8 September 25, 2018
How to create efficient timeseries models (or how to join efficiently on inequalities) 4 September 21, 2018
Using DBT Archive 3 September 14, 2018
Using window functions in incremental tables 6 September 11, 2018
FAQ: Why aren't my model configurations in my dbt_project.yml file working? 2 September 10, 2018
Refactoring a query by improving the modeling 3 July 1, 2018
Writing queries in a BI tool vs modeling them in dbt 5 June 21, 2018
Using folders inside models 3 May 22, 2018
First few months with dbt - questions on best practices 2 May 16, 2018
Table / field syntax best practices when using Snowflake 3 May 9, 2018
PII Anonymization and DBT 3 May 1, 2018
Use more than one key as unique_key 2 April 26, 2018