Amazon redshift

>>> import sqlalchemy as sa
>>> from sqlalchemy.schema import CreateTable
>>> engine = sa.create_engine('redshift+psycopg2://example')
>>> metadata = sa.MetaData()
>>> user = sa.Table(
...     'user',
...     metadata,
...     sa.Column('id', sa.Integer, primary_key=True),
...     sa.Column('name', sa.String),
...     redshift_diststyle='KEY',
...     redshift_distkey='id',
...     redshift_interleaved_sortkey=['id', 'name'],
... )
>>> print(CreateTable(user).compile(engine))

CREATE TABLE "user" (
    id INTEGER NOT NULL,
    name VARCHAR,
    PRIMARY KEY (id)
) DISTSTYLE KEY DISTKEY (id) INTERLEAVED SORTKEY (id, name)

Source: sqlalchemy-redshift.readthedocs.io

Similar codes

2 votes361 views1 answer
Normalise list python
Python
0 vote370 views1 answer
How to write a program that interacts with the terminal
Python
0 vote343 views2 answers
Xgbboostclassifier model
Python
74 votes358 views6 answers
Python append to dictionary
Python
7 votes350 views3 answers
Pandas switch column levels
Python
7 votes341 views5 answers
Python csv to list
Python
0 vote465 views1 answer
How to get SITE_ID in django....shell
Python Django
2 votes333 views1 answer
What is not equals in python
Python
4 votes370 views1 answer
Text widget get tkinter
Python
3 votes322 views1 answer
Python urlencode with requests
Python