We are using Qlik Replicate for replicating data from RDS Postgresql to Synapse. There is logical replication slot involved in this process, so here is the case when we start the replication, the slots size be in MBs and then…
I have stumbled upon a peculiar phenomena in an SQL select: select 1 , ui as row_value , ui is null as "ui is null" , ui is not null as "ui is not null" from user_info ui where ui.user_id…
I have a table named tbl_user_complete and a query like this: user_id bill_id complete_date user_1 bill_1 2024-01-14 user_1 bill_2 2024-02-14 user_1 bill_3 2024-05-01 user_2 bill_4 2024-01-03 SELECT user_id , bill_id , MAX(complete_date) AS complete_date FROM tbl_user_complete GROUP BY user_id; I…
I have requirement where bash script will pass on the string consisting tables names to anonymous PL/pgSQL block which will process the tables if they exists in the Postgres db. Below is the PL/pgSQL code assuming given_tables variable has the…
How can i annotate field with RawSQL? sql_query = """ SELECT c.id, COALESCE(SUM((cm.temp_min + cm.temp_max) / 2 - %s), 0) AS gdd FROM agriculture_commune c LEFT JOIN agriculture_communemeteo cm ON c.id = cm.commune_id WHERE cm.date BETWEEN %s AND %s GROUP…
I have some entries like this: Distance Ids Zone Owner 331 [1,2,4] A ABU 200 [3,4,5] B ABU and I want to aggregate across them so that the distances sum, but then have a single array for ids that includes…
I am struggling with a Postgres slow query issue. Fixtures Consider the following fixtures: DROP TABLE IF EXISTS expectation; DROP TABLE IF EXISTS actual; CREATE TABLE expectation ( set_id int NOT NULL, value int NOT NULL ); INSERT INTO expectation…
I have this table column: I want the trailing numbers retrieved from the key names and stored in this manner: ID 1 2 3 4 I can retrieve it using: REGEXP_REPLACE((json_each_text(fixtures::json)).key, '.*?(d+)', '1')::int as ID But I want it retrieved…
I am trying to filter out data that is stored as strings but represents numeric values. I filter out non-numeric strings then convert to a float. I am then trying to filter values above or below a specific amount. Below…
I am working on custom types in sqlalchemy columns using TypeDecorator. I'm storing my data in JSONB inside Postgres DB, but in code I am serializing and deserializing it in a data class. But when I change any field of…