Hi everyone, I'm getting an error once I try to run

gd deploy

using the version

0.9.0

. The error is with a metric I'm putting the definition of below:

# A metric is a computational expression of numerical data (facts or other metrics).
# Use MAQL to create reusable multidimensional queries that combine multiple facts and attributes.
# Read more about MAQL:
# <https://www.gooddata.com/developers/cloud-native/doc/cloud/create-metrics/maql/>

type: metric
id: variants_count_mediocre_fit

title: Variants Count Mediocre Fit

maql: SELECT COUNT({label/variant_euid}) WHERE (SELECT{metric/imbalance_abs} BY {label/variant_euid}) BETWEEN 0.25 AND 0.5
format: "#,##0"

The error is:

Type mismatch: Expected 'ALL', but got 'NUMERIC_LITERAL'

. I'm getting this error for all the metrics that use BETWEEN in its maql. Can someone help why I'm getting this error? (The metrics are working as expected in the UI)

Hi Emir, please note that the VSCode extension is an experimental feature and still currently being worked on. We are trying to reproduce the error on our end, but we cannot at this time. The below screenshot illustrates this. Would you be able to provide a link to the workspace where you are seeing this?

Hi Joseph, got a similar error when deploying a visualization I created in the UI. It works as expected in the UI but the deployment fails with the error below:

Can not load table from server for profile "fc_dev_ng". Reason: DB request exception (state=GENERAL_ERROR dataSourceId=dbt_project-eltana_stg vendorErrorState=GENERAL_ERROR vendorErrorCode=3) General errororg.postgresql.util.PSQLException: ERROR: syntax error at end of input
      Position: 3456

Could you shed light on why/how it works in UI but throws an error during deployment? (I deploy via the

gd deploy

command). Let me know if more info is needed, I can share the file contents in a private message. Thanks in advance!

The error comes from validating the SQL dataset itself. We would need an SQL dataset yaml file to see if there is something suspicious. Could you send that in a private message please?