Using Redash with existing Queries

gallon1 · August 29, 2018, 8:45pm

I have a question regarding importing existing queries into Redash.

I am looking to implement Redash so that queries that I create on proprietary software I am using can then be used in Redash. The drill down software makes it easier for users that are not proficient in SQL to quickly create new queries. I want these queries to then be sent to Redash.

I am using a presto server cluster in the backend as my data source and the drill down software is also connected to the presto server cluster as well. I am currently implementing an event listener into the cluster so that the queries from the drill down software are saved in a file.

Is this a possible task? Can I import the queries from a different query engine to Redash? This way the user would only need to create the queries once to view them on both software suites.

Thanks

FvM · August 30, 2018, 10:09am

Hi gallon1,

see here for hints and links on how to export queries.

gist.github.com

https://gist.github.com/arikfr/598590356c4da18be976

README.md

## Setup

```
$ pip install click requests
```

## Usage

```
$ python query_export.py --redash-url "https://app.redash.io/<slug>" --api-key "<api-key>"

This file has been truncated. show original

query_export.py

import click
import requests

template = u"""/*
Name: {name}
Data source: {data_source}
Created By: {created_by}
Last Update At: {last_updated_at}
*/

This file has been truncated. show original

Best regards,
FvM

gallon1 · September 14, 2018, 2:02am

Quick question, where is this script implemented? Is it separate from Redash or part of it? Thanks for the information

FvM · September 17, 2018, 8:56am

Hi gallon1,

it is neither part of the github repo nor the latest 5.0 beta distribution. You can retrieve the script code directly from the aforementioned links and copy/paste into files.

E.g. the export script:

https://gist.githubusercontent.com/arikfr/598590356c4da18be976/raw/bd1fae78532d98577b8b7fbf5108bbb674383f9f/query_export.py

Best regards,
FvM

▼Categories

▼Tags

Using Redash with existing Queries