Python Bigquery

A simple Python Flask API to consult Google Cloud Bigquery

English | Portuguese

Requirements

• Python 3.11.x

Setup

1. Clone this repo from Github with git clone git@github.com:dfop02/bigquery-api.git
2. Install the correct python version in .python-version using any python manager or directly download from official website.
3. Execute pip install -r requirements.txt
4. Before run the code you must have an service account, you can read how generate it here. After generate, put the credentials.json on project's root, if you change the filename, make sure you changed in .env too.
5. Now just run the app using python app.py

Test / Lint

If you want use tests or lint on this project, first you must need install the test dependences using pip install -r requirements_test.txt

After install the test dependences, you can run by using:

• Tests => pytest.
• Lint => pylint app.py

Fonts / Links / Docs

Suggestion of links, fonts to read about that you help you to learn more about how this code works and how the services we're using works.

About Bigquery

• Create credentials.json for a service account
• Flask + Bigquery
• Google Cloud Bigquery - Python
• Queries on Bigquery

About JWT

• PyJWT
• Flask + JWT

Author

Diogo Fernandes