SQL API: ERROR: Type "TIMESTAMP" is not supported for parameters decoding

[gasperkoren]

Describe the bug
I'm connecting to Cube Core from Metabase via SQL API

In Cube 1.3.36 parametrized queries with timestmmp started failing.

Metabsse returns the following error:

ERROR: Type "TIMESTAMP" is not supported for parameters decoding

Relative time filters, i.e. Yesterday or Last 30 days work OK.

To Reproduce
Steps to reproduce the behavior:

1. Connect Cube and Metabase
2. Create a query in Metabase using UI Query Builder and add Filter to a timestamp colum using Fixed date range ... option and then select After and select date i.e. January 1, 2025

Expected behavior
Query should be executed without error

Version:
1.3.36 and 1.3.37

Additional context
This works fine in version 1.3.35

I've tested this with Metabse v0.55.6 and v0.55.7 and Cube 1.3.35 (works ok) 1.3.36 (fails) and 1.3.37 (fails)

[igorlukanin]

Hey @gasperkoren 👋

Could you please show the SQL that Metabase generates after you do the 2nd step?

[gasperkoren]

Hi @igorlukanin

I'm not sure what exactly Metabase sends to the psql API when using parameterized queries (i.e. queries built via the Metabase UI with filters, where values are passed as parameters rather than hardcoded).

Metabase only shows the non-parameterized SQL version in the UI, which works fine when run directly as a raw SQL query.

However, when I look at the Cube logs, I see something like this for a parametrized query that fails:

SELECT
  t."field_1" AS "field_1",
  t."field_2" AS "field_2",
  t."field_3" AS "field_3"
FROM
  schema_name.table_name AS t
WHERE
  t."timestamp_field" >= $1
  AND t."timestamp_field" < $2
LIMIT 2000;

In contrast, this version of the same query works as expected because the filter values are explicitly casted:

SELECT
  t."field_1" AS "field_1",
  t."field_2" AS "field_2",
  t."field_3" AS "field_3"
FROM
  schema_name.table_name AS t
WHERE
  t."timestamp_field" >= CAST(CAST((NOW() + INTERVAL '-30 day') AS date) AS timestamptz)
  AND t."timestamp_field" < CAST(CAST(NOW() AS date) AS timestamptz)
LIMIT 2000;

Is tere another way how can i intercept what Metabase is sending to Cube that would give you more details?

[ovr]

It's a bug, not supported, I will prepare a fix for that.

[gasperkoren]

I confirm that this issue has been resolved. Thanks 🙇

[pfrry]

Hello @ovr 👋 ,
The issue is resolved with Timestamps, but not with DATE: ERROR: Type "DATE" is not supported for parameters decoding

[ovr]

@pfrry, where do you see this error? Do you use Metabase?