how to create a table using the following python bigquery api?

Question

Hello I cloned the following repository:

https://github.com/tylertreat/BigQuery-Python

I was reading the documentation about creating a table as follows:

schema = [
    {'name': 'foo', 'type': 'STRING', 'mode': 'nullable'},
    {'name': 'bar', 'type': 'FLOAT', 'mode': 'nullable'}
]
created = client.create_table('dataset', 'my_table', schema)

I tried to execute the same in my console as follows:

>>> schema = [
...     {'name': 'foo', 'type': 'STRING', 'mode': 'nullable'},
...     {'name': 'bar', 'type': 'FLOAT', 'mode': 'nullable'}
... ]
>>> created = client.create_table('data_set_course', 'my_table_testing', schema)

I only got 'False' and when I check the visual interface there is no table.

>>> print(created)
False
>>>

I dont have any idea about the issue, I really frustrated since I just what to create one table, so I really would like to appreciate the support to overcome this task.

See this question stackoverflow.com/questions/55031720/… it has good python script to reuse — Tamir Klein
– Tamir Klein, Commented Mar 8, 2019 at 7:47

llompalles · Accepted Answer · 2019-03-08 11:25:24Z

1

I have tested this code and it works for me:

from bigquery import get_client

# JSON key provided by Google
json_key = 'key.json'

client = get_client(json_key_file=json_key, readonly=False)

schema = [
    {'name': 'foo', 'type': 'STRING', 'mode': 'nullable'},
    {'name': 'bar', 'type': 'FLOAT', 'mode': 'nullable'}
]
created = client.create_table(dataset='yourDataset', table='tableToCreate', schema=schema)

You need to check 2 things:

readonly parameter in the get_client method is set to False. Otherwise BigQuery access is read-only.
The service account or user provided in the key.json file has been granted with the permissions to create a BigQuery table. At least it must have the roles/bigquery.dataEditor role granted. To do it run the following command:

gcloud projects add-iam-policy-binding [PROJECT_ID] --member "serviceAccount:[NAME]@[PROJECT_ID].iam.gserviceaccount.com" --role "roles/bigquery.dataEditor"

Anyway I recommend you to use the official Python Client for Google BigQuery, you will have better documentation and functionality. As well as a huge amount of code examples in the BigQuery official documentation.

answered Mar 8, 2019 at 11:25

llompalles

3,19614 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

neo33 Over a year ago

Thanks I am testing this api, it seems to work, thanks a lot for the support

neo33 Over a year ago

after the past issue now I cant execute an insert I hope you could please soporte me: stackoverflow.com/questions/55067816/… I really appreciate the support

Collectives™ on Stack Overflow

how to create a table using the following python bigquery api?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related