metabase / metabase/macaw

Multiline string using $REDSHIFT$ token is not supported

Open
#76 1 comment 0 reactions 0 assignees View on GitHub
.Team/BackendComponents bug
Dominant language
Clojure
Stars
23
Forks
4
PR merge metrics
No merged PRs in 30d

Description

Example query:

```sql
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

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the reported SQL example and the repository’s JSqlParser integration, then reproduce parsing of the $REDSHIFT$-delimited multiline string. Done means the query parses successfully and a regression test covers this token format.

Written by the indexing model from the issue text.

Assessment

Tech stack
clojure, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.