malloy

malloy copied to clipboard

Between snowflake-sdk 1.9.0 and 1.11.0 seems like there are a few breaking changes 1) Statement type is replaced with RowStatement 2) Further StatementOption {parameter passed to execute} expects a 'complete'...

pavanka

Tried to replicate brand synergies code from Ecommerce in Motherduck examples. If it is embbeded in new source, it doesn;t work as it should (only first part of pipeline tested):...

wwasilak

run: postgres.sql('SELECT 1') failes in postgres (and presumably any db) without drop database permissions

2

### What happens? running any SQL like this seems to go through a path that attempts to `drop database` , resulting in an error if user does not have drop...

bporterfield

Blocked from using database function that should work

1

### What happens? Trying to use `array_agg!` on a dimension from a `join_many` but being told "Cannot use a scalar field in a measure declaration, did you mean to use...

bporterfield

Incorrect count of join_many joined rows (1s when should be 0s).

1

### What happens? ``` source: user is db.table('public.user') extend { primary_key: id measure: user_count is count() } source: chat is db.table('public.chat_message') extend { primary_key: id join_one: user on sender_id =...

bporterfield

### What happens? Imagine this cohort analysis: https://docs.malloydata.dev/documentation/patterns/cohorts but with a filter on the query (outside of the nest) to filter the user to specific country. This filter does not...

bporterfield

From @bporterfield: > I'm having trouble with charting and sparse data - I want to show a chart of usage across days, but using the bar chart tosses out the...

carlineng

### What happens? It's not uncommon to use uuid for primary keys, should be simple to support but not supporting means some annoying casting and confusing error messages ### To...

bporterfield

### What happens? When trying to use Accept or Except for a field that is nested, error 'extraneous input '.' expecting {ACCEPT,...' shows up.  ### To Reproduce code example:...

wwasilak

mtoy-googly-moogly