Creating User Attributes in Google Looker

Complete the following steps to add user attributes for Platform schema name in Google Looker administration:

Procedure

  1. Navigate to Admin > Users > User Attributes
  2. Click Create User Attribute.
  3. Provide the following values:
    • Name: platform_schema
    • Label: Platform Schema
    • Date Type: string
    • Set Default Value: <Platform Schema Name>
    Note: Ensure that Campaign schema can access Platform tables using Platform schema name. For SQLServer, add dbo along with the database name.

    Verify if you can run the following query from Campaign database:

    SQLServer: Select * from PlatformUser.dbo.USM_USER;
Oracle: Select * from PlatformUser.USM_USER;