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
0
votes
1 answer

redash SQL query inner join with query

I am using redash to display data and am struggling to figure out how to show only specific images for this join query. The problem is with my last AND condition which seems to break the query (AND "images"."imageable_type" = "BrandProfile"). Below…
BC00
  • 1,589
  • 3
  • 29
  • 47
0
votes
0 answers

Redash metadata DB migrate

I am using Redash v5.0.0 and PostgreSQL for metadata in an EC2 instance. I can create Redash v8.x container on ECS and PostgreSQL on RDS, however how can I migrate metadata in EC2 for Redash v5 to RDS for redash v8?
odash
  • 1
0
votes
1 answer

Extract substring from column based on values from another table in SQL

In SQL (let's assume ANSI standard SQL), is it possible to extract a substring from one column, based on another table, and put this substring into another column? Example, from the following tables: VISITS name …
Jivan
  • 21,522
  • 15
  • 80
  • 131
0
votes
1 answer

How can I authenticate against ADXProxy using app key authentication?

I am trying to access an Azure Application Insights resource via Redash, using the (preview) ADXProxy feature. I've created an App Registration in Azure, and I've got some proof-of-concept python code which can successfully access my Application…
Peter
  • 3,619
  • 3
  • 31
  • 37
0
votes
1 answer

Redash - Change Postgres connection port

Is it possible to change the port Redash connects to Postgres? I had initially set-up Redash successfully and connected to Postgres, but after a few days, it was impossible to start Postgres on port 5432. I even tried reinstalling but it forcefully…
Christopher Kinyua
  • 160
  • 3
  • 13
0
votes
3 answers

convert '19th October 2018' into date in Presto/SQL

I have a column of strings which have been extracted from email content. The strings are in the format:- Tuesday 12th March 2019 I can use split_part to drop the Tuesday (anything up to and including 'day' is cut) but that's a lot more difficult…
Barry Evans
  • 23
  • 1
  • 5
0
votes
1 answer

MongoDB Redash - FieldPath field names may not contain '.'

I am new to mongodb. I am trying to take the daily count. I want count of those element where the fields I_C or L2_C exist and for the last 3 months. I have written this code, but it is showing error - "FieldPath field names may not contain '.'".…
Pranjal Mundra
  • 1
  • 2
0
votes
1 answer

Jupyter with Redash Dynamic Query

this is my demo of Redash's data. and here is my Jupyter demo code: from redash_dynamic_query import RedashDynamicQuery import pandas as pd import json redash =…
Sang Trần
  • 2,147
  • 4
  • 13
  • 20
0
votes
2 answers

How to Use regular expression in Redash Mongo Json Query

I have MongoDB as Data source. I want to query in redash which will be the equivalent following:- db.collection.find({“templateId”:/XYZ$/}) This query return all data from the collection where key templateId end with string XYZ. How can I use the…
Munish Kumar
  • 1
  • 1
0
votes
1 answer

HTTPS on a custom port other than 80 and 443

I have a website, let's say example.com (Apache, Ubuntu 16.04) I've installed Letsencrypt and the site is accessible via HTTPS. On the same server, I have Redash running and that is accessible via port 90. So, to access Redash, I go to…
Silver Ringvee
  • 5,037
  • 5
  • 28
  • 46
0
votes
1 answer

Convert a list in day,H-M-S to Hour format in postgresql

Convert my entire list which is in days , hours-min-sec FORMAT TO only hours which is a whole number because I need to calculate the median of the new list. For each product id the number of hours is calculated. I have only pasted a bit of my list.…
Kaushika Potluri
  • 31
  • 5
0
votes
1 answer

Redash How to create table visualization inside a table visualization

Is it possible to create a table visualization in Redash and when i click on a row it will collapse (or any other solution) and display a table of related data? For example if i created a table visualization of all customers in my database (one…
WalksAway
  • 2,769
  • 2
  • 20
  • 42
0
votes
1 answer

Not able to connect mongodb via redash

I am trying to connect to mongodb to redash from local machine. 1) Both mongo and redash are on standalone system. 2) I am able to connect to mongo from terminal. Please see the my terminal details after, I login to it. rahul@rahul-VirtualBox:~$…
Rahul Singh
  • 918
  • 14
  • 31
0
votes
1 answer

How can I find median in sql

How can I find median in sql. I am trying select date, sum(amount), median(amount), count(user) from table group by 1 It shows an error that function median(double precision) does not exist
Avinash Kumar
  • 101
  • 1
  • 1
  • 4
0
votes
0 answers

How to upgrade the redash that running on ECS of AWS?

Hi，I don't know how to upgrade redash ,my redash is running by ECS on AWS and it depends on redis and rds that run on AWS too. I pulled redash from docker hub and run it by ECS on AWS,I look into this website…
Wloverine
  • 61
  • 1
  • 1
  • 4
1 2 3
…
9 10