malloy icon indicating copy to clipboard operation
malloy copied to clipboard

Cannot use a `project` and a `calculate` in the same query when the source is SQL

Open christopherswenson opened this issue 1 year ago • 0 comments

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 on queries with turtles

christopherswenson avatar Jul 06 '23 18:07 christopherswenson