Function validateRequirements

packages/cli/src/commands/run.ts:766–863

* Validate that all required configuration is present before running. * Checks for: * - Missing input variables (used before defined, no --input provided) * - Missing database integrations (SQL blocks not in integrations config) * * Throws MissingInputError or MissingIntegrationError (exit code

(
  file: DeepnoteFile,
  providedInputs: Record<string, unknown>,
  pythonInterpreter: string,
  integrations: DatabaseIntegrationConfig[],
  notebookName?: string
)

 * Throws MissingInputError or MissingIntegrationError (exit code 2) on failure.
 */
async function validateRequirements(
  file: DeepnoteFile,
  providedInputs: Record<string, unknown>,
  pythonInterpreter: string,
  integrations: DatabaseIntegrationConfig[],
  notebookName?: string
): Promise<void> {
  const notebooks = notebookName ? file.project.notebooks.filter(n => n.name === notebookName) : file.project.notebooks

  // Collect all blocks with their sorting keys
  const allBlocks: Array<BlocksDeepnoteBlock & { sortingKey: string }> = []
  for (const notebook of notebooks) {
    for (const block of notebook.blocks) {
      allBlocks.push(block as BlocksDeepnoteBlock & { sortingKey: string })
    }
  }

  // === Check for missing database integrations ===
  const requiredIds = collectRequiredIntegrationIds(file, notebookName)
  const configuredIds = new Set(integrations.map(i => i.id.toLowerCase()))
  const missingIntegrations = requiredIds.filter(id => !configuredIds.has(id.toLowerCase())).map(id => ({ id }))

  if (missingIntegrations.length > 0) {
    const integrationList = missingIntegrations.map(i => `  - ${i.id}`).join('\n')
    throw new MissingIntegrationError(
      `Missing database integration configuration.\n\n` +
        `The following SQL blocks require database integrations that are not configured:\n` +
        `${integrationList}\n\n` +
        `Add the integration configuration to your integrations file.\n` +
        `See: https://docs.deepnote.com/integrations for integration configuration.`,
      missingIntegrations.map(i => i.id)
    )
  }

  // === Check for missing inputs ===
  // Get dependency info for all blocks
  let deps: Awaited<ReturnType<typeof getBlockDependencies>>
  try {
    deps = await getBlockDependencies(allBlocks, { pythonInterpreter })
  } catch (e) {
    // If AST analysis fails, skip input validation (will fail at runtime instead)
    debug(`AST analysis failed: ${e instanceof Error ? e.message : String(e)}`)
    return
  }

  // Build maps of block info
  const blockDeps = new Map(deps.map(d => [d.id, d]))

  // Find input blocks and their defined variables with sort order
  const inputVariables = new Map<string, { sortingKey: string; blockId: string }>()
  for (const block of allBlocks) {
    if (block.type.startsWith('input-')) {
      const metadata = block.metadata as Record<string, unknown>
      const varName = metadata.deepnote_variable_name as string
      if (varName) {
        inputVariables.set(varName, { sortingKey: block.sortingKey, blockId: block.id })
      }
    }