https://linen.dev logo
#plugins-general
Title
# plugins-general
o

ofer_kulka

12/03/2020, 6:30 PM
Hi there! My team has run into a strange error, we can't overcome ourselves and would really appreciate your support and help. We are working with the extractor
tap 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.
Copy code
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):
Copy code
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: