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.
Questions tagged [redash]
140 questions
1
vote
0 answers
could not send SSL negotiation packet: Resource temporarily unavailable
We are using a Redash AMI hosted on an ec2 instance, and suddenly while executing a query our instance got crashed, After rebooting the instance the Redash server was up and running but now while running queries we started getting this could not…
yadu singla
- 51
- 8
1
vote
0 answers
Redash query join with another query have big data
I am working with Redash, and I need join data from another database, Redash have good feature to do this:
-- query_1
SELECT id, name, company_id
FROM users
-- query_2
SELECT id, name, created_by_id, company_id
FROM product
And another query…
DragonPow
- 39
- 6
1
vote
0 answers
How do we disable Postgres database in Redash?
We are exploring Redash. For that, we deployed it as a Kubernetes service. Everything worked as expected. We also configured an external Postgres database instead of the embedded Postgres (which comes with Redash itself). It also worked as…
Aftab
- 2,863
- 32
- 41
1
vote
0 answers
How do i use $in and $exists in redash json query?
I have the collection "students" with following documents:
{
"name": "A",
"isAlumni": false,
"info": {
"number": 123456789,
"bloodGroup": "O+"
}
},
{
"name": "B",
"isAlumni": false,
"info": {
"number":…
MorbidScroll
- 25
- 7
1
vote
0 answers
Redash container broke on "worker" in Fargate
I use the recommended Redash docker image , docker-compose tested locally, all services are up & running. (server, scheduler, worker, redis, postgres) http://localhost:5000/setup is up and running
% docker-compose up -d
Docker Compose is now in the…
netthing
- 47
- 1
- 8
1
vote
1 answer
Trying to all rows from 4 different tables, Clickhouse doesnt detect table when using union all
So I have 4 subtables all the same schema and I want to show all rows between all the tables so I can have redash convert it into a chart
My current idea was to just have chain of union all, but for some reason, clickhouse doesnt think it…
ewcvis
- 139
- 2
- 11
1
vote
1 answer
How do I write an efficient query to retrieve phone numbers attached to an ID?
I'm new to SQL and Redash, and I'm currently working on a query that retrieves phone numbers given the ID as shown below
SELECT "ID", "Phone_Number"
FROM Table
WHERE
"id" = '7559' OR
"id" = '1754' OR
"id" = '8679' OR
"id" = '6606' OR
....
....
"id"…
The Singularity
- 2,428
- 3
- 19
- 48
1
vote
2 answers
Why is "AND NOT field = 'value'" filtering out nulls?
My query looks basically like
WITH DATA AS(
SELECT fields
FROM table
WHERE [many conditions]
AND NOT field1 = 'string'
)
SELECT foo,
bar,
CASE
WHEN field1 IS NULL THEN 'other_string'
[other…
Skaramuche
- 87
- 4
1
vote
1 answer
Setting up Redash Instance in private subnet. EC2 status check failed
Issue Summary
I would like to set up Redash Instance in private subnet, but it didn’t work well. The instance status check is “1/2 failed”.
The question is whether there is some necessary setting in addition to the setting introduced in the…
斯波隼斗
- 25
- 6
1
vote
1 answer
Is there a better alternative to writing multiple subqueries in SQL?
I am querying on Redash to extract an aggregate list of parking places with a pricing grid. The listing table consists of parking details (Name, address, link) and multiple pricing columns depending on duration of stay.
I am using two tables (park…
Keedaman
- 23
- 4
1
vote
1 answer
Redash: Unable to send invitation/passowrd reset mails
After setting the email env variables as per https://redash.io/help/open-source/setup (for AWS SES)
sudo docker-compose run --rm server manage send_test_mail
works, and I receive the email as well.
But invitation emails do not get sent.
On trying…
Sudhanshu
- 457
- 5
- 18
1
vote
1 answer
How to insert query filter based on count result in redash
it is a simple question I believe, but as I'm not familiar with redash it seems hard.
I have a query in redash,
SELECT si.variant_id,
v.sku,
COUNT(CASE
WHEN a.viewable_type = 'Spree::Variant' THEN a.id
…
Nur Atiqah
- 105
- 10
1
vote
0 answers
MongoDB aggregation transformation
I have a MongoDB, which is used in Redash to query some data. For a Funnel i want to display via Redash i have a MongoDB query that results in something like this
X Y Z
20 10 35
But actually the Funnel Chart in Redash requests a table that…
Andreas
- 36
- 3
1
vote
1 answer
Unexpected flickering when using react-native-redash
I'm new using react-native-redash to perform some animations based on react-native-reanimated library (which is awesome in terms of performance).
My code is the following:
const Alert = (props) => {
const [visible, setVisible] =…
emmab
- 31
- 1
- 6
1
vote
2 answers
I'm new to SQL and thinking is there any way to simplify this Query?
Im really new to SQL, doing this for my basic needs for works and basically I'm not a tech guy. But I'm curious to know is there any way to simplify my SQL Code here:
SET sql_mode = '';
SELECT DISTINCT partner.kode_agent,
…
Dimitri Dwi Putra
- 11
- 1