search

spectacles-ci / spectacles

A continuous integration tool for Looker and LookML.
https://spectacles.dev
MIT License
217 stars 35 forks source link

Spectacles fails to validate SQL based on Postgresql Materialised View #726

Closed EminBA closed 1 year ago

EminBA commented 1 year ago

Hi I am using spectacles sql to validate my looker views dimensions, validation is working with an sql table based views but it fails to recognize the relation when the view is based on derived table ( that queries a materialized view instead of a table ). the error I keep getting is as follows,

model_name/view_name.column_name The PostgreSQL 9.5+ database encountered an error while running this query. ERROR: relation "schema_name.materialized_view_name" does not exist Position: 213 LookML: https://xxxx.cloud.looker.com/projects/projectname/files/viewfilename.view.lkml?line=102 Test SQL: logs/queries/xxxxx.sql

PS : Knowing that dimensions and views are working in google looker

EminBA commented 1 year ago

sorry, it turned out to be an internal problem. apologies. closing the issue