Function checkMissingIntegrations

packages/cli/src/utils/analysis.ts:509–564

* Check for SQL blocks using integrations that aren't configured.

(blocks: DeepnoteBlock[], blockMap: Map<string, BlockInfo>)

 * Check for SQL blocks using integrations that aren't configured.
 */
function checkMissingIntegrations(blocks: DeepnoteBlock[], blockMap: Map<string, BlockInfo>): IntegrationCheckResult {
  const issues: LintIssue[] = []
  const configuredIntegrations = new Set<string>()
  const missingIntegrations = new Set<string>()
  const integrationUsage = new Map<string, { blockId: string; info: BlockInfo }[]>()

  for (const block of blocks) {
    if (block.type !== 'sql') continue

    const metadata = block.metadata as Record<string, unknown>
    const integrationId = metadata.sql_integration_id as string | undefined

    if (!integrationId || BUILTIN_INTEGRATIONS.has(integrationId)) {
      continue
    }

    const info = blockMap.get(block.id)
    if (!info) continue

    const envVarName = getSqlEnvVarName(integrationId)
    const isConfigured = !!process.env[envVarName]

    if (isConfigured) {
      configuredIntegrations.add(integrationId)
    } else {
      missingIntegrations.add(integrationId)
      const usage = integrationUsage.get(integrationId) ?? []
      usage.push({ blockId: block.id, info })
      integrationUsage.set(integrationId, usage)
    }
  }

  for (const [integrationId, usages] of integrationUsage) {
    const envVarName = getSqlEnvVarName(integrationId)

    for (const { blockId, info } of usages) {
      issues.push({
        severity: 'error',
        code: 'missing-integration',
        message: `SQL integration "${integrationId}" is not configured (set ${envVarName})`,
        blockId,
        blockLabel: info.label,
        notebookName: info.notebookName,
        details: { integrationId, envVar: envVarName },
      })
    }
  }

  return {
    issues,
    summary: {
      configured: Array.from(configuredIntegrations).sort(),
      missing: Array.from(missingIntegrations).sort(),
    },
  }
}

interface InputCheckResult {