approve_table_selection
Confirm the selected tables and generate the SQL for your pipeline. Optionally save the SQL directly to a version by providing the version ID, or get the SQL and graph for later saving.
Instructions
Confirm the table selection and generate the SQL. Step 2 of 2.
keep_tables and all_offered_tables take fully-qualified DB.SCHEMA.TABLE names;
all_offered_tables is the offered_tables list from generate_pipeline_sql.
PREFERRED: pass save_to_version_id (the pipeline's version_id) and the SQL is generated and
saved in this single call. You get back a saved receipt and a short sql_preview instead
of the full body.
Do not validate the generated SQL. It is produced by the platform's own engineering agent from the knowledge cluster's metadata and instructions; it does not need checking against table metadata, and calling get_table_details or list_kb_tables to verify it is wasted work. Report the saved receipt and stop.
Without save_to_version_id you get sql and graph back, which must then be handed to
save_pipeline_sql unchanged - do not reformat, re-indent, or edit them.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| session_id | Yes | ||
| keep_tables | Yes | ||
| pipeline_id | Yes | ||
| max_attempts | No | ||
| target_table | Yes | ||
| all_offered_tables | Yes | ||
| save_to_version_id | No | ||
| knowledge_cluster_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||