Learn Data Build Tools ( DBT )/

...

/

Solution: Loop Through a List of Columns

Solution: Loop Through a List of Columns

Get a detailed review of the solution to the “Loop Through a List of Columns” 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: Looping through a list of columns

Code explanation

    ...