Deepline Native Free Simple Company Search

Run in Enrichment Spreadsheet

Use this function as a column step in deepline enrich.

deepline enrich --input leads.csv --output leads.enriched.csv --with 'result=deepline_native_free_simple_company_search:{"sql":"{{sql}}"}' --json

Map payload values to spreadsheet columns with {{column_name}} placeholders.

Name	Type	Required	Default	Description
`payload.sql`	`string`	Yes		Single read-only SQL statement against the Snowflake-backed companies table (~35M rows). Columns: normalized_domain, domain, company_name, industry, location, linkedin_url, employee_count (integer), year_founded (integer), updated_at. Prefer exact normalized_domain equality or IN lookups when you have domains. Use linkedin_url and company_name equality/IN for small lookup batches. For fallback candidates, prefer anchored prefixes like company_name ILIKE ‘acme%’. Broad unanchored ILIKE ‘%keyword%’ scans are legal but can scan the full corpus; use dedicated company search providers for broad keyword discovery or strict market sizing. Supports SELECT, aggregates, GROUP BY, CTEs, EXPLAIN. SQL must include LIMIT <= 100000. Example: SELECT * FROM companies WHERE normalized_domain IN (‘openai.com’,‘anthropic.com’) LIMIT 10

Use direct execution for single payload debugging.

deepline tools execute deepline_native_free_simple_company_search --payload '{
  "sql": "string"
}' --json

Flag	Description
`--json`	Print machine-readable output.
`--wait`	Wait for terminal provider status when supported.
`--debug`	Enable wait mode with additional status/log output.
`--wait-timeout SECONDS`	Max seconds to wait in wait mode.
`--poll-interval SECONDS`	Polling interval in seconds during wait mode.
`--timeout SECONDS`	Request timeout in seconds.
`--connect-timeout SECONDS`	Connection timeout in seconds.