Unable to run queries with parameters

[lenabradley]

In databricks sql, I commonly use parameters (e.g. {{my_param}}, especially for queries that will power dashboards. These queries do not seem to work when run via this VSCode extension.

E.g. this query:

SELECT _id
FROM some_table
limit cast({{N}} as int);

works in DB SQL but when run from VSCode extension gives this error:

Something went wrong.
TypeError: messages.map is not a function

    in Unknown
    in div
    in ForwardRef
    in ForwardRef
    in Unknown
    in Unknown
    in div
    in Unknown
    in Unknown
    in Unknown
    in ErrorBoundary
    in ThemeProvider_ThemeProvider
    in Unknown
[Open VS Code DevTools](command:workbench.action.webview.openDeveloperTools)

[superdupershant]

Hi @lbartell! Currently that "parameters" feature is something that only works within the Redash UI in Databricks SQL. It's not a general feature of the SQL engine. That said we're working on some kind of first class SQL parameter support that works across all tools, it's just not ready yet.

[fjakobs]

Still we have to fix the error handling and not just crash.

[fjakobs]

Error handling should be fixed in #41

[fjakobs]