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 vote206 views1 answer
Bar chart with x-ticks
Python
59 votes200 views6 answers
Classes in python
Python
1 vote252 views1 answer
Browse list python
Python
8 votes242 views3 answers
Which python mac
Python
0 vote273 views1 answer
Django template add numbers
Python Django
0 vote202 views1 answer
Return an RDD of grouped items.
Python
0 vote196 views1 answer
Required depend filed odoo
Python
0 vote281 views1 answer
Queryset.raw() in django rest framework joining tables
Python Django
11 votes190 views3 answers
Combine dataframes with two matching columns
Python
0 vote224 views1 answer
Block content
Python