With the connection established, we can now execute SQL statements in the Python script that will generate tables in the MapD Core instance. The following statement will create a simple table called county, with a MULTIPOLYGON geometry type, an integer id field, and three VARCHAR-type fields (or strings, as they would be called in Python):

from pymapd import connect
connection = connect(user="mapd", password= "{password}", 
     host="{my.host.com}", dbname="mapd")
cursor = connection.cursor()
create = """CREATE TABLE county ( id integer NOT NULL, 
  name VARCHAR(50), statefips VARCHAR(3), 
  stpostal VARCHAR(3), geom MULTIPOLYGON );
"""
cursor.execute(create)
connection.commit()

The next code block will create a table called address, with a POINT geometry type, an integer id field, and a VARCHAR-type field called address:

from pymapd import connect
connection = connect(user="mapd", password= "{password}", 
     host="{my.host.com}", dbname="mapd")
cursor = connection.cursor()
create = """CREATE TABLE address ( id integer NOT NULL PRIMARY KEY, 
  address VARCHAR(50), geom Point );
"""
cursor.execute(create)
connection.commit()