metabase / macaw

A Clojure wrapper for JSqlParser 🦜
Eclipse Public License 1.0
12 stars 1 forks source link

Multiline string using $REDSHIFT$ token is not supported #76

Open crisptrutski opened 4 months ago

crisptrutski commented 4 months ago

Example query:

select *
from dblink('hosting_insights',$REDSHIFT$
    SELECT distinct hm_user.company
    FROM metabase_database
    LEFT JOIN hm_hosted_instance
      ON metabase_database.etl_source_instance_id = hm_hosted_instance.id
    LEFT JOIN hm_user
      ON hm_hosted_instance.owner_id = hm_user.id
    WHERE metabase_database.is_sample = FALSE
$REDSHIFT$) as t1(customer text)

Interestingly enough, this is a :postgres query on Stats...

Queries affected on Stas: 93

crisptrutski commented 4 months ago

We're not working on this right now, as the feature is less likely to be used by our customers relative to its use in our own server.