Stack Overflow
Stack Overflow

Questions tagged [redash]

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.

104 questions
1
vote
2 answers

I'm new to SQL and thinking is there any way to simplify this Query?

Im really new to SQL, doing this for my basic needs for works and basically I'm not a tech guy. But I'm curious to know is there any way to simplify my SQL Code here: SET sql_mode = ''; SELECT DISTINCT partner.kode_agent, …
Dimitri Dwi Putra
  • 11
  • 1
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
  • 3,062
  • 1
  • 24
  • 60
1
vote
1 answer

Docker compose: expected a mapping or list of mappings for merging, but found scalar

I'm trying to use the following guide to setup Redash on Docker under a Windows environment: https://medium.com/@ikishan/creating-a-new-age-dashboard-with-self-hosted-open-source-redash-41e91434390 But when I reach the following step: docker-compose…
Taiane Barbosa
  • 11
  • 2
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
  • 9,548
  • 14
  • 80
  • 167
1
vote
0 answers

Redash Question. Filtering query based drop-down based on another query based drop-down

So im working with redash. I need to find some way to filter results of one dropdown based on the results of another dropdown. if i select "A" in the dropdown 2, i want the results of dropdown 1 to be changed based on the option selected in dropdown…
AnEccentricScientist
  • 11
  • 2
1
vote
2 answers

Using API to create a new query on Redash

I managed to import queries into another account. I used the endpoint POST function given by Redash, it sort of just applies to just “modifying/replacing”:…
Nicholas Lee
  • 11
  • 3
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
  • 43
  • 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
1 answer

Cannot connect to localhost from redash

I am trying to connect to a local postgres from Redash. (both from redash.io and http://0.0.0.0:5000/) but cannot connect to it. an other tools i can connect localhost, but from Redash i getting error: Connection Test Failed: could not connect to…
clairvoyant
  • 135
  • 9
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
  • 4,312
  • 3
  • 27
  • 41
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
  • 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
  • 3,423
  • 3
  • 36
  • 67
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
  • 940
  • 6
  • 28
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
  • 10
1
2
3 4 5 6 7