[Python] Exporting data from BigQuery into a local PostgreSQL/MySql database

Discussão em 'Python' iniciado por Stack, Março 24, 2025.

  1. Stack

    Stack Membro Participativo

    I'm BigQuery and the Python API for BigQuery - virgin.

    My task is: pull data from the google open dataset using BigQuery and Python API, load the data into the MySql/PostgreSQL local database (the one installed on my PC)

    The way i see it (after my 2-hour research) is: pull data into a local csv file (using this kind of a sample code), load the data from the file into the database.

    Does this resemble the right way of performing the task?

    If not, could you please provide some advice/instruction?

    Thanks in advance.

    Continue reading...

Compartilhe esta Página