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 vote335 views1 answer
Django iterating through objects
Python Django
0 vote398 views1 answer
Exception: 'ascii' codec can't decode byte 0xe2 in position 7860: ordinal not in range(128)
Python
12 votes332 views6 answers
Add elements to list python
Python
0 vote343 views1 answer
How to upload to PyPi with same name
Python
0 vote339 views1 answer
Get only every 2 rows pandas
Python
3 votes371 views1 answer
For e in p.event.get(): pygame.error: video system not initialized
Python
0 vote376 views1 answer
Python save .mat
Python
0 vote338 views1 answer
Postman authorization
Python
0 vote342 views1 answer
List of imported modules in python
Python
0 vote397 views1 answer
Bar plot fix lenthgy labels matplot
Python