Create datasets easily across multiple databases in one data warehouse without transform models

Feature Suggestions
8

I’m not sure if this is the same of different issue. We use Postgress. We have namespaces per applications in a master warehouse db, each with the same structure. In holistices, each name space is a datasource with distinct postgress perms. For example:

  • Datawarehouse
    • Namespace: App_A (Postgres user → holistics data source)
      • Table: user_table (Holistics SQL data model)
    • Namespace: App_B (Postgres user → holistics data source)
      • Table: user_table (Holistics SQL data model)

The schema of the user_table is the same. I’m hoping to make

  1. a dashboard for admins that combines users in all apps
  2. a user for App A and App B that has data source permissions such that when they open the dashboard they only see their users

Should I use a transform model or a data set to combine these models (Using Modeling 4.0)? When I tried to make a SQL model, i’m getting permission errors.

Thanks.
.stone

1 Like