Table Admin Usage

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.