Failed to create view with another view as source
Creation of view with another view as source fails.
Error: GE-1008 - Could not complete the request. Please try again.
Affected Versions: 2.6
2.6.1
Fix Version: 2.7
Root cause(s)
During the process of making changes related to the removal of Lake Formation Governed datasets, some validation code was inadvertently altered, leading to the occurrence of this error.
Impact
When users attempt to create views with another view as the source, the operation results in an error with the message: "GE-1008 - Could not complete the request. Please try again."
Mitigation
Create a view with a source view that does not exist. So that the view gets created but goes to failed state. Then you can update the view with the proper SQL statements. The view will get created successfully.
Fix is available in Amorphic version 2.7.
Timeline
gantt
title Timeline
dateFormat YYYY-MM-DD
tickInterval 7day
axisFormat %b-%d
todayMarker off
section Tracker
%% update the ticket number and date of bug report
CLOUD-4924 : done, 2024-08-30, 0d
section Identification
Reported : crit, des1, 2024-08-30, 0d
section Mitigation
%% Update number of days took for each step below
Bug Fixed: crit, done, 2024-09-05, 11d
section Delivery
%% update the date of each step below
testing complete: milestone, 2024-09-25, 23d
fix available: milestone, 2024-10-09, 5d
- 2024-08-30: Bug reported/identified (CLOUD-4924)
- 2024-09-05: Bug triaged
- 2024-09-16: Bug fixed
- 2024-10-09: Testing completed
- 2024-10-14: Version 2.7 released with the fix