Skip to main content
  • Data Collaboration Platform Documentation
  • Querying Data
  • Create a View

Create a View

You can create a view from a query and then create a data permission for a partner to use it.

You must give your view a unique name, which can contain letters, numbers, and underscores but no spaces or other special characters. View names cannot only contain numbers.

LiveRamp validates unique view names across all of your organization's views within LiveRamp Data Collaboration Platform's data warehouse. If you have a view in another data warehouse with the same name, validation will not find it. It is also possible that one of your partners may create a view that has the same name as one in your organization. To avoid issues once data permissions are granted between partners and across data ware, follow your organization's naming guidelines to ensure uniqueness across all partners.

Tip

What you can do in the Data Collaboration Platform depends on your roles. Before you begin, check if you have the correct roles to perform the tasks in this article. To learn more, see "Roles and Permissions".

Procedure. To create a view from a query:

  • Use SQL Editor to run a query that results in the rows and columns you want to save as a view and include a CREATE OR REPLACE VIEW statement with a unique name for the view. For example:

    CREATE OR REPLACE VIEW my_view_name AS
  SELECT * FROM exposure INNER JOIN conversion USING(rampid)

    The view is created and is displayed on the All Assets page and under the "Views" node in SQL Editor's All Assets pane.

In this section: