Rubq allows access to Google Bigquery the rails way. It uses the
Google::Cloud::Bigquery gem behind the scenes and allows for migrations and basic administration.
Here be dragons! This is a proof-of-concept project I am currently toying around with.
This is still very much of a work in progress. Unusable for now. You have been warned.
- Creating a model migration and its corresponding table in BigQuery
- Inserting a row in a managed table
What does not work
- Everything else
Roadmap to the first usable version
- Write a
- Set up schema validation
- Set up a test suite
- Streamline usage
- Create / Delete tables
Add this line to your application's Gemfile:
And then execute:
Or install it yourself as:
$ gem install rubq
Initialize the library:
# app/config/initializers/rubq.rb . do |config| config.project = 'my-google-project' config.region = 'eu' config.dataset = 'my-bigquery-dataset' end
Why not an ActiveRecord adapter?
Because Bigquery is by no means a mere SQL database. This gem is just a wrapper around the
Google::Cloud::Bigquery gem that provides convenience methods in an ActiveRecord-like fashion.
I will add contribution guidelines as soon as this is ready to use.
The gem is available as open source under the terms of the MIT License.