redash 配置 python datasource 使用例子

1.redash查询配置

from redash_python import test
py_result = test()

result = {}
for col in py_result[0]:
    print(col)
    add_result_column(result, col, col, 'string')
    
for row in py_result:
    print(row)
    add_result_row(result,row)    

2.python脚本配置

#!/usr/bin/env python3
# -*- encoding: utf-8 -*-

rows = [{
		"id": 1,
		"name": "小云"
	},
	{
		"id": 1,
		"name": "小和"
	},
	{
		"id": 2,
		"name": "小恩"
	},
	{
		"id": 1,
		"name": "小墨"
	}
]


def test():
    return rows

3.最终效果图：