schulzefelix/laravel-bigquery

How to run Querry ?

livealltime123 opened this issue · 2 comments

livealltime123 commented

It's embarrassing, but can you tell me how to run a query?
For example I want to run the following command:
SELECT country_name, city_name, mask
FROM fh-bigquery.geocode.201806_geolite2_city_ipv4_locs
WHERE network_bin = NET.IP_FROM_STRING('103.230.141.7') & NET.IP_NET_MASK(4, 24)
Thanks !

livealltime123 commented

When i run query :
Google\Cloud\Core\Exception\ServiceException
{ "error": { "code": 403, "message": "Access Denied: Project alien-house-262216: User does not have bigquery.datasets.create permission in project alien-house-262216.", "errors": [ { "message": "Access Denied: Project alien-house-262216: User does not have bigquery.datasets.create permission in project alien-house-262216.", "domain": "global", "reason": "accessDenied" } ], "status": "PERMISSION_DENIED" } }

  • 😕1
  • 👀1
schulzefelix commented

Seems like you have permission problems. Sorry can't really provide support on this.