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 vote300 views1 answer
Pandas remove multi header from dataframe
Python
0 vote373 views1 answer
Twitter api ("Connection broken: Invalid Chunk Length(got length b'', 0 bytes read)"
Python
0 vote288 views1 answer
Raspberry pi push button function control python
Python
10 votes310 views2 answers
Max columns in python
Python
0 vote278 views1 answer
~coinbase api
Python
0 vote306 views1 answer
Python type hint class itself
Python
0 vote296 views1 answer
Regular Expression to Stop at First Match
Python
16 votes338 views4 answers
Mean of a list python
Python
3 votes280 views1 answer
Change plot size matplotlib python
Python
1 vote288 views1 answer
Add a button on tkinter
Python