piperider Support read-only rights

I would like to use Piperider to profile datasets with user that has read-only rights to those tables. So far CLI nor dbt-config did not allow me to do so - it only allows me to profile the particular schema used in the config. This is an example: Screenshot_2023-05-10_at_16 51 20 My user has a dedicated workspace with write access and has a read-only access to schemas/tables I would like to run profiling.

when I forced it through CLI --table command it ended up with this error:

Error: Profiler Exception: ProgrammingError('(snowflake.connector.errors.ProgrammingError) 001059 (22023) : SQL compilation error: Must specify the full search path starting from database for SAPI_9609
[SOL: SHOW /* sqlalchemy:_get_schema_primary_keys */PRIMARY KEYS IN SCHEMA sapi_96091
(Background on this error at: https://sqlalche.me/e/14/f405)')

May 12 '23 17:05 Vfisa

For internal tracking sc-31341

May 15 '23 01:05 popcornylu

@Vfisa PipeRider does support accessing the read-only snowflake tables. However, the CLI run option --table with schema and table name didn't work here could be caused by the following issue: https://github.com/InfuseAI/piperider/issues/666

We already fix this issue at the PipeRider latest version v0.24.1 https://github.com/InfuseAI/piperider/releases/tag/v0.24.1

Could you please upgrade the PipeRider to the latest version and try to reproduce this issue again? Thanks.

May 17 '23 07:05 kentwelcome