hex-core-workflow-a

# Hex Project Orchestration ## Overview Trigger Hex project runs from external orchestration tools (Airflow, Dagster, cron) with input parameters, status polling, and error handling. This is the primary integration pattern for embedding Hex in data pipelines. ## Instructions ### Step 1: Parameterized Project Runs ```typescript import 'dotenv/config'; const TOKEN = process.env.HEX_API_TOKEN!; const BASE = 'https://app.hex.tech/api/v1'; interface RunConfig { projectId: string; inputParams?: Record<string, any>; updateCache?: boolean; killRunning?: boolean; } async function triggerRun(config: RunConfig) { const response = await fetch(`${BASE}/project/${config.projectId}/run`, { method: 'POST', headers: { 'Authorization': `Bearer ${TOKEN}`, 'Content-Type': 'application/json' }, body: JSON.stringify({ inputParams: config.inputParams || {}, updateCacheResult: config.updateCache ?? true, killRunningExecution: config.killRunning ?? false, }), }); if (!response.ok) throw new Error(`Trigger failed: ${response.status} ${await response.text()}`); return response.json(); } ``` ### Step 2: Synchronous Run Helper ```typescript async function runAndWait(config: RunConfig, timeoutMs = 600000): Promise<any> { const { runId, projectId } = await triggerRun(config); const startTime = Date.now(); while (Date.now() - startTime < timeoutMs) { const res = await fetch(`${BASE}/project/${projectId}/run/${runId}`, { headers: { '...