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

Undefined column Target_Role_Primary_Key_Physical_Name #24

Open
universe-designer opened this issue Feb 16, 2024 · 1 comment
Open

Undefined column Target_Role_Primary_Key_Physical_Name #24

universe-designer opened this issue Feb 16, 2024 · 1 comment

Comments

@universe-designer
Copy link
Contributor

I receive following error of the column Target_Role_Primary_Key_Physical_Name which does not exist in the excel file nor in the model.

Starting Script.
Traceback (most recent call last):
File "turbovault4dbt\turbovault_excel.py", line 117, in
main()
File "lib\site-packages\gooey\python_bindings\gooey_decorator.py", line 134, in
return lambda *args, **kwargs: func(*args, **kwargs)
File "turbovault4dbt\turbovault_excel.py", line 80, in main
hub.generate_hub(cursor,source, generated_timestamp, rdv_default_schema, model_path)
File "turbovault4dbt\procs\sqlite3\hub.py", line 121, in generate_hub
source_models = generate_source_models(cursor, hub_id)
File "turbovault4dbt\procs\sqlite3\hub.py", line 47, in generate_source_models
cursor.execute(query)
sqlite3.OperationalError: no such column: h.Target_Role_Primary_Key_Physical_Name

I assume this is some kind of search and replace typo.

@universe-designer
Copy link
Contributor Author

This Pull Request, solves this problem besides having other features.

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

No branches or pull requests

1 participant