EXPLAIN is not working in Looker Sql runner

Hi Team ,

We are using Big Query as data warehouse and I am trying to analyze the sql query performance using SQL running like below ..

EXPLAIN select * from table1 inner join table2 …..

But the query is failing with “Explain statement not supported”

Can some one help me why EXPLAIN command is not supporting in SQl Runner of Looker.

0 1 283
1 REPLY 1

Hi @Mahesh2,

EXPLAIN is not available in BigQuery.

See also https://cloud.google.com/bigquery/query-plan-explanation

Top Labels in this Space
Top Solution Authors