Loading

Errors in joining queries that utilize SELECT *

Fecha de publicación: Jun 5, 2024
Descripción

Following the Spring '24 release, all new Data Extensions are created to be Data Retention ready and include a _CreatedDate hidden column that it is not visible in the User interface or APIs.

Any pre-Spring '24 release Data Extension with Data Retention enabled for Individual Records will also have the _CreatedDate hidden column added. Additionally, starting in April 2024, a nightly process has been adding this new hidden _CreatedDate column to all existing Data Extension. This process is ongoing and it will take several months to complete.

This may cause failures in previously running queries that are using SELECT * and are using UNIONs between two Data Extensions if one has the _CreatedDate hidden column and the other does not.

Solución

There are two methods to resolve this issue:

  1. [Recommended option] Update the query to list the actual column name(s) instead of using SELECT *. This is the easier and quicker option.
  2. Add Data Retention for Individual Records to the older DE created before the Spring '24 release.
    •  If you don’t need data retention in the Data Extension, enable it with a long retention period (multiple years) and then disable it a day after enablement to ensure the _CreatedDate column is added appropriately. 
    • Disabling Data Retention in the Data Extension won’t remove the _CreatedDate column.
    • Find more information on, Individual Records retention in help documentation. 
    • Note: adding Data Retention to a Data Extension can take up to several hours depending on the size of the Data Extension.
Número del artículo de conocimiento

001725852

 
Cargando
Salesforce Help | Article