hex-sdk-patterns

# Hex SDK Patterns ## Overview Production patterns for Hex API: typed client, pipeline orchestration, retry logic, and Python integration. ## Instructions ### Step 1: Run with Retry ```typescript async function runWithRetry(client: HexClient, projectId: string, params: Record<string, any>, maxRetries = 2) { for (let i = 0; i <= maxRetries; i++) { try { const { runId } = await client.runProject(projectId, params); const result = await pollUntilComplete(client, projectId, runId); return result; } catch (err: any) { if (i === maxRetries || !err.message.includes('429')) throw err; await new Promise(r => setTimeout(r, 30000)); // Wait 30s on rate limit } } } ``` ### Step 2: Python Client (hextoolkit) ```python # pip install hextoolkit from hextoolkit import HexAPI hex_api = HexAPI(token=os.environ['HEX_API_TOKEN']) # List projects projects = hex_api.list_projects() # Run project run = hex_api.run_project('project-id', input_params={'date': '2025-01-01'}) # Poll for completion status = hex_api.get_run_status('project-id', run['runId']) ``` ### Step 3: Airflow Integration ```python # Using the hex-inc/airflow-provider-hex package from airflow_provider_hex.operators.hex import HexRunProjectOperator run_task = HexRunProjectOperator( task_id='run_hex_project', project_id='your-project-id', input_params={'date': '{{ ds }}'}, hex_conn_id='hex_default', wait_for_completion=True, timeout=600, ) ``` ## Reso...