search

starlake-ai / jsqltranspiler

Rewrite BigQuery, Redshift, Snowflake and Databricks queries into DuckDB compatible SQL (with deep transformation of functions, data types and format characters) using Java.
https://starlake.ai/starlake/
Other
28 stars 3 forks source link

scopeSchema not filled #32

Closed hayssams closed 2 months ago

hayssams commented 2 months ago

In the test testWithBQProjectIdAndQuotes in branch fix/backtics-intable-namesthe scopeSchema for the scopeTable customers and orders should be sales. They are currently set to an empty string.

SQL query used for th test:

with mycte as (
  select o.amount, c.id, CURRENT_TIMESTAMP() as timestamp1
  from `sales`.`orders` o, sales.customers c
  where o.customer_id = c.id
)
select id, sum(amount) as sum, timestamp1
from mycte
group by mycte.id, mycte.timestamp1
hayssams commented 2 months ago

It works like a charm ! Thank you