I'm using python with redshift_connector, and analysing the data with pandas. When accessing a redshift db with selecting n columns, I got i lines. However when I wanted to add a new column to this query, it timed out after…
I'm updating table_A with a variable, new_var, pulled in from table_B. Both table_A and table_B are in the same schema. alter table schema.table_A add column new_var varchar(3) update schema.table_A set schema.table_A.new_var = schema.table_B.new_var from schema.table_B where schema.table_A.record_id = schema.table_B.record_id However,…
I have the following dataset: create schema m; create table m.parent_child_lvl_1(customer_id,date,order_type,order_id,sub_id) as values (108384372,'18/09/2023'::date,'sub_parent_first_order',5068371361861,407284605) ,(108384372, '13/11/2023', 'sub_order', 5134167539781, null) ,(108384372, '8/01/2024', 'sub_order', 5214687526981, null) ,(108384372, '4/03/2024', 'sub_order', 5283166126149, null) ,(108384372, '18/06/2024', 'sub_parent_order', 5421811138629, 500649255) ,(108384372, '12/08/2024', 'sub_order', 5508433641541, null) ,(108384372,…
I'm looking for assistance with writing a PostgreSQL query in Apache Superset. I have metered consumption data, where the meters have unique IDs. Normally, a meter is read at the start of every hour, and the difference is calculated in…
This might be a bit elaborate so please bear with me. I'm looking to create a new column free_duration in a table that currently looks like this, when grouped by country and product in ASCENDING order of month- month country…
I am using AWS Redshift. I have a table that looks like this: Id key value1 value2 value3 1 xxx A NULL NULL 1 xxx NULL B NULL 2 uuu NULL NULL C If the id is repeating, the entire…
I found that aliasing using the '=' format is not working in AWS Redshift. Is there any possible way to resolve this without changing on existing query? In SQL Server: select fileid AS ID from tableA -- Working select [ID]…
Struggling a while with passing an array parameter for a simple Redshift (Postgres8) query like this: // Example: $sql = "select * from country where country_code IN ($1) LIMIT 10"; $params = ["'GB','US'"]; pg_send_query_params($conn, $sql, $params); Redshift engine does not…
I am working on a transaction dataset with one date column & one identifier column. Now retroactively I want to create a boolean column to check whether any particular activity (e.g. marketing campaign) should have been sent for that identifier…
1/ I am using SQL on AWS and trying to detect quickly when a Json object has key-value in it. Anyone knows it? Thanks For example: A. {"context":{"abc":"123"} --> Yes B. {"context":{}} --> No Note that I don't know in…