Run queries using Python

user123 · November 7, 2022, 7:30am

Hi All,
I have certain queries in local excel sheet, which i need to run on redash and store the result in back in a new sheet. The reading and writing i can figure out but how can i run queries using python and get the result?

Has anyone tried it?(m sure someone has) I tried installing redash-python package and have successfully done the authentication. How to move ahead is what i’m looking for.

Any pointers would be helpful.

Thanks,
Auto-user

xavier-d · November 7, 2022, 4:49pm

You can check this code:

gist.github.com

https://gist.github.com/arikfr/e3e434d8cfd7f331d499ccf351abbff9

refresh.py

import os
import requests
import time
from pprint import pprint


def poll_job(s, redash_url, job):
    # TODO: add timeout
    while job['status'] not in (3,4):
        response = s.get('{}/api/jobs/{}'.format(redash_url, job['id']))

This file has been truncated. show original

there are 2 apis

one to get the job started
one to fetch the result

user123 · November 8, 2022, 12:50pm

First and foremost thanks @xavier-d for the quick response. This solution fantastic, however i’m more keen on sending the actual query as function argument rather than the query id. is that possible?

xavier-d · November 8, 2022, 1:35pm

query must be saved to be executed using the queryID
so either updating or creating a new query in order to get the id, I don’t see how to do it.

I don’t know what you want to perform, but creating sheets in Excel is not the right solution

user123 · November 9, 2022, 3:24am

The sheet is the requirement as it gets sent in email to stakeholders(some of whom do not have access)
The reason I’m trying to put the queries directly is because i wont have fix set or queries to run every time. They will keep changing, hence taking them from an input sheet.
i checked redash-python for execute_query and get_query_result, looked good, but couldnt get much on them.

user123 · November 9, 2022, 10:12am

anyhow https://redash..io/queries/2938/results is throwing a 405 Method Not Allowed error for POST. if a do a get i see a JSONDecodeError