Issue: Data Store Publish

I created a view and CDT on top of it;however Data Store is failing to publish the new entity with below error: 

The data store "FAS" [id=5401] was saved but cannot be published: An error occurred while trying to modify the data source schema: (conn=267964) 'Appian.FAS_VW_GET_WORK_REPORT' is not of type 'BASE TABLE' (APNX-1-4178-000)

I downloaded the DDL as mentioned and it doesnot look appropriate, please check the DDL update suggested below:

/* UPDATE DDL */
alter table `FAS_VW_GET_WORK_REPORT`
add column a_id bigint not null;

  
    
      @Table(name="FAS_VW_GET_WORK_REPORT")
      
    
    
      
        
          @Column(name="COUNT", columnDefinition="INT")
        
      
      
        
          @Column(name="USERNAME", columnDefinition="VARCHAR(500)")
        
      
      
        
          @Column(name="ACTION", columnDefinition="VARCHAR(255)")
        
      
      
        
          @Column(name="DATETIME", columnDefinition="DATETIME")
        
      
      
        
          @Column(name="CASE_ID", columnDefinition="INT")
        
      
      
        
          @Column(name="CLIENT_TYPE", columnDefinition="VARCHAR(255)")
        
      
      
        
          @Column(name="TRANSACTION_TYPE", columnDefinition="VARCHAR(255)")
        
      
      
        
          @Column(name="TRANSACTION_SUB_TYPE", columnDefinition="VARCHAR(255)")
        
      
      
        
          @Column(name="TASK", columnDefinition="VARCHAR(255)")
        
      
      
        
          @Column(name="CASE_STATUS", columnDefinition="VARCHAR(255)")
        
      
      
        
          @Column(name="CREATED_BY", columnDefinition="VARCHAR(255)")
        
      
      
        
          @Column(name="CREATED_DATE_TIME", columnDefinition="DATETIME")
        
      
      
        
          @Column(name="UPDATED_BY", columnDefinition="VARCHAR(255)")
        
      
      
        
          @Column(name="UPDATED_DATE_TIME", columnDefinition="DATETIME")