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.

140 questions
5
votes
1 answer

AWS Redshift: columns into rows (wide to long)

I'm writing a query which result will be displayed as dashboard on redash. The query is basically a sum of several columns of table within a specific time range: SELECT sum(col_A), sum(col_B), sum(col_C) FROM table_X WHERE timestamp >…
Victor Mayrink
  • 1,064
  • 1
  • 13
  • 24
4
votes
2 answers

Comparing objects inside a nested array - mongoDB

In my db I have a nested array of elements inside each document containing items, in the following form: elements:[ { "elem_id": 12, items: [ {"i_id": 1, "type": x}, {"i_id": 2, "type": y}, {"i_id": 3, "type": x}] }, { …
Roni
  • 55
  • 3
4
votes
0 answers

Why Redash SQL query does not end？

I have installed the Redash, I created the MySQL connection on the web and tested it, but when I was executing on the Redash query SQL page, I found that the request was always sent, no data returned. this is redash sql query image execute
rowele
  • 85
  • 10
3
votes
1 answer

building redash chart over prometheus

I'm trying to create Redash chart based on query from prometheus data source: rate(active_devices_count[1w]). I'm expecting to see a date/value based graph, just as I see in our Grafana, but instead I see only single line on the graph. I looks like…
TheHat
  • 70
  • 6
3
votes
1 answer

Getting Error "The security token included in the request is invalid" UnrecognizedClientException when calling the StartQueryExecution operation

I am getting error while setup data source connection in redash with athena credential. I have a valid access in athena where i can run query and fetch logs from S3. Now i want to integrate athena with redash, SO i am getting error "An error…
Pankaj Aswal
  • 31
  • 1
  • 5
3
votes
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
  • 31
  • 1
  • 2
3
votes
3 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
  • 31
  • 1
  • 4
3
votes
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
  • 195
  • 1
  • 11
3
votes
0 answers

Integrating Redash into a Docker Container

Problem: Install Redash in my Docker Make Redash charts available inside my App that is running in Docker Test container that is basically removing any 3rd party factor in the issue that just runs a Flask app for demo. app.py from flask import…
Srinath Ganesh
  • 2,496
  • 2
  • 30
  • 60
2
votes
1 answer

Reports/Visualization on top of Databricks SQL Analytics(Redash) query history?

Is it possible to directly query the query history (logs) from Databricks SQL Analytics workspace and develop some reports on query metrics?
Venkat Tumu
  • 21
  • 2
2
votes
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
  • 31
  • 2
2
votes
2 answers

How to get the time difference between two date stamps and arrange in DESCENDING ORDER

I need the time difference between two datestamps in hours and need to arrange them in descending order to get the median SELECT "fulfillmentshistories"."fulfillmentid" as "Fulfillment ID" FROM FULFILLMENTHISTORIES WHERE (Fulfillments."status" IN…
Kaushika Potluri
  • 31
  • 5
2
votes
2 answers

Error with aggregate function in a CASE statement and GROUP BY clause

I have the following CTE that I am using in a larger query and I receive two different error messages based on how I group. I am on Redash and using Amazon Athena. I can group by tenant_id or I can group by tenant_id & my case statement that is…
jackcarlson
  • 55
  • 5
2
votes
1 answer

How should I write IAM to make only a certain VPC can send mail via SES?

I use Redash on EC2 instance, and I have to send invitation mails via Amazon SES. I'd like to add a setting to restrict mail sender to inside a certain VPC where the Redash instance is located. Here's my IAM for SES: { "Version":…
lipsum
  • 919
  • 2
  • 13
  • 24
1
vote
0 answers

If/Else code execution based on filter value - Redash

I would like to check if it is possible to use Redash filter parameters to turn on/off code in my Presto query. Sample code I tried: shown below. Basically, I want to union queries only if the filter value is 'a'. select 1 col {% if…
Mel
  • 11
  • 1
1
2 3
…
9 10