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

Install python libraries on all openshift pods

I have a redash server deployed on an on premise openshift cluster, with about 20 pods. I want to install new python libraries on the server and I'm able to ssh to one of the pods using oc rsh and run pip install x. The problem is that I have a lot…
Toronto Boy
  • 3
  • 1
0
votes
1 answer

Redash in AWS EC2

Can anyone list out the steps for running redash in AWS EC2? The redash home page provides the AMI ids but does not give clear information on what the steps are after the EC2 instance is UP. Goal: Need to run redash in an AWS EC2 instance
Tharun Kumar
  • 363
  • 3
  • 5
0
votes
2 answers

Redash Docker installation problem: sqlalchemy.exc.OperationalError: (psycopg2.OperationalError)

I'm trying to install Redash on Ubuntu 20.04.1 I used this method of installing: https://github.com/getredash/setup I downloaded the files I cd in to the folder I run 'sudo ./setup.sh' I get the following error: Traceback (most recent call…
Joka
  • 55
  • 9
0
votes
1 answer

SQL WHERE Clausule to get rows depending on the database content

Use case: I have the customer_id and the task_id. The database will always contain registers with a filled customer_id and empty task_id. Sometimes will have the task_id filled. (as the example below) Example 1 SELECT * FROM table WHERE…
Ailin Albertoni
  • 83
  • 1
  • 2
  • 7
0
votes
1 answer

How to see Redash code changes right away instead of building entire modules each time?

I am working on customizing a visualization in redash. Whenever I do a change I don't see the change immediately. Instead I'll have to execute npm run build and build the modules again. That building step is consuming a lot of time. Is there any…
CodeFan
  • 11
  • 2
0
votes
1 answer

How to query the longest streak of dates from today to the past on all tables in a db

The problem: I'm trying to create a viz on redash using the summary of historical data I have on a mysql db. I found it heavily dependent on SQL and I found the python support not so easy to manage. It happens that I have a few tables in a db that…
alfablac
  • 55
  • 6
0
votes
0 answers

I want to join these 2 following queries into one query. I am using MySQL and Json_Extract_scalar to retrieve json object data

Query 1: select distinct ifnull(concat(UPPER(JSON_EXTRACT_SCALAR(Profiles.DATA,'$.firstName')) , ' ', upper(JSON_EXTRACT_SCALAR(Profiles.DATA,'$.lastName'))),"-") AS VendorName, ifnull(UPPER(JSON_EXTRACT_SCALAR(Product.DATA,…
bhakti vyas
  • 1
  • 1
0
votes
1 answer

Using Match exp with objectId in MongoDB

I am creating a query with a variable to add a key and corresponding to the key I need to check if the mentioned id is equal to owner id. I used this code with names and it works fine but for Object Id, I am facing errors. I tried toObjectId…
swapnilindahood
  • 107
  • 2
  • 9
0
votes
1 answer

React native pinch zoom with redash and reanimated

I'm just trying to scale the image with pinch zoom using reanimated and redash. I followed this tutorial But the component that I grab stays on top of the previous but under the next component. I know It's a bit complicated explainatory. For that I…
Ozzie
  • 475
  • 1
  • 5
  • 20
0
votes
1 answer

On a redash dashboard, what causes "Error running query: 100035 (22007): Timestamp 'd_yesterday' is not recognized"?

On a Redash application instance backed by a Snowflake database, I've got a dashboard set up with a number of queries, each of which take a parameter of type date named startDate. Each of my queries are coded to apply the dashboard's selected date…
Jon Schneider
  • 25,758
  • 23
  • 142
  • 170
0
votes
1 answer

Best approach to ocurrences of ids on a table and all elements in another table

Well, the query I need is simple, and maybe is in another question, but there is a performance thing in what I need, so: I have a table of users with 10.000 rows, the table contains id, email and more data. In another table called orders I have way…
burdk
  • 79
  • 12
0
votes
0 answers

Integrate Redash metadata with Snowflake

I have integrated Redash with Snowflake as one of the data sources. We get value of parameters such as query_id, query and user_name in Redash metadata table events which gives us all the metadata related to queries executed on Redash…
karu07
  • 126
  • 8
0
votes
1 answer

Update query for Mongo document in Redash

I am trying to look for a query to update a record in Mongo document using Redash. I came up with the following query but it does not work. Can anyone please help? What I know about Redash is that it uses Pymongo. { "collection": "Application", …
Sohail Ahmed
  • 1,047
  • 1
  • 11
  • 27
0
votes
1 answer

I am working on a dashboard where I ask for a date and query results for previous 30 days

I am working on a dashboard where I ask for a date and query results for previous 30 days. I am trying to use the dateadd function but it is throwing the error month cannot be resolved. Here the end date part is parameterized. I am not a pro at this…
SHIWANGI PRIYA
  • 1
  • 1
0
votes
1 answer

SQL query cannot use NOT LIKE to get results

I am starting out in SQL and am trying to do a query that will select all event names that are unique and do not have 'TODAY-XXXXXXXX' in the value for the event_name column. I have a query that works fine for getting the unique values from the…
MNM
  • 2,673
  • 6
  • 38
  • 73
1 2 3
…
9 10