Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Preview generates errors when SQL blocks are invloved #97

Open
mtoy-googly-moogly opened this issue Mar 20, 2023 · 1 comment
Open

Preview generates errors when SQL blocks are invloved #97

mtoy-googly-moogly opened this issue Mar 20, 2023 · 1 comment

Comments

@mtoy-googly-moogly
Copy link
Contributor

mtoy-googly-moogly commented Mar 20, 2023

source: orig is table('bigquery:bigquery-public-data.google_cloud_release_notes.release_notes') {
  dimension: custom is 'CUSTOM'
}
query: first100 is orig -> { project: *; limit: 100 }
sql: to_sql is {
  connection: "bigquery"
  select: """
    SELECT *
    FROM (%{ ->first100 }% )
  """
}
source: back_to_malloy is from_sql(to_sql)
query: back_to_malloy -> { project: * }

Running the end query works, clicking "Preview" on "back_to_malloy" gets an error. SQL Blocks sit in the model in a weird way and however preview is generating a model to run the preview query, it is hitting into this problem.

@whscullin
Copy link
Contributor

I've created a branch for malloy (https://github.com/malloydata/malloy/tree/whscullin/bug-97) with a test that replicates the vscode behavior for (hopefully?) easier troubleshooting.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants