Hampus Sandén
01/26/2023, 11:42 AMI am using the Open Source Airbyte running on GCP to retrieve data from Bing Ads. Right now, I am retrieving all client accounts' data. How do I choose specific accounts when doing that?
Here in this website in the Requirement (Bing Ads - Airbyte Documentation)
I can choose whether to retrieve from all accounts or specific accounts, but when I am setting up the Bing Ads as a source connector, I don't see any options… Please help
Have anyone encountered this?Hampus Sandén
01/31/2023, 9:08 AMuser
02/01/2023, 4:32 PM<https://github.com/airbytehq/airbyte/blob/8531530016e3f2fc4aee206316b5319e566452c3/airbyte-integrations/connectors/source-bing-ads/source_bing_ads/source.py#L141connector> code and it looks like the accounts stream pulls all accounts that the current authenticated user can access (and reuses the data for campaigns, so this can't easily be modified)
You could look into using SQL or dbt to transform the data after it's loaded into your destination, Airbyte has a three part tutorial: <https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-sql>
Let me know if the above helps!