Redash is a tool to connect to any data source, easily visualize and share data using saved queries etc.
Redash is a tool to connect to any data source, easily visualize and share data using saved queries etc.
Check https://redash.io/ for more.
Questions tagged [redash]
140 questions
1
vote
1 answer
First Week Retention with MongoDB
One table with session start events:
Registered - unixtime - when the user was registered (first time opened the app)
DateTime - unixtime - time when the event was sent (when player installs the app and opens it for the first time: Registered =…
Alex Kotlaroff
- 13
- 2
1
vote
3 answers
RLIKE expression giving 'mismatched input' error
I am querying a Hive table through Redash. I have a query similar to the following:
SELECT
CAST(id AS INT) as id,
COUNT(sales) AS num_sales
FROM
sales_table
WHERE
id RLIKE '\d*'
GROUP BY
id
I am trying to select only IDs…
KOB
- 4,084
- 9
- 44
- 88
1
vote
1 answer
Sqlalchemy / psycopg2 error when trying to connect to CloudSQL postgres
I am spinning up redash using helm on GKE with master/node version 1.12.10-gke.17 and istio 1.1.15
I use as database a GCP CloudSQL with postgres 9.6
When trying to execute the create_db script from the redash image (7.0.0.b18042) I encounter the…
pkaramol
- 16,451
- 43
- 149
- 324
1
vote
0 answers
Possible regular expression backtracking problem in redash sql
I have logged user's actions on the website like the following ones:
00:00 firstpage.textbox.hover
00:01 firstpage.textbox.push
00:02 firstpage.textbox.type
00:03 firstpage.textbox.submit
I am trying to find if there was a specific pattern of…
Sergei
- 63
- 1
- 8
1
vote
1 answer
docker-compose run on ECS
I've been trying to set up Redash to run on ECS. I'm rather new to ECS and Docker in general so I'm not sure if I'm missing something fundamental with what I've done so far.
So far, I've converted Redash's docker-compose file to an AWS container…
user10121455
1
vote
0 answers
Redash: importing queries from other instance
I created a new redash instance and I want to import queries from the old one.
I used this tool to export: https://gist.github.com/arikfr/598590356c4da18be976
However, when I import e.g. query 5, I get a 404 error because query 5 doesn't exist. If I…
Dotan
- 6,602
- 10
- 34
- 47
1
vote
1 answer
How to configure Apache Ignite in Redash
I need to configure Apache ignite in Redash for BI dashboard but couldn't figure out how to do the same since there is no direct support for ignite in Redash.
Sandeep Jakkula
- 23
- 1
- 7
1
vote
1 answer
Redash not caching the queries
I am not able to see query being cached in ReDash. I used the ami version provided on their website for self hosting, updated it to the latest version and fired few queries on athena, but everytime it queries Athena and fetches result.
All the…
Nipun
- 4,119
- 5
- 47
- 83
1
vote
0 answers
Getting error while installing ReDash on my Ubuntu
While running the bootstrap.sh file on root m getting this error (1st line in terminal) 404 not Found. I checked that URL it's not present actually. Here is the
Terminal screen shot I wanted to install Redash on my ubuntu, what will i do
Ravindra Gupta
- 1,256
- 12
- 42
1
vote
0 answers
How to connect multiple redash servers with single database
We are using one Redash server as a Analytics tool and We all know each redash server should comes with its own db i.e postgres . So now I want to create a multiple redash servers and all the remaining servers should connect to single db within any…
Vy Suneel
- 97
- 1
- 13
1
vote
1 answer
How to write a python script in Re-Dash?
I have already edited the .env file and added the export
REDASH_ADDITIONAL_QUERY_RUNNERS=redash.query_runner.python into it
I have python as a datasource now. But I'm not sure how to write python
code to be executed under a query after selecting…
Niraj Fonseka
- 41
- 2
- 5
1
vote
0 answers
Retrieve all columns in PostgreSQL while specifically formatting only one
I'm using redash on a PostgreSQL db and for some of our tables, querying all columns using SELECT * returns an error akin to column X is not JSON serializable. My understanding is that it's because a column contains a datetime range (and doesn't…
MacAnRiogh
- 75
- 6
1
vote
1 answer
Redash MongoDB query by ObjectID
I have a collection with the following document structure:
{
"_id" : ObjectId("58aa706c658d1dc6c700002c"),
"source" : "web",
"type" : "Comentarios",
"email" : "jhondoe@xyz.com",
"updated_at" :…
Luis Carlos Villamil Rojas
- 91
- 1
- 5
0
votes
0 answers
Query information: Some of my Jira fields are empty in Redash
I am trying to query information from my Jira from Redash.
I already made the connection and it was successful, the problem is that when I try to consult the different tasks from the query editor, (writing { } to get all the information) I can't get…
0
votes
0 answers
How to get API status code from the header in angular, and API call type is document, and in response getting HTML content
Below is my HTML iframe code
and url is for iframe
safeUrl =…
Salman Khan
- 1
- 1