ofer_kulka
12/03/2020, 6:30 PMtap facebook-ads
and loader target-snowflake
to pull facebook-ads api data into our data warehouse.
We are running into an error which suggests one or more of the field-names in the table ADS_INSIGHTS__UNIQUE_ACTIONS
cannot be pulled because it begins with a numeric character.
target-snowflake | target_snowflake.exceptions.SnowflakeError: ('Exception writing records', SQLError('Identifier must only contain alphanumerics, or underscores, and start with alphas. Got `a` for `1D_CLICK`',))
In order to bypass the error, we tried to exclude the table from being pulled entirely but the error persists no matter what patterns we try to define in order to exclude the table (meaning the table is pulled regardless of what exclusion syntax we include).
We have configured the tap
the following way (last version):
meltano select --list tap-facebook
Legend:
selected
excluded
automatic
Enabled patterns:
ads_insights_age_and_gender.*
ads_insights_region.*
ads_insights_country.*
ads_insights_platform_and_device.*
ads_insights.engagement_rate_ranking
ads_insights.cost_per_unique_click
ads_insights.reach
ads_insights.inline_link_clicks
ads_insights.account_id
ads_insights.adset_id
ads_insights.video_p50_watched_actions
ads_insights.video_30_sec_watched_actions
ads_insights.date_stop
ads_insights.clicks
ads_insights.video_p25_watched_actions
ads_insights.canvas_avg_view_time
ads_insights.quality_ranking
ads_insights.ad_name
ads_insights.conversion_rate_ranking
ads_insights.outbound_clicks
ads_insights.video_play_curve_actions
ads_insights.unique_inline_link_click_ctr
ads_insights.cost_per_unique_inline_link_click
ads_insights.inline_post_engagement
ads_insights.website_ctr
ads_insights.unique_actions
ads_insights.spend
ads_insights.adset_name
ads_insights.action_values
ads_insights.actions
ads_insights.impressions
ads_insights.canvas_avg_view_percent
ads_insights.unique_clicks
ads_insights.video_p100_watched_actions
ads_insights.account_name
ads_insights.cost_per_action_type
ads_insights.objective
ads_insights.ctr
ads_insights.cpp
ads_insights.ad_id
ads_insights.inline_link_click_ctr
ads_insights.unique_inline_link_clicks
ads_insights.campaign_name
ads_insights.social_spend
ads_insights.cpm
ads_insights.cost_per_inline_link_click
ads_insights.unique_ctr
ads_insights.campaign_id
ads_insights.cost_per_inline_post_engagement
ads_insights.frequency
ads_insights.date_start
ads_insights.unique_link_clicks_ctr
ads_insights.video_p75_watched_actions
ads_insights.cpc
!*.*unique_actions*.*
"table": "ADS_INSIGHTS__UNIQUE_ACTIONS", "status": "failed"
"path": ["ads_insights", "unique_actions"]
Please see the log below: