Hi,
Getting error "Preview currently unavailable due to an error on the source" while retrieving the data from DB View with Record Type also Expression Evaluation Error while querying with QE. Verified that view has a column wherein unique values are present and same is used as PK in CDT. Only thing is, this view's load time is approx. 20.17 seconds.
Anyone can suggest what would be the solution for this.
Discussion posts and replies are publicly visible
Hi shobhits6437 initially analyze your database view using explain statement. Later add the necessary indexes for the columns & also remove un-necessary joins from the view. Then check the query time of the view, If still the error exists then reach out to apian support