Learn Data Build Tools ( DBT )/

...

/

Solution: Daily Incrementation

Solution: Daily Incrementation

Get a detailed review of the solution to the “Daily Incrementation” challenge.

We'll cover the following...

Solution

Let’s review the solution to the problem.

shop:
  outputs:
    dev:
      dataset: {{dataset_name}}
      job_execution_timeout_seconds: 300
      job_retries: 1
      keyfile: credentials.json
      location: {{dataset_location}}
      method: service-account
      priority: interactive
      project: {{project_id}}
      threads: 1
      type: bigquery
  target: dev
# Enter your new profile here
Solution code: Building a daily incremental model

  • Line 3: To make our table incremental, we specify the value materialized="incremental" ...