Hi @Nick Mitchum! You could try using the schema setting.

- name: target-bigquery
  config:
    project: buyerbridge-data-warehouse
    dataset: dataCheck
    location: US
    credentials_path: $MELTANO_PROJECT_ROOT/client_secrets.json
    flattening_enabled: true
    flattening_max_depth: 2
    denormalized: true
    schema:
      adsinsights_default:
        clicks:
          type: [ "integer", "null" ]

Like this? Checking my bigquery db the clicks column is still a string. Maybe the stream_id is wrong?