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

5 votes233 views2 answers
Columns to dictionary pandas
Python
42 votes218 views5 answers
How to print today's date in python
Python
5 votes224 views3 answers
Python calendar table view
Python
0 vote225 views1 answer
Summarizing Data and description data in pandas
Python
7 votes246 views2 answers
How to create a variablein python
Python
92 votes220 views4 answers
Rename data columns pandas
Python
0 vote225 views2 answers
How to delete a row based on a criteria in python datafram
Python
0 vote220 views1 answer
Numpy prod
Python
0 vote239 views1 answer
Torch.utils.data.random_split(dataset, lengths)
Python
0 vote234 views2 answers
Remove last element from dictionary python
Python