OHDSI / OHDSI/WebAPI

/ddl/achilles SQL code fails in Snowflake

Open
#2,197 6 comments 0 reactions 1 assignee View on GitHub

@ssuvorov-fls is already working on this.

Since Jan 31, 2023.

bug
Dominant language
Java
Stars
151
Forks
183
Avg merge
14m
Merged PRs (30d)
2

Description

Expected behavior

SQL code generated by endpoint
/WebAPI/ddl/achilles?dialect=snowflake&schema=RESULTS&vocabSchema=CDM
Produces vaid SQL code

Actual behavior

SQL code fails on "with as ... insert" as "with as ... select" is supported only

Steps to reproduce behavior
  1. Get generated code from endpoint
  2. Run in Snowflake console

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.