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 vote169 views1 answer
Unreadable Notebook: jupyter
Python
2 votes162 views1 answer
Pygame rect collisions
Python
0 vote156 views1 answer
Pandas dataframe for loop begin end index
Python
1 vote175 views1 answer
Get last year of today python
Python
4 votes153 views1 answer
Cannot import name 'flask' from partially initialized module 'flask' (most likely due to a circular import)
Python Flask
1 vote162 views1 answer
How to merge rows in pandas dataframe
Python
0 vote163 views1 answer
Lambda Functions using for loop
Python
0 vote213 views1 answer
Pandas index append value
Python
7 votes126 views1 answer
Telegram markdown
Python
0 vote183 views1 answer
Python function guts
Python