{"ok":true,"site":{"host":"strategyshifu.com","url":"https://strategyshifu.com/","type":"live","desc":"An agent-ready decision engine for regional Databricks SQL warehouse sizing and pricing.","tools":[{"name":"get_decision_state","kind":"answer","impl":"imperative","description":"Read the project workloads, active workload, requirements, budget, regional assumptions, and current recommendation.","title":"Get decision state","annotations":{"readOnlyHint":true,"untrustedContentHint":true},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"list_workloads","kind":"answer","impl":"imperative","description":"List every configured workload and identify the workload currently being edited.","title":"List workloads","annotations":{"readOnlyHint":true,"untrustedContentHint":true},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"add_workload","kind":"act","impl":"imperative","description":"Add a named DWH, ETL, or development workload with category-appropriate defaults and select it for editing.","title":"Add workload","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"name":{"type":"string","minLength":1,"maxLength":120,"description":"Human-readable workload name shown in the workspace."},"type":{"type":"string","enum":["DWH","ETL","DEV"],"description":"DWH for SQL/BI, ETL for jobs, or DEV for interactive development."}},"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"update_workload","kind":"act","impl":"imperative","description":"Update a workload's identity, category, compute, sizing, or chat/NLP requirement. Set naturalLanguageAnalytics=true when users ask natural-language questions over data so Genie-capable Serverless and Pro options are highlighted.","title":"Update workload","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"workloadId":{"type":"string"},"name":{"type":"string","minLength":1,"maxLength":120,"description":"Human-readable workload name shown in the workspace."},"type":{"type":"string","enum":["DWH","ETL","DEV"],"description":"DWH for SQL/BI, ETL for jobs, or DEV for interactive development."},"computeId":{"type":"string","enum":["serverless-sql","pro-sql","classic-sql","jobs-classic","jobs-serverless","all-purpose-classic"],"description":"Compute option compatible with the workload type."},"naturalLanguageAnalytics":{"type":"boolean","description":"Set true when users need chat-based or NLP questions over data; this requires Databricks Genie on Serverless or Pro SQL."},"warehouseSize":{"type":"string","enum":["2X-Small","X-Small","Small","Medium","Large","X-Large","2X-Large","3X-Large","4X-Large","5X-Large"]},"driverInstance":{"type":"string"},"workerInstance":{"type":"string"},"workerCount":{"type":"integer","minimum":1,"maximum":1000},"pipelines":{"type":"integer","minimum":1,"maximum":1000},"serverlessDbuPerHour":{"type":"number","minimum":0.01,"maximum":10000}},"required":["workloadId"],"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"remove_workload","kind":"act","impl":"imperative","description":"Remove one workload from the project. The final remaining workload cannot be removed.","title":"Remove workload","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"workloadId":{"type":"string"}},"required":["workloadId"],"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"select_workload","kind":"act","impl":"imperative","description":"Choose which configured workload the UI and comparison field should focus on.","title":"Select workload","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"workloadId":{"type":"string"}},"required":["workloadId"],"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"set_requirement","kind":"act","impl":"imperative","description":"Update the cloud or private-networking requirement. Changing cloud normalizes cluster instances and selects a valid region.","title":"Set project requirement","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"cloud":{"type":"string","enum":["AWS","Azure","GCP"]},"privateNetworking":{"type":"boolean"}},"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"set_region","kind":"act","impl":"imperative","description":"Set the provider-native region used for every workload's DBU and VM rates.","title":"Set pricing region","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"region":{"type":"string"}},"required":["region"],"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"set_budget","kind":"act","impl":"imperative","description":"Set the monthly USD budget applied to the complete project of configured workloads.","title":"Set project budget","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"monthlyBudgetUsd":{"type":"number","minimum":1,"description":"Complete project budget per month in USD."}},"required":["monthlyBudgetUsd"],"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"update_project","kind":"act","impl":"imperative","description":"Update the project name or switch the displayed cost period between monthly and annual.","title":"Update project","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"projectName":{"type":"string","minLength":1,"maxLength":120},"costPeriod":{"type":"string","enum":["monthly","annual"]}},"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"set_currency","kind":"act","impl":"imperative","description":"Switch displayed budgets and estimates between USD and INR. Ranking remains in canonical USD.","title":"Set display currency","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"currency":{"type":"string","enum":["USD","INR"]},"usdToInrRate":{"type":"number","minimum":1}},"required":["currency"],"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"set_workload_schedule","kind":"act","impl":"imperative","description":"Update runtime for one workload. Schedule affects cost but does not change workload category.","title":"Set workload schedule","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"workloadId":{"type":"string"},"hoursPerDay":{"type":"integer","minimum":1,"maximum":24},"daysPerMonth":{"type":"integer","minimum":1,"maximum":31}},"required":["workloadId"],"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"set_dwh_sizing","kind":"act","impl":"imperative","description":"Set the warehouse size for a DWH workload.","title":"Set DWH sizing","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"workloadId":{"type":"string"},"warehouseSize":{"type":"string","enum":["2X-Small","X-Small","Small","Medium","Large","X-Large","2X-Large","3X-Large","4X-Large","5X-Large"]}},"required":["workloadId","warehouseSize"],"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"get_pricing_options","kind":"answer","impl":"imperative","description":"Inspect compute, sizing, DBU, and VM options for a workload category in the active cloud and region.","title":"Get regional pricing options","annotations":{"readOnlyHint":true},"inputSchema":{"type":"object","properties":{"workloadType":{"type":"string","enum":["DWH","ETL","DEV"]}},"required":["workloadType"],"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"compare_strategies","kind":"act","impl":"imperative","description":"Compare category-valid compute options for the selected workload against technical requirements and total project budget.","title":"Compare active workload options","annotations":{"readOnlyHint":true,"untrustedContentHint":true},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"get_cost_estimates","kind":"answer","impl":"imperative","description":"Return configured monthly pricing components for every workload and the total project.","title":"Get project cost estimates","annotations":{"readOnlyHint":true,"untrustedContentHint":true},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"get_recommendation","kind":"answer","impl":"imperative","description":"Return the best compute option for the active workload that satisfies technical constraints and total project budget.","title":"Get active workload recommendation","annotations":{"readOnlyHint":true,"untrustedContentHint":true},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/","pages":["/"]},{"name":"get_redshift_iceberg_capabilities","kind":"answer","impl":"imperative","description":"Validate current Redshift Iceberg versions, DML operations, and limitations against official documentation.","title":"Get Redshift Iceberg capabilities","annotations":{"readOnlyHint":true,"untrustedContentHint":true},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/migrate/redshift-to-databricks","pages":["/migrate/redshift-to-databricks"]},{"name":"get_databricks_iceberg_capabilities","kind":"answer","impl":"imperative","description":"Validate managed and foreign Iceberg read/write behavior in Databricks.","title":"Get Databricks Iceberg capabilities","annotations":{"readOnlyHint":true,"untrustedContentHint":true},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/migrate/redshift-to-databricks","pages":["/migrate/redshift-to-databricks"]},{"name":"get_lakehouse_federation_redshift_capabilities","kind":"answer","impl":"imperative","description":"Validate current Lakehouse Federation support, access mode, use cases, and limits for Redshift.","title":"Get Redshift federation capabilities","annotations":{"readOnlyHint":true,"untrustedContentHint":true},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/migrate/redshift-to-databricks","pages":["/migrate/redshift-to-databricks"]},{"name":"get_redshift_export_options","kind":"answer","impl":"imperative","description":"Validate current scalable Redshift bulk-export mechanisms and columnar output support.","title":"Get Redshift export options","annotations":{"readOnlyHint":true,"untrustedContentHint":true},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/migrate/redshift-to-databricks","pages":["/migrate/redshift-to-databricks"]},{"name":"get_migration_assessment","kind":"answer","impl":"imperative","description":"Read the current Redshift-to-Databricks inputs, deterministic scores, recommendation, risks, alternative, steps, and architecture.","title":"Get migration assessment","annotations":{"readOnlyHint":true},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/migrate/redshift-to-databricks","pages":["/migrate/redshift-to-databricks"]},{"name":"update_migration_inputs","kind":"act","impl":"imperative","description":"Update one or more advisor inputs; the StrategyShifu scoring engine will immediately recalculate the recommendation.","title":"Update migration inputs","inputSchema":{"type":"object","properties":{"dataSizeGb":{"type":"number","minimum":0,"description":"Total source data volume in GB."},"tableCount":{"type":"integer","minimum":0,"description":"Number of source tables in migration scope."},"largestTableGb":{"type":"number","minimum":0,"description":"Largest in-scope source table size in GB."},"dailyChangeRate":{"type":"string","enum":["< 1%","1–5%","5–20%","> 20%","Unknown"]},"writePattern":{"type":"string","enum":["Mostly append","MERGE / upsert","Frequent UPDATE","Frequent DELETE","Mixed workload","Mostly read-only"]},"redshiftSqlComplexity":{"type":"string","enum":["Low","Medium","High","Unknown"]},"keepRedshiftActive":{"type":"boolean"},"coexistenceDuration":{"type":"string","enum":["< 1 month","1–3 months","3–6 months","> 6 months","Unknown"]},"downtimeTolerance":{"type":"string","enum":["Near zero","< 1 hour","< 1 day","Multiple days acceptable"]},"sharedS3Available":{"type":"string","enum":["Yes","No","Unknown"]},"targetState":{"type":"string","enum":["Databricks becomes primary platform","Long-term Redshift + Databricks coexistence","Evaluate Databricks before migration","Only move selected workloads","Not decided"]},"targetFormat":{"type":"string","enum":["Delta Lake","Iceberg","No preference","Not decided"]},"migrationPriority":{"type":"string","enum":["Data pipelines / ETL","BI and reporting","Selected workload POC","Not decided"]},"changeSyncPlan":{"type":"string","enum":["Write freeze","Scheduled incremental loads","CDC / replication tool","Dual-write","No plan","Unknown"]},"specialDataTypes":{"type":"string","enum":["None known","Some","Extensive","Unknown"]}},"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/migrate/redshift-to-databricks","pages":["/migrate/redshift-to-databricks"]},{"name":"assess_redshift_databricks_migration","kind":"act","impl":"imperative","description":"Apply supplied migration inputs to the visible workspace, then combine deterministic scoring with current AWS and Databricks capability evidence.","title":"Assess Redshift to Databricks migration","annotations":{"untrustedContentHint":true},"inputSchema":{"type":"object","properties":{"dataSizeGb":{"type":"number","minimum":0,"description":"Total source data volume in GB."},"tableCount":{"type":"integer","minimum":0,"description":"Number of source tables in migration scope."},"largestTableGb":{"type":"number","minimum":0,"description":"Largest in-scope source table size in GB."},"dailyChangeRate":{"type":"string","enum":["< 1%","1–5%","5–20%","> 20%","Unknown"]},"writePattern":{"type":"string","enum":["Mostly append","MERGE / upsert","Frequent UPDATE","Frequent DELETE","Mixed workload","Mostly read-only"]},"redshiftSqlComplexity":{"type":"string","enum":["Low","Medium","High","Unknown"]},"keepRedshiftActive":{"type":"boolean"},"coexistenceDuration":{"type":"string","enum":["< 1 month","1–3 months","3–6 months","> 6 months","Unknown"]},"downtimeTolerance":{"type":"string","enum":["Near zero","< 1 hour","< 1 day","Multiple days acceptable"]},"sharedS3Available":{"type":"string","enum":["Yes","No","Unknown"]},"targetState":{"type":"string","enum":["Databricks becomes primary platform","Long-term Redshift + Databricks coexistence","Evaluate Databricks before migration","Only move selected workloads","Not decided"]},"targetFormat":{"type":"string","enum":["Delta Lake","Iceberg","No preference","Not decided"]},"migrationPriority":{"type":"string","enum":["Data pipelines / ETL","BI and reporting","Selected workload POC","Not decided"]},"changeSyncPlan":{"type":"string","enum":["Write freeze","Scheduled incremental loads","CDC / replication tool","Dual-write","No plan","Unknown"]},"specialDataTypes":{"type":"string","enum":["None known","Some","Extensive","Unknown"]}},"additionalProperties":false},"hasHandler":true,"hasExecute":true,"__source":"spec","executable":true,"handlerField":"execute","page":"/migrate/redshift-to-databricks","pages":["/migrate/redshift-to-databricks"]}],"category":"Developer Tools","apiSurface":"spec","toolCount":24}}