Error SQL71501: View: [PLTG].[MVW_SAURAV] has an unresolved reference to Column [Process_Key]

92 Views Asked by At
CREATE MATERIALIZED VIEW [PLTG].[MVW_SAURAV]
WITH 
( DISTRIBUTION =  HASH ([Process_Key]))
AS SELECT 
                      A.[PROCKEY] AS 'Process_Key',
                      A.[LOCATION] AS 'Location',
                      A.[INDICATOR] AS 'Indicator',
                      B.[SALESITEM] AS 'Sales Document item',
                      COUNT_BIG(*) AS 'TOTALCOUNT'

                      FROM [PLTG_STG].[ABC] A                                                                          
                    
                        INNER JOIN

             [PLTG_STG].[ZEN] B
            ON  A.[LOCATION] =  B.[LOCATION]
            GROUP BY 
            A.[PROCKEY],A.[LOCATION],A.[INDICATOR],B.[SALESITEM] ;

It is failing in build process in Azure DevOps .. don't know where we need to make change because syntax seems valid in visual studio and ssms also .. any help would be appreciated

0

There are 0 best solutions below