Hi, Using the Snapchat connector together with Big...
# replication-troubleshooting
o
Hi, Using the Snapchat connector together with BigQuery I seem to be missing some Ad IDs in the "ads" table vs the "ads_stats_daily" table.
Which means I'm unable to join the daily ads ID with ad name, ad set name and campaign names. All very crucial for reporting. Am I just on the wrong track or is this an issue more have ran into?
a
hey you can join it using _airbyte_ads_hashid
u
Hello Ola Sehlen, Are you still having problems or did you find a solution?
o
@Saj Dider (Airbyte) Hi, This issue occurred when I just fetched from 2023 for testing (and that issue remains) However, when I set up a new connector to fetch data from 2022 it successfully populated the ads table with all ads. So either it was just a random issue with the first connector. Or the fact that I pulled data for a longer period (longer than any ads were active) with the second did actually magically help.
TL;DR: The issue remains, but I dont need it to be fixed any longer
u
Thanks Ola, good to have a report of this in case users in the future report similar problems when fetching data from 2023.