easyenvi.gcloud.BQ.write

Write an entire Python dataframe into Big Query.

Parameters

• obj : pandas.DataFrame table to save

• path : str path representing the data set and the name of the table (ex : "mydata.mytable")

• schema : list (optional) schema of the table. If not specified, a schema is generated based on mapping

  Format: list of dictionnaries (see below example or Google Cloud Documentation)

Examples

schema = [{"name": "country",   "type": "STRING"},
          {"name": "date",      "type": "TIMESTAMP"},
          {"name": "inflation", "type": "FLOAT"}]

envi.GCP.BQ.write(obj=inflation, path='finance_data.inflation', schema=schema)