I am using parameters in Amazon Redshift, so that I can pass them directly from Dashboard. The query works in Data Prep but Dataset fails with Import Error.
The parameters:
DateFrom – Day – 2024-01-01
DateTo – Day – 2025-01-01
The query:
<code>SELECT org_uid, COUNT(DISTINCT item_uid) as active_items
FROM organizations_activity
WHERE item_updated_at BETWEEN <<$DateFrom>> AND <<$DateTo>>
GROUP BY org_uid
</code>
<code>SELECT org_uid, COUNT(DISTINCT item_uid) as active_items
FROM organizations_activity
WHERE item_updated_at BETWEEN <<$DateFrom>> AND <<$DateTo>>
GROUP BY org_uid
</code>
SELECT org_uid, COUNT(DISTINCT item_uid) as active_items
FROM organizations_activity
WHERE item_updated_at BETWEEN <<$DateFrom>> AND <<$DateTo>>
GROUP BY org_uid
Query works fine and shows results apply it with Auto-preview in Data Prep. But saving dataset fails:
<code>Refresh error details
Error type: 0 Learn more
Error details: ERROR: syntax error at or near "$" Position: 411
</code>
<code>Refresh error details
Error type: 0 Learn more
Error details: ERROR: syntax error at or near "$" Position: 411
</code>
Refresh error details
Error type: 0 Learn more
Error details: ERROR: syntax error at or near "$" Position: 411
I tried to replace <<$DateFrom>> and <<$DateTo>> constriction with :DateFrom and :DateTo construction, but in this case I get syntax error already in Data Prep stage.