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

Embed external image or html iframe into a redash dashboard

Anybody managed to embed external html (iframe) or image into a Redash dasboard? The problem is discussed here on the Redash support forum, but havent seen a working solution yet: https://discuss.redash.io/t/embed-external-iframe/675/5
bpgergo
  • 14,789
  • 2
  • 37
  • 60
0
votes
0 answers

Hive and redash

How do I enter the host and port to connect the hive to redash, I have entered a lot of numbers but still cannot connect
huy manh
  • 1
  • 1
0
votes
0 answers

Redash Dashboard counter

I would to ask on how to make the actual value counter in Redash dashboard to show green instead of red as shown below. The logic is that, if the actual value below the target value. It is considered good.
Nur Atiqah
  • 105
  • 6
0
votes
0 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
  • 45
  • 7
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
  • 93
  • 1
  • 2
  • 7
0
votes
0 answers

Error: Connect SQL Server read replica with Redash

I am trying to establish connectivity between SQL Server read replica with Redash but getting connection error and it requires to set the property ApplicationIntent=ReadOnly. Here is link to error screenshot: Error Snapshot I am not sure how to set…
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
0 answers

Redash DB migration from legacy 0.11.* to Redash v8.0

I’ve a question here, I’ve been trying to migrate Redash database from old version of 0.11.* to fresh version 8+. So far I’ve only came to learn how to break the server in number of different ways… Closest post that I’ve found, that covers part of…
Vadim Osipov
  • 21
  • 1
  • 4
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

loop through a result set in redash

Is there any way to loop through something in redash? I tried using a cursor but it doesn't seem like it's supported. If I had to loop through [1, 2, 3] and had to run a query with each parameter is there a good way to do this in redash?
Dty
  • 12,031
  • 4
  • 40
  • 60
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,…
0
votes
0 answers

Adding new custom visualization in redash

In order to create a new visualization the env variable REDASH_FEATURE_ALLOW_CUSTOM_JS_VISUALIZATIONS has been set to true in redash/redash/settings/init.py. I want to show a custom plotly chart within redash. What is the next step to be done in…
CodeFan
  • 11
  • 2
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…
0
votes
0 answers

redash access error from its python API on databricks

I am trying to access redash from its python API, which was downloaded from https://pypi.org/project/redash-api-client/ My py3 code: from redashAPI import RedashAPIClient as RAC API_KEY = 'xxxxxxxx' # (got from redash query page) REDASH_HOST =…
user3448011
  • 935
  • 8
  • 19
0
votes
0 answers

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
  • 165
  • 1
  • 11