How to create a schema on Google BigQuery from App Engine in Python?

Question

We are attempting to create a table and define the schema on Google BigQuery from a Python app on Google AppEngine.

This page from Google's documentation demonstrates commands to set the schema that look like this:

# Set the table schema
    table.schema = (
        bigquery.SchemaField('Name', 'STRING'),
        bigquery.SchemaField('Age', 'INTEGER'),
        bigquery.SchemaField('Weight', 'FLOAT'),
    )

Per this Github example, these commands require this library:

from google.cloud import bigquery

However, when run this import command on AppEngine, we receive the error "module cloud not found."

Is this library not available on App Engine? If not, how do we create a table and define the schema on-demand from App Engine in Python?

Answer 1

Currently the Google Cloud Client Library isn't supported on App Engine standard (issue). You will need to use the Google APIs Client Library instead. You can use this sample project to see how to get started with BigQuery on App Engine.

See also:

• Reference for creating a table with the APIs Client Library