I have a plpython trigger function and I'm trying to log something in it to better understand what it does, but I can't manage to print anything on the postgres log file. I have tried different level of printing (error,…
goal draw first place to fifth place tickets. a user can't win multiple places. If a user hasn't placed, then all of their tickets must be considered in the draw. progress I can draw one winner, but not all five.…
I have a table in postgressql with column that holds an json object: create table test ( rec_id int generated by default as identity, usr_id int unique, format text[], syn_data jsonb, generation_date timestamptz); insert into test values ( 2, 144,…
I have my models configured as below: public class Order { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } public string UserId { get; set; } = null!; public DkUser User { get; set; } = null!; public int…
I have the following database table (PostgreSQL) create table audit_read ( level text, account_id uuid, message text ); I want to insert a database record when a logging event occurs. I have therefore the following configuration (properties file): appender.read.type =…
I was taking an online exam on postgre SQL. The first step is about cleaning data and there is a column named 'date1' in the text datatype and has a format as: YYYY-MM-DDT00:00:00.000. The requirement is to convert it to…
I have a table which has id and group_id foreign key. I want to create (N=2) buckets of equal size (approximately), such that all rows with given group_id end up in the same bucket. For example, given: id, group_id 1,1…
I'm trying to select from a snowflake source as shown below called "s_2020_09_history_logs" extract from staging model: with unioned_archived_history_logs as ( select * from {{ source('emspdb_archive', s_2020_09_history_logs) }} extract from _sources.yml: - name: emspdb_archive database: lake schema: emspdb_archiveschema tables: -…
I have a view that queries sales data into a condensed table which sums net_sales for each location. The problem i have is when there are sales after midnight. My code is grouping by Date so any sales after midnight…
please help me resolve this problem: below are my source defined under schema.yml (along with two other models) --> sources: - name: src_pizzas database: test_db schema: pizza tables: - name: src_sqlserver_pizzas columns: - name: size description: "The size of the…