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 vote197 views1 answer
Def dict(d)
Python
0 vote225 views1 answer
MULTIPLE Model Search in Django rest framework
Python Django
231 votes294 views6 answers
Random numbers in python
Python
22 votes176 views1 answer
Python test if number in string
Python
2 votes174 views2 answers
Numpy remove object from array
Python
0 vote173 views1 answer
Get hwid python
Python
0 vote163 views1 answer
Str = "This article is written in {}" print (str.format("Python"))
Python
0 vote174 views1 answer
Python temp directory
Python
35 votes225 views6 answers
How to remove spaces in string in python
Python
7 votes165 views3 answers
Python open encoding utf-8
Python