Skip to content

hackersandslackers/bigquery-sqlalchemy-tutorial

Repository files navigation

BigQuery SQLAlchemy Tutorial

Python Google Cloud BigQuery PyBigQuery SQLAlchemy PyMySQL GitHub Last Commit GitHub Issues GitHub Stars GitHub Forks

BigQuery SQLAlchemy Tutorial

Lightweight ETL script to migrate data from BigQuery to SQL databases, or vice versa. Tutorial found here: https://hackersandslackers.com/bigquery-and-sql-databases/

Getting Started

Installation via Pipenv:

$ git clone https://github.com/hackersandslackers/bigquery-python-tutorial.git
$ cd bigquery-sqlalchemy-tutorial
$ pipenv shell
$ pipenv update
$ python3 main.py

Installation via Poetry:

$ git clone https://github.com/hackersandslackers/bigquery-python-tutorial.git
$ cd bigquery-sqlalchemy-tutorial
$ poetry install
$ poetry run

Alternatively, try installing via setup.py:

$ git clone https://github.com/hackersandslackers/bigquery-python-tutorial.git
$ cd bigquery-sqlalchemy-tutorial
$ python3 setup.py install
$ python3 main.py

Hackers and Slackers tutorials are free of charge. If you found this tutorial helpful, a small donation would be greatly appreciated to keep us in business. All proceeds go towards coffee, and all coffee goes towards more content.