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

4 votes344 views2 answers
Colorama
Python
0 vote334 views1 answer
Tuple push
Python
0 vote366 views1 answer
To visualize the correlation between any two columns | scatter plot graph
Python
0 vote315 views2 answers
Auto play vido is not working in iphon
Python
9 votes354 views1 answer
Except as Exception:
Python
1 vote346 views1 answer
Django get id of newly created object
Python Django
0 vote351 views1 answer
Numpy get length of list
Python
-2 votes346 views1 answer
Django modelform datetime
Python
65 votes331 views4 answers
Python csv dict reader
Python
96 votes347 views6 answers
Read json file
Python