Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error while uploading metadata using Version 1.0.0b #156

Closed
foxmulder4223 opened this issue Aug 4, 2022 · 0 comments · Fixed by #160
Closed

Error while uploading metadata using Version 1.0.0b #156

foxmulder4223 opened this issue Aug 4, 2022 · 0 comments · Fixed by #160

Comments

@foxmulder4223
Copy link

Dear @NiallRees

I came across a very werid error, so please forgive me if I explain it a bit too complicated.

I integrated your 1.0.0b prerelease in our companys dbt project.
Run Versions:

dbt version: 1.1.0
python version: 3.9.13

- git: https://github.com/brooklyn-data/dbt_artifacts.git revision: 1.0.0b1

On MacOS and our Kubernetes Cluster everything works fine. Uploads are looking good and everything runs smoothly. And Windows it is a different story.
All models starting with an "u" are causing an error in the "upload models", even when my colleagues are startung models that aren't beginning with an u. Curiosly this error only occurs on windows machines after installing this prerelease.

11:21:17
11:21:17 1 of 1 START table model historical archive.test_model
11:21:19 1 of 1 OK created table model historical archive.test_model
11:21:19
11:21:19 Running 1 on-run-end hook
11:21:19 Uploading model executions
11:21:20 Uploading seed executions
11:21:20 Uploading snapshot executions
11:21:20 Uploading test executions
11:21:20 Uploading exposures
11:21:20 Uploading models
11:21:21 Uploading seeds
11:21:22 Uploading snapshots
11:21:22 Database error while running on-run-end
11:21:23 Encountered an error:
Database Error
001831 (42601): SQL compilation error:
error line 2,047 at position 16
Invalid unicode escape sequence
"\u'; should be exactly 4 digits

This is from the snowflake history of a colleague using windows.

'["model.edwdbt.cdscustomercreatedstn", "model. edw dbt. cdscustomercreated stn"]',
'dbt_projectname'
models\core integration\unsubscribe.sql
'hash_value'
'table'

And we can narrow it down to the modelname because in my history, when I (macOS) run a model the node line looks like this:

'models/core_integration/unsubscribe.sql',

Thank you very much and
regards
Daniel

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

Successfully merging a pull request may close this issue.

1 participant