# Import from BigQuery to Elasticsearch
**URL:** https://discuss.elastic.co/t/import-from-bigquery-to-elasticsearch/155454
**Category:** Elasticsearch
**Created:** [November 5, 2018, 8:42pm UTC](https://discuss.elastic.co/t/import-from-bigquery-to-elasticsearch/155454 "2018-11-05T20:42:31Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@melissachang](https://discuss.elastic.co/u/melissachang)
#### Post date: [November 5, 2018, 8:42pm UTC](https://discuss.elastic.co/t/import-from-bigquery-to-elasticsearch/155454/1 "2018-11-05T20:42:31Z")
This is a follow-up to [Import from BigQuery to Elasticsearch?](https://discuss.elastic.co/t/import-from-bigquery-to-elasticsearch/138448)
In [https://github.com/DataBiosphere/data-explorer-indexers](https://github.com/DataBiosphere/data-explorer-indexers), we're developing a solution that is pretty fast:
- Copy BigQuery table to JSON files on GCS. It only take a couple minutes to load 2G table into python.
- Based on BigQuery schema, supply mappings. Turn off dynamic mappings.
We were able to index a 2G BigQuery table into ES in 4 hours.
If there is interested, we could extract BigQuery -\> Elasticsearch into a separate repo.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 3, 2018, 8:42pm UTC](https://discuss.elastic.co/t/import-from-bigquery-to-elasticsearch/155454/2 "2018-12-03T20:42:36Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.