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

8 votes282 views2 answers
Size of folder in mb linux
Python
16 votes266 views4 answers
List to dataframe columns
Python
6 votes257 views2 answers
Numpy random int
Python
0 vote298 views1 answer
Html.unescape python
Python
1 vote276 views1 answer
Index of max value of sequence python
Python
0 vote242 views4 answers
How to show variable in Jupyter
Python
0 vote305 views1 answer
Mechanize python #9
Python
0 vote284 views1 answer
Django querset group by sum
Python Django
0 vote272 views1 answer
Pairwise function python
Python
6 votes264 views1 answer
Utf8 python encodage line
Python