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 connectconnection = 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 ...