Google Ad Manager: Big Query

[skapa06]

How to transfer data transfer files to database? I understand that data transfer files from Google Ad Manager will be as a Google Cloud storage bucket for the network code in GAM, but that is in CSV format. How do we take the csv and store it in a database in a relational database? Do we have to use the google cloud api to store the data in a relational database in Google Cloud or does the data from google cloud store the data in JSON so we would need to store in non relational db?

Bigquery stores the data in a RDMS correct? 

Links:

https://cloud.google.com/bigquery-transfer/docs/doubleclick-publisher-transfer

https://support.google.com/admanager/answer/1733124?hl=en&ref_topic=3038164 

[Eduardo_Ortiz]

I would like to suggest you to use BigQuery Data Transfer Service, since it can read data on a scheduled and maintained basis from Google Ads Manager and many other data sources, also BigQuery Data Transfer Service automatically loads the data into BigQuery.

You can read more about the data transfer service in the hyperlink that I shared with you.

And yes, bigquery uses a conventional RDBMS system.

[skapa06]

Does the data in bigquery stay there forever? In other words, if we transfer the data to bigquery, will the data stay there?

Data Transfer files older than 60 days are purged from Ad Manager. If you would like to store your files for longer than the allotted 60 days, we recommend that you either store the files locally or move to a permanent cloud storage solution, which can include an independent Google Cloud Storage account over which you have full control.