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

9 votes169 views2 answers
Python if value in range
Python
0 vote159 views1 answer
Views.py django
Python
1 vote164 views1 answer
Running setup.py bdist_wheel for opencv-python: still running...
Python
1 vote224 views1 answer
How to delete a specific line in a file
Python
1 vote189 views2 answers
ModuleNotFoundError: No module named 'playsound'
Python
0 vote174 views1 answer
Convert month weeks days into month days in python pandas
Python
0 vote178 views1 answer
Copy files to a directory using text file
Python
0 vote163 views1 answer
Sort lexo python
Python
0 vote245 views2 answers
Django-filter
Python
0 vote226 views1 answer
Using claudinary in django
Python