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

1 vote264 views1 answer
Python count code, Count number of occurrences of a given substring
Python
0 vote186 views1 answer
\xa python
Python
0 vote191 views1 answer
Combine all lines with same value of a column unix
Python
0 vote189 views1 answer
Python show interpreter path
Python
0 vote259 views1 answer
Using claudinary in django
Python Django
4 votes184 views3 answers
Python flip a coin
Python
1 vote192 views1 answer
Object literal python
Python
0 vote229 views1 answer
Unittest sleep
Python
1 vote234 views1 answer
How to open cmd at specific location usng python
Python
1 vote193 views1 answer
Find and count unique values of a single column in Pandas DataFrame
Python