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 votes244 views2 answers
How to find the longest string in a list in python
Python
2 votes247 views3 answers
How to open file explorer in python
Python
2 votes256 views1 answer
Python sort multiple lists based on sorting of single list
Python
1 vote262 views1 answer
Check if the user is logged in django decorator
Python
18 votes311 views5 answers
Flask minimal app
Python Flask
0 vote231 views1 answer
Django form set min and max value
Python
1 vote239 views1 answer
How to add value to to interger in python
Python
0 vote246 views1 answer
Travis ci .yml for python
Python
1 vote241 views1 answer
Draw line from 2 mouse event in image python
Python
0 vote275 views3 answers
Django celery email
Python Django