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

11 votes273 views2 answers
How to send whatsapp message with python
Python
31 votes261 views1 answer
UnicodeDecodeError: 'charmap' codec can't decode byte 0x9d in position 6148: character maps to <undefined>
Python
1 vote290 views2 answers
Four digit representation python
Python
0 vote264 views1 answer
How to use ttk themes
Python
1 vote250 views4 answers
Arithmetic operators in python
Python
0 vote252 views1 answer
Pandas rename columns whitespace with underscore
Python
1 vote251 views1 answer
How to add an active class to current element in navbar in django
Python
12 votes252 views2 answers
Python sorted function descending
Python
0 vote301 views1 answer
Use if a not trusted message will come up
Python
2 votes265 views1 answer
Python time now other timezone
Python