create_presto_engine
Create a Presto engine in watsonx.data to enable SQL querying across your data lakehouse. Configure node types, autoscaling, and catalog associations.
Instructions
Create a new Presto engine in watsonx.data.
EXAMPLE PAYLOAD: { "origin": "native", "display_name": "My-Presto-Engine", "description": "Presto engine with autoscaling", "tags": [], "associated_catalogs": [], "configuration": { "size_config": "custom", "coordinator": { "node_type": "starter", "quantity": 1 }, "worker": { "node_type": "starter", "quantity": 1 }, "autoscaling_enabled": true, "autoscaling_config": { "type": "cpu", "target": 40, "min_worker_quantity": 1, "max_worker_quantity": 18, "query_termination_grace_period_min": 1, "scale_in_stabilization_window_min": 5, "scaling_step_size": 1 } } }
Args: origin: (required) "native" display_name: (required) Display name for the engine configuration: (required) Engine configuration with required fields: - size_config: (required) "custom" (recommended) or predefined options (may be supported) - coordinator: (required) {"node_type": typically "starter" or "cache_optimized", "quantity": 1} - worker: (required) {"node_type": typically "starter" or "cache_optimized", "quantity": 1-18 recommended} - autoscaling_enabled: (optional) boolean to enable autoscaling - autoscaling_config: (required if autoscaling_enabled is true) autoscaling configuration object (see AUTOSCALING section) associated_catalogs: (optional) List of catalog names to associate description: (optional) Engine description 50 characters max engine_id: (optional) Custom engine ID (must match pattern: presto-0 through presto-1000) tags: (optional) Tags for the engine
AUTOSCALING (OPTIONAL): To enable autoscaling, include these fields in the configuration:
autoscaling_enabled: true (boolean)
autoscaling_config: { "type": "cpu" or "memory", "target": 1-100 (target utilization percentage, e.g., 40), "min_worker_quantity": 1-18 (minimum workers), "max_worker_quantity": 1-18 (maximum workers), "query_termination_grace_period_min": 1-120 (grace period before terminating queries), "scale_in_stabilization_window_min": 5-60 (stabilization window for scale-in), "scaling_step_size": 1-18 (nodes to add/remove per scaling action) }
PREDEFINED SIZE CONFIGS: If using predefined configs, exact node types and quantities must match:
starter: 1 coordinator + 1 worker (both bx2.48x192)
small: 1 coordinator + 3 workers (both ox2.16x128)
medium: 1 coordinator + 6 workers (both ox2.16x128)
large: 1 coordinator + 12 workers (both ox2.16x128)
Returns: Dict with created engine details including engine_id
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| origin | Yes | ||
| display_name | Yes | ||
| configuration | Yes | ||
| associated_catalogs | No | ||
| description | No | ||
| engine_id | No | ||
| tags | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||