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 vote166 views1 answer
Cursor.fetchall() to list
Python
0 vote181 views1 answer
Floyd triangle python
Python
9 votes173 views4 answers
Convert float to integer pandas
Python
1 vote167 views1 answer
The Python package manager (pip) can only be used from outside of IPython.
Python
0 vote169 views1 answer
Save impt
Python
0 vote155 views1 answer
Pandas fillna with median of column
Python
0 vote154 views1 answer
While my_input != "exit":
Python
1 vote157 views1 answer
Python show only 1st element of nested lists
Python
0 vote150 views1 answer
Initialise tuple in python
Python
44 votes176 views6 answers
Pandas read csv file
Python