Postgress Private Schema Giving issue

Database Support
, , , ,
#1

Hello Helical,

I am using Helical Insight 4.1 GA , followed below reference link to make visible private schema in metadata creation page.

But I am unable to create report using the metadata with private schema tables. It is giving the below error. “Error: PSQL Exception : ERROR relation “studies” does not exist Position : 58”

image

Thanks,
Sesa.

How can I use my non-public schema?
#2

Hello Sesa,

In order to fix this issue ,we need to passing additional param while creating data source connection for the postgres database.

  1. Edit the data source connection and pass ?currentSchema=helical
    (Note here helical is private schema, you have to change as per your schema name)

image

  1. Create metadata
  2. Create report, it works without any issues

Thanks,
Helical Insight.