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

Saurav Kumar Barnwal 1 Reputation point
2022-11-14T00:40:11.057+00:00
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

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,921 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.