def METHOD_NAME(database, table, schema, engine=None):
    meta_res = engine.execute(
        'select column_name, data_type from information_schema.columns where table_schema= \'' + schema + '\' and table_name= \'' + table + '\'').fetchall()
    meta = []
    i = 0
    for colData in meta_res:
        scores = {"key": colData.column_name, "colIndex": i, "dataType": colData.data_type}
        meta.append(scores)
        i += 1
    return meta