in generator/views/operational_monitoring_alerting_view.py [0:0]
def to_lookml(self, v1_name: Optional[str], dryrun) -> Dict[str, Any]:
"""Get this view as LookML."""
if len(self.tables) == 0:
raise Exception((f"Operational Monitoring view {self.name} has no tables"))
reference_table = self.tables[0]["table"]
dimensions = [
d
for d in lookml_utils._generate_dimensions(reference_table, dryrun=dryrun)
if d["name"] != "submission"
]
dimensions.append(
{
"name": "submission_date",
"type": "date",
"sql": "${TABLE}.submission_date",
"datatype": "date",
"convert_tz": "no",
}
)
dimensions.append(
{
"name": "build_id_date",
"type": "date",
"hidden": "yes",
"sql": "PARSE_DATE('%Y%m%d', CAST(${TABLE}.build_id AS STRING))",
"datatype": "date",
"convert_tz": "no",
}
)
return {
"views": [
{
"name": self.name,
"sql_table_name": f"`{reference_table}`",
"dimensions": dimensions,
"measures": [
{"name": "errors", "type": "number", "sql": "COUNT(*)"}
],
}
]
}