I try to follow the instructions of Monitor Delta Live Tables pipelines to query dlt.expection log.

Here is the simple code version I copied from the Querying the event log section:

CREATE TEMPORARY LIVE VIEW event_log_raw AS (SELECT * FROM event_log(TABLE(`catalog`.`schema`.`table`)));

CREATE OR REFRESH MATERIALIZED VIEW event_log_raw_1
AS
(SELECT * FROM event_log_raw LIMIT 1);

However, after I put the code into a DLT pipeline and running, it tell me something goes wrong:

• org.apache.spark.sql.catalyst.ExtendedAnalysisException: Unable to process statement for View 'event_log_raw'.
• java.lang.UnsupportedOperationException: Cannot read more than one event logs in the same query
• org.apache.spark.SparkException: A pipeline with a different id is already registered in this Credential Scope. The pipeline in a CredentialScope cannot be updated once it is registered.

I cannot find the related search result for this error message anywhere, what’s wrong with my code?