{"id":"tables_text_to_sql","name":"Tables Text To Sql","alias":"TablesTextToSql","aliases":[],"description_short":"Convert natural language to SQL queries","description_long":"\n    This agent converts natural language descriptions into BigQuery SQL query.\n\n    You can optionally execute the generated query and get results directly.\n    ","description_tool_prompt":"\n    This agent converts natural language descriptions into BigQuery SQL query.\n\n    You can optionally execute the generated query and get results directly.\n    ","source":null,"conversation_examples":[],"tags":[],"available_in_chat":false,"available_in_deepthink":false,"available_in_mcp":null,"mcp_audience":"all","config":{"type":"object","properties":{"reasoning_effort":{"default":"low","description":"Thinking level for the LLM: 'low' for simple queries, 'high' for complex ones","enum":["low","high"],"title":"Reasoning Effort","type":"string"},"run_query":{"default":true,"description":"If true, execute the generated query and return results. If false, only return the generated SQL.","title":"Run Query","type":"boolean"},"allow_empty_results":{"default":true,"description":"If true, a query returning zero rows is a valid answer. Set it to false in workflows, so the node fails (and retries) instead of passing empty data to the downstream nodes.","title":"Allow Empty Results","type":"boolean"}},"required":[]},"item":{"type":"object","properties":{"text_query":{"description":"Natural language description of the data you want to query. Avoid writing SQL syntax.","title":"Text Query","type":"string"},"max_rows":{"anyOf":[{"minimum":1,"type":"integer"},{"type":"null"}],"default":null,"description":"Maximum number of rows to return. Enforces a LIMIT in the SQL and caps results at the API level.","title":"Max Rows"},"output_fields":{"anyOf":[{"items":{"type":"string"},"type":"array"},{"type":"null"}],"default":null,"description":"Optional. Restrict the query output to exactly these column names and no others. Keeps downstream steps stable while the agent stays agnostic. Other columns may still be used in WHERE/ORDER BY/GROUP BY.","title":"Output Fields"}},"required":["text_query"]},"response":{"properties":{"query":{"description":"The generated BigQuery SQL query","title":"Query","type":"string"},"fields":{"description":"Field definitions with name and type (empty if run_query=false)","items":{"additionalProperties":{"type":"string"},"type":"object"},"title":"Fields","type":"array"},"results":{"description":"Query execution results (empty if run_query=false)","items":{"additionalProperties":true,"type":"object"},"title":"Results","type":"array"}},"required":["query","fields","results"],"title":"TablesTextToSqlProcessedItem","type":"object"},"has_canvas":false,"open_canvas_automatically":false}