@kapa.ai I already have a stream for google ads ad_group, I’m going to add a custom query in my source to collect a few extra data in the destination: metrics.cpc, metrics.cpm, etc… do I have to add those columns to the destination table prior to refreshing the schema? and can I add 2 streams for the same destination table?

You can add additional streams for Google Ads using custom queries. The Google Ads Query Language queries the Google Ads API. You can review the Google Ads Query Language and the query builder to validate your query. Then, you can add these as custom queries when configuring the Google Ads source. Here's an example of a GAQL custom query:

sql SELECT       campaign.name,       metrics.conversions,       metrics.conversions_by_conversion_date   FROM ad_group

[source](https://docs.airbyte.com/integrations/sources/google-ads#custom-query-understanding-google-ads-query-language) If you include

segments.date

in the

SELECT

clause, it will be automatically added to the

WHERE

clause. Custom reports including

segments.date

in the

SELECT

clause will be synced by day. Each custom query in the input configuration must work for all the customer account IDs. Otherwise, the customer ID will be skipped for every query that fails the validation test. When you are updating or removing Custom GAQL Queries, you should also subsequently refresh your source schema to pull in any changes. [source](https://docs.airbyte.com/integrations/sources/google-ads#custom-query-understanding-google-ads-query-language) As for your question about adding columns to the destination table prior to refreshing the schema, it's not explicitly mentioned in the provided sources. However, typically in data integration, the schema refresh would be responsible for updating the structure of the destination table to match the source, including adding new columns. Regarding having two streams for the same destination table, it's not clear from the provided sources if this is possible with Airbyte. However, a user in the Airbyte forum had a similar question about writing data from the same stream to two different tables. It might be worth exploring if a similar approach could be used to write data from two different streams to the same table. [source](https://discuss.airbyte.io/t/2728) Please note that these are general guidelines and the exact steps may vary depending on your specific setup and requirements. Always refer to the official Airbyte documentation and resources for the most accurate and up-to-date information.