Google BigQuery recently added GIS functionality (still in beta), see here.

I have a dataset in BigQuery that I would like to use as a data source in QGIS - much the same way as I would do with a normal PostGIS database or a CSV file.

Is there a way to do this?

I guess I could export the data from bigquery into a PostGIS instance in GCS, and then I would be able to load it into QGIS. But that doesn't feel like the right way to do it.

Size of data is not a concern, and I'm using QGIS 3.4.2 (Madeira).

  • What do you think about exporting as GeoJSON and then importing in QGIS
    – Taras
    Jan 8, 2019 at 10:10
  • Thanks for the tip, that's one possibility but it has the problem that if I update my data I will have to export and import it again. Ideally, I would like to avoid this - same way as I would if I was using a postGIS db Jan 8, 2019 at 11:20
  • You are welcome, sorry for a poor suggestion. I am not an expert in this domain, so probably let's wait for a better hint/answer. Maybe you have to develop an add-on to let data update in PostGIS after the GeoJSON would be automatically created, e.g. Import GeoJSON into PostGIS
    – Taras
    Jan 8, 2019 at 11:57
  • What I can think is creating a connection with R using the libraries bigqueryR and RQGIS3, everything in a single script; otherwise you should program a plugin in QGIS. @JoãoCoelho
    – Ariel
    Jan 9, 2019 at 19:41
  • Thanks for the suggestion! I'll keep that in mind if I can't find a more straightforward solution. I'll also look into what it takes to create a plugin for QGIS - if you have any thoughts or tips on that feel free to share them :) Jan 10, 2019 at 8:37

1 Answer 1


There were two solutions people described using in BQGIS group,

One is import plugin for QGIS,

Another is foreign data wrapper for PostgreSQL, then using Postgre layers in QGIS:

  • Unacast's plugin works wonderfully, thank you Apr 24, 2019 at 18:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.