def METHOD_NAME(database, table, schema, engine=None):
    meta_res = engine.execute('desc ' + database + '.' + table).fetchall()
    meta = []
    i = 0
    for col_data in meta_res:
        scores = {"key": col_data.name, "colIndex": i, "dataType": col_data.type}
        meta.append(scores)
        i += 1
    return meta