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

Piperider run - results in Error: No such table '()' #751

Open
lonebear112 opened this issue Jun 23, 2023 · 3 comments
Open

Piperider run - results in Error: No such table '()' #751

lonebear112 opened this issue Jun 23, 2023 · 3 comments

Comments

@lonebear112
Copy link

Running into Error: No such table '()' with command dbt build --select tag:piperider && piperider run.

Env:
MacOs Monterey
python 3.8.9
dbt 1.5
piperider 0.27.0
Snowflake db

Steps:

  1. Installed piperider
  2. Ran piperider diagnose ( Check Passed)
  3. Updated yml file corresponding to model xyz - xyz.yml with piperider tag.
  4. dbt list -s tag:piperider (lists tagged models)
  5. .piperider/config.yml has property tag:piperider defined.
  6. Running dbt build --select tag:piperider && piperider run results in an Error (Mentioned Above)

Running piperider run --table ( Specifically selecting the table to be profiled works ).

@ctiml
Copy link
Member

ctiml commented Jun 27, 2023

@lonebear112 Thank you for reporting the issue.
Would it be possible for you to provide the dbt manifest.json file to help us investigate the issue?

Run dbt build --select tag:piperider, and the manifest.json file will be generated in the ./target/ directory.
Please check if the manifest contains any sensitive or confidential information, and if so, kindly remove it.

If it's not convenient to paste it here, you can send it to support@infuseai.io

@DaveFlynn
Copy link
Contributor

HI @lonebear112

We've currently been unable to reproduce the issue. If convenient, please forward your manifest.json as mentioned by @ctiml above.

In the meantime, we have implemented some improvements to PipeRider so that the no such table error will not interrupt the process.

If we can help further please let us know by replying to this thread.

Thanks,

Dave

@DaveFlynn
Copy link
Contributor

Hi @lonebear112

Were you able to try again, and was your issue resolved?
If possible please update to the latest version of PipeRider with the following command, and let us know if you still encounter the issue:

pip install -U piperider

Thanks,

Dave

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

3 participants