Support read-only rights

[Vfisa]

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:

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)')

[popcornylu]

For internal tracking sc-31341

[kentwelcome]

@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: #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.