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

13 votes167 views2 answers
Try catch if else python
Python
1 vote197 views1 answer
Python - count the frquency of a vlaue in a coulmn
Python
0 vote212 views1 answer
Generate dates between two dates python
Python
11 votes197 views3 answers
Username Python
Python
35 votes208 views6 answers
Pandas merge dataframes
Python
12 votes199 views3 answers
Python program to add two numbers with user input
Python
1 vote197 views1 answer
Python converting phred quality score to number
Python
0 vote254 views1 answer
Python remove item from a list
Python
0 vote201 views1 answer
%d%m%y python
Python
6 votes196 views2 answers
Horizontal line matplotlib python
Python