take in a dataframe and output (redshift) DDL For creating a table of that format.

df_to_ddl.py

def df_to_ddl(df, tablename='test.mytable'):
    data_dtypes = df.dtypes.reset_index().rename(columns = {'index':'colname',0:'datatype'})

    # Map pandas datatypes into SQL 
    data_dtypes['sql_dtype'] = data_dtypes.datatype.astype(str).map(
                            {'object':'varchar(24)',
                             'float64':'float', 
                             'int64':'int', 
                             'bool':'boolean'}   )


    ddl = ", ".join([ "{colname} {sql_dtype} \n".format(**row) 
                     for row in 
                     data_dtypes[['colname','sql_dtype']].to_dict('records')])

    ddl_statement = """
    create table {tablename}
    (
    {ddl}
    )
    DISTSTYLE ALL
    ;

    """.format(tablename=tablename,ddl=ddl)

    return ddl_statement