Source Facebook Marketing: wrong type for field (normalization fails)

[m-ronchi]

instant_experience_outbound_clicks is declared as integer, but actual data is a JSON array (see FB docs).

this results in an error during normalization:

Database Error in model ads_insights_scd (models/generated/airbyte_tables/airbyte/ads_insights_scd.sql)
  Invalid digit, Value '[', Pos 0, Type: Long 
  DETAIL:  
    -----------------------------------------------
    error:  Invalid digit, Value '[', Pos 0, Type: Long 
    code:      1207
    context:   [{"action_destination":"<redacted>","action_target_id":"<redacted>","action_type":"outbound_click","value":"155"}]
    query:     5594855
    location:  :0
    process:   query19_106_5594855 [pid=0]
    -----------------------------------------------
  compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_tables/airbyte/ads_insights_scd.sql

[m-ronchi]

additional issues I found:

• video_play_actions should be a "$ref": "ads_action_stats.json"
• all date fields should be "format": "date" instead of date-time