Missing filter in the final Looker query #166
Description
The LLM understands the context and which fields need to be selected for the correct output. The LLM Looker Query generation output includes the filter. However, the final Looker Query doesn’t have that filter.
The generated_content has the filter:
The final Looker query looks as follows:
[
{
"generated_content": "```json\n{\n \"model\": \"tbd\",\n \"view\": \"tbd\",\n \"fields\": [\n \"view.nda_measure\"\n ],\n \"pivots\": [],\n \"fill_fields\": [],\n \"filters\": {\n \"view.nda_field\": \"Y\"\n },\n \"filter_expression\": null,\n \"sorts\": [],\n \"limit\": \"500\",\n \"column_limit\": \"50\",\n \"total\": null,\n \"row_total\": null,\n \"subtotals\": null,\n \"vis_config\": {\n \"type\": \"single_value\"\n },\n \"filter_config\": null\n}\n```"
}
][
{
"status": "complete",
"result_source": "cache",
"from_cache": true,
"data": {
"supports_pivot_in_db": true,
"null_sort_treatment": "low",
"expired": false,
"ran_at": "2025-08-01T11:05:10Z",
"aggregate_table_used_info": null,
"runtime": "1.113",
"added_params": {
"query_timezone": "America/New_York"
},
"forecast_result": null,
"dialect_specific_metadata": {
"total_bytes_processed": 0,
"backend_cache_hit": true,
"bi_engine_mode": null,
"bi_engine_reasons": null
},
"sql_explain": null,
"fields": {
"measures": [
{
"align": "right",
"can_filter": true,
"category": "measure",
"default_filter_value": null,
"description": "NDA",
"enumerations": null,
"field_group_label": null,
"fill_style": null,
"fiscal_month_offset": 0,
"has_allowed_values": false,
"hidden": false,
"is_filter": false,
"is_numeric": true,
"label": "NDA",
"label_from_parameter": null,
"label_short": "NDA",
"map_layer": null,
"name": "view.nda_field",
"strict_value_format": false,
"requires_refresh_on_sort": false,
"sortable": true,
"suggestions": null,
"tags": [],
"type": "average",
"user_attribute_filter_types": [
"number",
"advanced_filter_number"
],
"value_format": "0.00",
"view": "view",
"view_label": "NDA",
"dynamic": false,
"week_start_day": "monday",
"original_view": "view",
"dimension_group": null,
"error": null,
"field_group_variant": "NDA",
"measure": true,
"parameter": false,
"primary_key": false,
"project_name": "looker_example_model",
"scope": "view",
"suggest_dimension": "view.nda_field",
"suggest_explore": "nda_explore",
"suggestable": false,
"is_fiscal": false,
"is_timeframe": false,
"can_time_filter": false,
"time_interval": null,
"permanent": null,
"sql_case": null,
"filters": null,
"times_used": 0
}
],
"dimensions": [],
"table_calculations": [],
"pivots": []
},
"fill_fields": [],
"has_totals": false,
"has_row_totals": false,
"applied_filters": {},
"always_filter": {},
"conditionally_filter_applied": {},
"applied_filter_expression": null,
"number_format": "1,234.56",
"explore": {
"name": "nda",
"label": "nda",
"description": null
},
"timezone": "America/New_York",
"data": [
{
"view.nda_measure": {
"value": 9.361054546941414,
"rendered": "9.36"
}
}
],
"drill_menu_build_time": 0.0009080000000000001,
"has_subtotals": false,
"drill_metadata": {
"field_map": {},
"template": "nda"
}
}
}
]