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 vote212 views2 answers
Python datetime minus datetime
Python
0 vote175 views1 answer
Tkinter mouse loading cursor
Python
0 vote176 views1 answer
Pandas change period to daily frequency
Python
2 votes173 views1 answer
Code to change default browser to chrome in web browser module
Python
1 vote237 views2 answers
How to change todays date formate in python
Python
6 votes170 views4 answers
Pandas rename multiple columns
Python
10 votes241 views1 answer
Python game engine
Python
1 vote147 views1 answer
Procfile for flask app
Python
1 vote185 views1 answer
Folium anaconda
Python
2 votes307 views2 answers
How to read a json resposnse from a link in python
Python