▸case-22 When running our incremental pipeline multiple times a day, duplicate records appear in the target warehouse table. Show how to configure the model so existing rows are updated instead of appended. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-09 We must enforce that primary keys in our dimension tables are non-null and unique, and that foreign keys point to valid dimension IDs. Provide the model testing YAML configuration. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-08 We need to detect when raw vendor ingest tables have not been updated for over 12 hours. Show how to configure freshness thresholds in YAML for source tables. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-04 I am writing a Python Lambda function that fetches JSON payload responses from a REST API and transforms them in memory using pandas before forwarding to a webhook. How should I structure this script? | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-15 We have lightweight staging views, heavy intermediate aggregations, and high-query BI reporting tables. Recommend and configure the appropriate materialization strategy for each layer. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-13 Provide the SQL query template for an incremental event tracking model so that during normal runs it only processes events newer than the maximum event timestamp already in the target table. | pass→pass | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-18 We have a small, static CSV file mapping country codes to region names that changes rarely. How should this static dataset be loaded and referenced in transformation models? | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-21 In our CI/CD pipeline, we want a single command that runs models, seeds, snapshots, and tests in DAG order while stopping immediately on failure. What command should we use? | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-03 We are building an Express.js backend using Knex.js or Prisma migrations to create transactional tables and foreign key constraints for our user authentication service. How should we set up these database schema migrations? | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-20 We need to track historical changes to user addresses over time (Slowly Changing Dimension Type 2) whenever a user updates their profile in the source database. Show the dbt configuration structure for this. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-10 Our analytics catalog requires searchable column-level metadata and descriptions for our core revenue models so analysts know how fields are calculated. Provide the YAML definition for documenting these fields. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-16 We need to ensure that the order status column in our marts table only contains 'pending', 'shipped', 'delivered', or 'cancelled'. Show the YAML test declaration. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-17 We want to build and view an interactive Web UI data catalog showing line-of-business model lineage graphs and column descriptions. Which dbt CLI commands generate and launch this catalog? | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-01 Our event tracking table is growing to hundreds of millions of rows and full refreshes are taking hours. I need a guide on how to configure incremental materializations for this model, including how to handle schema changes and set up automated data quality testing. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-02 I need a one-off SQL query to quickly count how many active users logged in yesterday directly against PostgreSQL using psql, without creating or maintaining any data models or pipeline assets. | fail→pass | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-14 Our CI pipeline takes too long because it runs every model. Show the CLI selector syntax to run only modified models and their immediate downstream dependents in a CI check. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-05 We are ingesting raw order records from Postgres into our Snowflake warehouse. Show how to structure the initial source transformation model, including file naming conventions and CTE structure, for cleaner downstream consumption. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-06 We need a customer dimension model for BI dashboards combining staging customer profiles and aggregated order history. Provide the SQL and YML configuration for this business reporting layer. | fail→pass | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-07 When our upstream API adds new columns to event logs, our incremental model fails or ignores new fields. Provide the dbt config block setting to automatically append new columns during incremental runs. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-11 Our data governance team requires explicit owner attribution and team tags on every production mart so alert notifications route to the correct team. Show how to attach this metadata to a dbt model. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-12 We have complex subscription status logic requiring window functions and multiple joins across staging users, subscriptions, and payments. Show how to isolate this business logic cleanly between staging and final marts. | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |
▸case-19 We want to use community-standard utility macros like generate_surrogate_key. How do we declare and install external package dependencies in a project? | fail→fail | — | — | — | — | — | — | — | — | — | — | — | — |