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 vote273 views1 answer
Python index strings
Python
0 vote299 views1 answer
Captions overlap in seaborn plot jupyter
Python
2 votes314 views1 answer
Pandas index false print
Python
0 vote339 views1 answer
Django.core.exceptions.ImproperlyConfigured: Application labels aren't unique, duplicates: auth
Python
1 vote316 views2 answers
Python get first occurrence in list
Python
0 vote308 views1 answer
How to know if i'm in a virtual environment
Python
11 votes334 views1 answer
Selecting items in a column of a dataframe
Python
85 votes351 views4 answers
Create python executable
Python
1 vote351 views1 answer
Django form list option
Python Django
1 vote337 views2 answers
How to print text in python
Python