As of January 1, 2020 this library no longer supports Python 2 on the latest released version. Library versions released prior to that date will continue to be available. For more information please visit Python 2 support on Google Cloud.

Table Admin

After creating an Database, you can interact with individual tables for that instance.

List Tables

To iterate over all existing tables for an database, use its list_tables() method:

for table in database.list_tables():
    # `table` is a `Table` object.

This method yields Table objects.

Table Factory

A Table object can be created with the table() factory method:

table = database.table("my_table_id")
if table.exists():
    print("Table with ID 'my_table' exists.")
else:
    print("Table with ID 'my_table' does not exist."

Getting the Table Schema

Use the schema property to inspect the columns of a table as a list of Field objects.

for field in table.schema
    # `field` is a `Field` object.