Skip to content
This repository has been archived by the owner on Oct 15, 2022. It is now read-only.

Macro endcode error #15

Open
thuybt opened this issue Oct 19, 2021 · 2 comments
Open

Macro endcode error #15

thuybt opened this issue Oct 19, 2021 · 2 comments

Comments

@thuybt
Copy link

thuybt commented Oct 19, 2021

Dear Fabrice,
I recently use dbt-dremio to create some table in my bucket on gcs,
And it encounter these problem.
It stuck on macro query
`/* {"app": "dbt", "dbt_version": "0.19.0", "profile_name": "dremio", "target_name": "dev", "connection_name": "list_\u202aonemg-dp-np-gcs"} */

with schemata as (
    select lower(case when position('.' in schema_name) > 0
            then substring(schema_name, 1, position('.' in schema_name) - 1)
            else schema_name
        end) as catalog_name
        ,lower(case when position('.' in schema_name) > 0
            then substring(schema_name, position('.' in schema_name) + 1)
            else 'no_schema'
        end) as schema_name
    from information_schema.schemata
)
select distinct schema_name
from schemata
where ilike(catalog_name, '‪onemg-dp-np-gcs')
  -- and schema_name <> 'no_schema'`

No results have been displayed.
But when I retype the query, it still show some results. Photos are shown below, I have identify that those query are encrypt in differents code on acsii key. Which means, can you fix this problem and/or add some config so that I can config the type of encryption on the query, please.
Screen Shot 2021-10-19 at 16 42 45
Screen Shot 2021-10-19 at 16 46 42

@fabrice-etanchaud
Copy link
Owner

Hi @thuybt , thank you for using dbt-dremio.
Could you please provide me with a excerpt of the dbt log ?
Thank you !

@fabrice-etanchaud
Copy link
Owner

Hi @thuybt , any update on that issue ?
Best,

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants