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

[lonebear112]

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]

@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 [email protected]

[DaveFlynn]

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]

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