Can't call transformers in Retool Database Query

💬 Queries and Resources
3

Here's another possible clue:

CleanShot 2024-01-20 at 17.51.00@2x
CleanShot 2024-01-20 at 17.51.00@2x996×1292 89.7 KB

Here's the text SQL query it generates:

SELECT 
  shop_id,
  initial_utm_content, utm_content,
  initial_utm_source, utm_source, 
  initial_utm_term, utm_term,
  initial_utm_campaign, utm_campaign,
  initial_utm_medium, utm_medium,
  initial_referrer, referrer,
  how_did_you_hear_about_archive, 
  where_did_you_hear_about_us
FROM 
  temp_shop_channels
WHERE 
how_did_you_hear_about_archive LIKE 'Instagram';

Strangely, when I run the query without the transformer (literally pasting that directly in the retool query editor and running it), it works fine.