tried this but return list of all columns and data in tuple format i need data in key value pairs
records = cursor.fetchall()
field_names = [i[0] for i in cursor.description]
print(field_names)
for value in records:
print(value)
output:
['client', 'engine', 'entity_name', 'attr_name', 'attr_type', 'attr_sql', 'attr_description', 'data_column', 'format_json', 'sort_json']
('bashas', 'benchmark', 'summary', 'day_part', 'D', 'summary.day_part', 'Day Part', 'day_part', None, None)