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

3 votes280 views2 answers
Flask db migrate
Python
0 vote310 views2 answers
Pairwise swap in data structure in python
Python
0 vote266 views1 answer
Python module to get football results
Python
4 votes266 views1 answer
Edit line if str end with pandas
Python
0 vote307 views1 answer
Query first 5 element in django
Python Django
0 vote260 views1 answer
Splitting strings in Python without split()
Python
0 vote251 views1 answer
Pandas split dataframe into chunks with a condition
Python
1 vote302 views1 answer
Python find the average of a list
Python
0 vote277 views1 answer
Python control windows gui
Python
0 vote271 views1 answer
Python dummy command
Python