Product Updates and Announcements

You can delete assets (segments, tables, views, and UDFs) from any Data Catalog page and manage deleted tables, views, and segments in the Recycle Bin. Deleted tables, views, and segments can be restored within 30 days of deletion and are permanently deleted from the Recycle Bin after 30 days. To learn more, see “Delete an Asset” and “The Recycle Bin Page”.

You can now view all details regarding an asset in full-page view and view the activity history of a specific asset.

The "Data Type" column in pages listing assets (segments, tables, views, and user-defined functions) has been renamed "Ownership" to indicate the ownership of an asset as follows:

To learn more, see "The All Assets Page" and "The Segments Page".

The new Workflow Execution Status Page lets you view the status of a workflow and the connections and status of each process in the workflow. This can help confirm successful execution of a workflow or troubleshoot problems by displaying the status of each process in the workflow.

You can do the following on the Workflow Execution Status page:

You can now download configured workflows and processes as JSON files and upload them to re-apply the same configuration. This enhancement will save you time when creating multiple workflows and processes with the same configurations in Identity Engine.

We have improved the way our search functionality works when searching for data assets. This improvement allows you to search for assets more efficiently and intuitively while yielding more accurate results.

Some of the enhancements include:

This improvement is applied to the search functionalities on the following pages and dialogs:

Users with the Super User or User Manager role can now add multiple user and service accounts at the same time. You can add a maximum of 10 accounts simultaneously with the same roles. Note that you cannot add multiple accounts and grant them different roles at the same time.

To add accounts, go to Administration → Accounts and click Add Accounts. Separate each email address or service account name with a comma, [Space], or [Enter]. To learn more, see "Add Accounts with Roles".

You can create a view using a CREATE OR REPLACE VIEW statement. SQL Editor's Create button was removed.

New views are displayed under the "Views" node in SQL Editor's All Assets pane. Previously created views continue to be displayed under their table name.

Any views available to you that are hosted on another data warehouse are grouped in the All Assets pane under a name that was specified in its data warehouse.

This release provides streamlined navigation and prepares the Data Collaboration Platform for additional applications.

Key changes to the navigation include:

SQL Editor supports the approx_percentile and percentile_approx SQL functions. For information, see "SQL Functions".

If you specify query statement visibility rules when you create a permission for a table or a view, your partners' queries (if any) will be displayed on the Data Activity page when you click the corresponding entrird. For information, see "The Data Activity Page".

We've released a new search for our help documentation sites so that you can find the help articles you need more quickly and easily. New features include:

The new search displays results as you type (once you've entered at least three characters).

You can either click on the result you want or press Enter to be taken to a dedicated search page showing your search results.

We hope this improved search helps you get the information you need.

If you have any search feedback, email documentation-feedback@liveramp.com or click one of the "Was this helpful?" links at the bottom of any article.

The Data Activity report download includes changes to the following columns:

If you lack the data visibility permissions for the data assets, the corresponding cells are left blank in the report.

We've upgraded our user interface design to better support other LiveRamp data collaboration capabilities, allowing for additional features and integrations in the future.

SQL Editor supports the where clause for cross joins. For example:

SELECT COUNT(*)
FROM pub1
CROSS JOIN pub1_small
WHERE pub1.campaign_id != pub1_small.campaign_id

The Create Permission dialog includes options for setting query visibility for a user-defined function:

For information, see "Create a Data Permission".

To be more inclusive of other solutions beyond data collaboration, this application is now called "LiveRamp" instead of "Data Hub".

SQL Editor supports the following set operators:

SELECT COUNT(rampid)
FROM (
  SELECT rampid FROM table1
  INTERSECT
  SELECT rampid FROM table2
  EXCEPT
  SELECT rampid FROM table3
)

SQL Editor supports window functions without partitioning. For example:

SELECT ROW_NUMBER(ORDER BY rampid), ad FROM table1

SQL Editor supports transcoded joins for more than two tables, which can be useful when working with RampIDs. For example:

SELECT COUNT(*)
FROM table1 t1
  INNER JOIN table2 t1 ON (t1.rampid = t2.rampid)
  INNER JOIN table3 t3 ON (t1.rampid = t3.rampid)

You can add your own custom tags to your data assets to categorize them. This can help you to search, filter, and sort your assets.

For information, see "Manage Asset Tags".

SQL Editor supports a parameter "hint" syntax that provides UDF users with suggested parameter values when viewing a UDF dashboard. For example:

-- @hint {"input_campaign_id": {"one_of": [12345, 56789, 15325]},
--        "campaign_start_date": {"range": ['2022-01-01', '2022-05-01'] },
--        "campaign_end_date": {"range": ['2022-02-01', '2022-06-01'] },
--        "conversion_windows_days": {"range": [1, 14] },
--        "device_types": {"any_of": ["mobile", "web", "tv"] }
--        }
CREATE OR REPLACE FUNCTION attributed_conversions_by_campaign(
  input_campaign_id string,
  campaign_start_date date,
  campaign_end_date date,
  conversion_windows_days integer,
  device_types array<string>
) as select CONCAT(input_campaign_id, campaign_start_date, campaign_end_date, conversion_windows_days, ARRAY_JOIN(device_types, '')) as res

For information, see "Including Suggested Parameter Values in UDFs".

LiveRamp's Data Collaboration Platform documentation has moved from Safe Haven help to the following URL:

https://docs.liveramp.com/app/index.html

This allows you to browse and search only for Data Collaboration Platform topics. For information about using this documentation, see "Tips for Using This Documentation Site".

For information, see "SQL Functions".

You can select the column to use for query threshold aggregation in the Collaboration Rules step of the Create Permission dialog (household ID, RampID, or select another column). For information, see "Create a Data Permission".

A programmatic API supports query automation. For information, contact your LiveRamp representative.