Can Google BigQuery read files from Google Cloud Storage private folder from Google Play Developer Console?

0
votes

Google Play Developer Console provides access to a Google Cloud Storage folder with User Acquisition analytics data for my app at;

gs://pubsite_prod_rev_XXXXXXXX/acquisition/retained_installers

Can I get BigQuery to read from this data source?

If not, is there some way to link Google Play app analytics data to BigQuery (without Firebase)?

Thanks,

2
google-playgoogle-bigquerygoogle-cloud-platformgoogle-cloud-storage

2 Answers

1
votes

As mentioned in the above comment, google play uses a different encoding which could not be loaded directly into bigquery. Fortunately we are having a new feature just for this:)

Please check the BigQuery Data Transfer Service. It didn't mention Google Play because that's still in early stage.

If you are interested, you could

  1. Finish the Before you begin section. That page is for adwords, but the prerequisite is the same
  2. Fill the enrollment form and you will find play listed there.
  3. After that we will send you more guidelines about ingesting data for Google Play.
2
votes

Yes, you can query a federated table where the files are stored on GCS. From the UI, you can open the add table dialog using the drop-down menu next to your data set, then specify a path, file type, etc. for the external table.

The benefit of linking with Firebase, or manually uploading from GCS yourself into BigQuery storage, is that your queries will be much faster due to the internal, optimized storage format.