topic How to handle if table doesn't exist in a schema? in Splunk User Behavior Analytics https://community.splunk.com/t5/Splunk-User-Behavior-Analytics/How-to-handle-if-table-doesn-t-exist-in-a-schema/m-p/610947#M50 <P>Hi,</P> <P>&nbsp;</P> <P>I am running below query, however I am getting error saying relation "analytics_hca_change_indicator_event doesn't exist" even if table doesn't exist in any one of the schema</P> <P>| koogledimen service=TenantPPASQuery action=AdhocQuery targetGroup="keng03-dev01-ins08-wfm19-dbs" app="Unknown_App/ppas_dheeraj_r9int" schema="_ALL_" query="select date(createdtm), count(*) from analytics_hca_change_indicator_event group by createdtm " | eval envstatus=if(like(scope, "%dev01%"), 1, 0)| eval wfmstatus=if(like(scope, "%wfm19%"), 1, 0) | where envstatus=1 and wfmstatus=1 | eval wfm_schemaname = mvindex(split(scope, "-"), -1).schemaname| eval wfm_schemaname = mvindex(split(scope, "-"), -1)."_".schema_name | chart sum(count) by date,wfm_schemaname</P> <P>&nbsp;</P> <P>How to handle this scenario please?</P> Fri, 26 Aug 2022 12:09:31 GMT dezmadi 2022-08-26T12:09:31Z How to handle if table doesn't exist in a schema? https://community.splunk.com/t5/Splunk-User-Behavior-Analytics/How-to-handle-if-table-doesn-t-exist-in-a-schema/m-p/610947#M50 <P>Hi,</P> <P>&nbsp;</P> <P>I am running below query, however I am getting error saying relation "analytics_hca_change_indicator_event doesn't exist" even if table doesn't exist in any one of the schema</P> <P>| koogledimen service=TenantPPASQuery action=AdhocQuery targetGroup="keng03-dev01-ins08-wfm19-dbs" app="Unknown_App/ppas_dheeraj_r9int" schema="_ALL_" query="select date(createdtm), count(*) from analytics_hca_change_indicator_event group by createdtm " | eval envstatus=if(like(scope, "%dev01%"), 1, 0)| eval wfmstatus=if(like(scope, "%wfm19%"), 1, 0) | where envstatus=1 and wfmstatus=1 | eval wfm_schemaname = mvindex(split(scope, "-"), -1).schemaname| eval wfm_schemaname = mvindex(split(scope, "-"), -1)."_".schema_name | chart sum(count) by date,wfm_schemaname</P> <P>&nbsp;</P> <P>How to handle this scenario please?</P> Fri, 26 Aug 2022 12:09:31 GMT https://community.splunk.com/t5/Splunk-User-Behavior-Analytics/How-to-handle-if-table-doesn-t-exist-in-a-schema/m-p/610947#M50 dezmadi 2022-08-26T12:09:31Z