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)')
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
--tablecommand it ended up with this error: