Open Bug 1947302 Opened 1 month ago Updated 24 days ago

looker PDT Insert_stmnt fail for firefox_desktop_usage_forecast.view

Categories

(Data Platform and Tools :: General, defect)

Product:
Data Platform and Tools
Component:
General
Type:
defect

Tracking

(Not tracked)

People

(Reporter: wichan, Assigned: curtis)

Details

(Whiteboard: [airflow-triage] )

The following PDT failed: Insert_stmnt
build error: SQL Error in CREATE TABLE as SELECT: Query execution failed: - Syntax error: Unexpected identifier "Expected" at [2:1]

https://mozilla.cloud.looker.com/projects/spoke-default/files/kpi/views/firefox_desktop_usage_forecast.view.lkml?line=2

Whiteboard: [airflow-triage]
Summary: looker PDT fail for firefox_desktop_usage_forecast.view → looker PDT Insert_stmnt fail for firefox_desktop_usage_forecast.view
Summary: looker PDT Insert_stmnt fail for firefox_desktop_usage_forecast.view → looker PDT Insert_stmnt build fail for firefox_desktop_usage_forecast.view
Summary: looker PDT Insert_stmnt build fail for firefox_desktop_usage_forecast.view → looker PDT Insert_stmnt fail for firefox_desktop_usage_forecast.view
Assignee: nobody → cmorales

:ascholtz, I'm seeing that you removed some broken views from these files a few weeks ago https://github.com/mozilla/looker-spoke-default/commit/377626cdaeb5f53d5ddb847a0893cae0b473cfab

Should I just delete the rest of the views in these two files, or remove these files altogether? I suspect that all these views haven't been in use for a long time.

Flags: needinfo?(ascholtz)

Yeah, they should be good to get removed. Just make sure they aren't used anywhere else.

Flags: needinfo?(ascholtz)
You need to log in before you can comment on or make changes to this bug.