Takes a Redash query ID and returns cached-data in a Pandas dataframe

query_redash.py

# save your redash API key in a text file as below
api_key = open('api_key.config', 'r').readlines()[0]



def api_to_df(query_id, api_key=api_key):
    '''
       Takes a Redash query ID and returns cached-results
       in a Pandas dataframe
    '''

    headers = {'Authorization': 'Key {}'.format(api_key)}
    path = 'https://<redash-url>/api/queries/{:d}/results.csv'
    path = path.format(query_id)
    print("getting ", path)
    txt = requests.get(path, headers=headers).text
    return pd.read_csv(io.StringIO(txt))