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
0 answers

Is there a way to split an array type in SQL (e.g. split function in python)?

Hi all I am trying to run an analyses on a table with a column that is an array on redash. I am trying to split the array so that I only grab the second element and create a new column. When I run the desc function to describe the column I get the…
Tiktok Master
  • 1
  • 1
0
votes
0 answers

Redash customization

I have redash set up on aws using the ami, I was wondering if I can change the redash logo on the ui? Also can I change the redash name to any of my choice? If so, what are the steps? As I can’t seem to find it anywhere online. I tried editing the…
bilal hussain
  • 1
0
votes
0 answers

Add MongoDB in Redash Error: Unsupported OP_QUERY command

When adding a new Data Source to a fresh Redash installation (I installed it in Docker via their install script), I get the following Error when testing the Connection: Connection Test Failed: Unsupported OP_QUERY command: connectionStatus. The…
Christopher
  • 31
  • 5
0
votes
0 answers

Redash google login

I am using redash/redash:10.1.0.b50633 version. I want co-workers to log in my redash server with company's domain. I tried the docs below enter image description here but when I try to do NO.5, enter image description here I can't find the box…
이윤택
  • 1
0
votes
0 answers

Installing helm Redash on Minikube return Error(redash-scheduler container redis connection error)

I tried to set up Redash on a local environment using Minikube and Helm, but encountered an Two errors. The Minikube cluster is configured with 4 CPUs and 8GB of memory. The Helm Redash URL used is…
specialscene
  • 73
  • 4
0
votes
0 answers

Redash python - conditional result

I badly need help. I've been searching codes around but couldn't find any. in redash, using Python, I can get the query result by using get query result the sample result would be: | WEEK_OFF | EMAIL | STATS | | --- | --- | --- | | 2023-03-06 |…
Chadd Dumagas
  • 11
  • 3
0
votes
2 answers

How to determine if a json field exists within an array in presto?

If I have a field jsonCol which has list of json objects, for example: [{'name': 'fieldA', 'enum': 'someValA'}, {'name': 'fieldB', 'enum': 'someValB'}, {'name': 'fieldC', 'enum': 'someValC'}] Another row may look like: [{'name': 'fieldA', 'enum':…
skbrhmn
  • 1,124
  • 1
  • 14
  • 36
0
votes
0 answers

-ERR wrong number of arguments for get command - Redis server error

I am trying to install redash version 10.0.0 without docker. There is a script for that in the redash forum (https://discuss.redash.io/t/bring-back-bootstrap-sh/2436/12) and this is for redash 5.0, but I had modified that for Redash 10. (I have…
Slavcho Spasenoski
  • 1
0
votes
0 answers

Webscraping Redash with Google Appscript

I would like to scrape parts of a Redash query output and place it in a google sheets file. Since I cannot use the function IMPORTXML(), I tried to write a script in Appscript. It seems to work with other websites, but not with Redash. Either…
Ilovearcticmonkeys99
  • 15
  • 3
0
votes
0 answers

Redash create new dataSource with Oracle Database

I have a problem I would like to create on redash a dataSource to a database on oracle but there is a problem that pure redash does not offer this, so I try using the configuration from this git…
magic_man_12
  • 1
  • 2
0
votes
1 answer

I need to categorize my customer for eligible for bonus and Ineligible based on orders count

I have 2 tables, the first one is Orders as the following: Customer_ID ORDER_ID STATUS A 11 completed A 12 completed B 13 completed B 14 completed B 15 completed C 16 completed B 17 cancelled A 18 cancelled And the second…
Nancy Elhossiny
  • 1
  • 1
0
votes
0 answers

Redash cannot connect to MySQL server through socket

I want to connect redash to MySQL Server. I added MYSQL_TCP_PORT for server to use TCP connection, not default UNIX socket (to avoid mysqld.sock error). If I go to mysql container and mysql -p - I can open mysql shell. But If I test connection in…
Alexey
  • 185
  • 12
0
votes
0 answers

How to establish a connection to a remote Redash database using R?

I want to use R, and specifically the {DBI} package, to access a remote Redash DB. Typically, DBI requires to establish a connection first. Such as: # taken from: https://r4ds.hadley.nz/databases.html#connecting-to-a-database con <- DBI::dbConnect( …
Emman
  • 3,695
  • 2
  • 20
  • 44
0
votes
0 answers

Supervisord services healthcheck with eventlisteners

I am using redash where supervisord is used for process management of redash workers. It is using supervisord eventlistener for healthchecks. Source :…
SRJ
  • 2,092
  • 3
  • 17
  • 36
0
votes
2 answers

I want all retrieve all data of customer within a radius with longtude and latitude of 1 km

I'm using redash and my table looks something like this. I'm just learning sql. This is very advanced for me. I searched many questions, no queries worked for me |user_id | long | lat | |1 |31.000|26.000| |2 |30.000|25,000| |3 …
Nanosa
  • 3
  • 3
1 2 3
…
9 10