AI_PARSE_DOCUMENT

AI_PARSE_DOCUMENT(
  file_reference,
  mode
)

SELECT 
    file_name,
    AI_PARSE_DOCUMENT(
        TO_FILE('@documents/' || file_name),
        'OCR'
    ) AS extracted_text
FROM DIRECTORY('@documents')
WHERE file_name LIKE '%.pdf'

SELECT 
    AI_PARSE_DOCUMENT(
        TO_FILE('@contracts/agreement_2024.pdf'),
        'LAYOUT'
    ) AS

CREATE TABLE invoice_data AS
SELECT 
    relative_path AS filename,
    AI_PARSE_DOCUMENT(
        TO_FILE('@invoices/' || relative_path),
        'OCR'
    ) AS invoice_text,
    AI_EXTRACT(
        AI_PARSE_DOCUMENT(TO_FILE('@invoices/' || relative_path), 'OCR'),
        'Extract invoice number, date, vendor, and total amount'
    ) AS invoice_details
FROM DIRECTORY('@invoices')
WHERE relative_path LIKE '%.pdf'

SELECT 
    document_id,
    AI_PARSE_DOCUMENT(
        TO_FILE('@reports/' || filename),
        'LAYOUT'
    ):pages[0]:blocks[?(@.type == 'table')] AS tables
FROM

WITH parsed_doc AS (
    SELECT 
        AI_PARSE_DOCUMENT(
            TO_FILE('@legal_docs/contract.pdf'),
            'LAYOUT'
        ) AS doc_content
)
SELECT 
    page.value:page_number::INT AS page_num,
    page.value:blocks AS page_blocks,
    COUNT(block.value) AS block_count
FROM parsed_doc,
     LATERAL FLATTEN(doc_content:pages) page,
     LATERAL FLATTEN(page.value:blocks) block
GROUP BY page_num, page_blocks
ORDER BY

-- Use OCR for simple text extraction
SELECT AI_PARSE_DOCUMENT(TO_FILE('@docs/simple.pdf'), 'OCR');

-- Use LAYOUT for structured documents
SELECT AI_PARSE_DOCUMENT(TO_FILE('@docs/invoice.pdf'), 'LAYOUT')

-- Parse document then extract structured data
WITH parsed AS (
    SELECT AI_PARSE_DOCUMENT(
        TO_FILE('@contracts/agreement.pdf'),
        'OCR'
    ) AS doc_text
)
SELECT 
    AI_EXTRACT(
        doc_text,
        'Extract: party names, start date, end date, payment terms'
    ) AS contract_details
FROM

-- Store parsed documents to avoid re-processing
CREATE TABLE parsed_documents AS
SELECT 
    file_url,
    AI_PARSE_DOCUMENT(TO_FILE(file_url), 'OCR') AS parsed_text,
    CURRENT_TIMESTAMP() AS parsed_at
FROM

-- Extract specific pages
SELECT 
    doc:pages[0]:blocks AS first_page_content
FROM (
    SELECT AI_PARSE_DOCUMENT(
        TO_FILE('@docs/report.pdf'),
        'LAYOUT'
    ) AS doc
)

SELECT 
    filename,
    AI_EXTRACT(
        AI_PARSE_DOCUMENT(TO_FILE('@invoices/' || filename), 'OCR'),
        'Extract: invoice number, date, vendor name, total amount, line items'
    ) AS invoice_data
FROM DIRECTORY('@invoices')

WITH contracts AS (
    SELECT 
        contract_id,
        AI_PARSE_DOCUMENT(TO_FILE(file_path), 'OCR') AS contract_text
    FROM legal_documents
    WHERE doc_type = 'contract'
)
SELECT 
    contract_id,
    AI_COMPLETE(
        'claude-4-sonnet',
        'Identify key terms and obligations in this contract: ' || contract_text
    ) AS analysis
FROM

SELECT 
    application_id,
    AI_EXTRACT(
        AI_PARSE_DOCUMENT(TO_FILE(form_pdf), 'LAYOUT'),
        'Extract all filled form fields and their values'
    ) AS form_data
FROM