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

0 vote239 views1 answer
How to change entry in a row based on another columns entry python
Python
0 vote247 views1 answer
Panda datetime ymd to dmy
Python
1 vote222 views1 answer
Dictionaries to http data python
Python
0 vote228 views1 answer
Prefetched_related django rest framework
Python Django
30 votes251 views6 answers
With open python
Python
2 votes232 views1 answer
Slicing in pandas
Python
0 vote238 views1 answer
How to access app.config globally in flask app
Python
4 votes247 views3 answers
Row wise mean pandas
Python
3 votes250 views2 answers
Wap in python to check a number is palindrome or not
Python
0 vote264 views1 answer
Setting up a django prostgress project
Python Django