Which application or service? Spotify Ads

What type of connector? SaaS

Additional details:

Please add ad_set.video_delivery_formats to the Spotify Ads connector.

Destination: fivetran_production.spotify_ads_all_2_years. The ad_set table is syncing, and video_delivery_formats is not a column on it. It is also absent from the published Spotify Ads ERD.

Spotify returns it on the ad set. Values are IN_STREAM and OPT_IN. It applies only to video ad sets, and an ad set can have both. developer.spotify.com/documentation/ads-ap…nce/v3.0/getAdSetById

We need it to tell in-stream video from in-feed video. asset_format only says VIDEO. Clicks campaigns default to IN_STREAM and video-views campaigns default to OPT_IN, but every other video ad set can be either or both, so the goal fields we already sync are not enough.