malloy

malloy copied to clipboard

Improve expand/modify experience for nested queries, including expansion, add limit, filter, or ordering

2

Today, we cannot add limits, filters, or orderings to nested queries without first duplicating them. This is due to a limitation of the Malloy structdef format in which a refinement...

christopherswenson

How to connect and exist db

1

I try to connect existing duckdb db. cant figure how to. here is what i have done so far 1. in the setting setup the connection and test success. 2....

jayhuang75

SQL generation error with `where` clause

2

Reported on [this Slack thread](https://malloy-community.slack.com/archives/C025JAK8G0N/p1690984595371989): Model: ``` source: postal_location is table('RFU:rfu_owner.postal_location') extend { primary_key: id } source: scenario is table('RFU:rfu_owner.scenario') extend { primary_key: id join_one: postal_location with postal_location_id where: delivery_date...

carlineng

including them.

narreola

`index:` queries currently generate columns `fieldName`, `fieldValue`, and `fieldType`. Everywhere in Malloy documentation we use snake case names by convention. So we should probably change these to be `field_name`, `field_value`,...

christopherswenson

Default plotting choose the Y scale automatically according to the numbers. Would it be possible to add an option to let the X/Y scale start at 0 ?

Ben8t

``` sql: one_sql is { select: """SELECT 1 as one""" connection: "bigquery" } query: from_sql(one_sql) -> { project: * calculate: s is lag(one) } ``` Error: `PROJECT cannot be used...

christopherswenson

Hierarchies can be represented through the notion of parent_id in tables but it involves the need to create recursive joints to walk up the parents or walk down the children...

szawadski

This query doesn't produce correct results. percent_of_queries doesn't include the nested where filter. ``` # dashboard run: jobs -> { where: is_query group_by: user_email aggregate: query_count nest: dataset_queries is {...

lloydtabb

Tracking for Renderer - samples conversion

2

# numbers Looker's value format is pretty great. It looks like they are using link below https://cloud.google.com/looker/docs/reference/param-field-value-format. https://github.com/borgar/numfmt ``` # value_format="$#.00;($#.00)" measure: total_revenue ``` # durations Result columns often contain...

lloydtabb