Snowflake

SELECT p.legion_id, p.full_name, p.job_title, e.address AS work_email
FROM person_base_pii.people p
JOIN person_base_pii.emails e ON e.legion_id = p.legion_id
WHERE p.company_domain = 'snowflake.com'
  AND e.type = 'professional' AND e."CURRENT"
ORDER BY p.full_name
LIMIT 100;

SELECT p.full_name, p.job_title, p.company_name, p.city
FROM person_base_pii.people p
WHERE p.state = 'california'
  AND EXISTS (
    SELECT 1 FROM person_base_pii.skills s
    WHERE s.legion_id = p.legion_id AND s.cleaned = 'python'
  )
LIMIT 100;

SELECT m.month, m.count AS employees, m.hires, m.departures, m.growth_rate
FROM company_premium.companies c
JOIN company_premium.company_legion_employee_count_by_month m
  ON m.legion_id = c.legion_id
WHERE c.domain = 'snowflake.com'
ORDER BY m.month;

SELECT p.full_name, p.job_title, c.name_display, c.size,
       c.legion_employee_growth_rate_12m
FROM person_db.person_base_pii.people p
JOIN company_db.company_premium.companies c
  ON c.legion_id = p.company_legion_id
WHERE c.domain = 'snowflake.com'
LIMIT 100;

SELECT size, COUNT(*) AS companies
FROM company_free.companies
WHERE industry = 'software development'
GROUP BY size
ORDER BY companies DESC;

-- Let the app read the table you want enriched.
GRANT USAGE ON DATABASE my_db TO APPLICATION <app>;
GRANT USAGE ON SCHEMA my_db.public TO APPLICATION <app>;
GRANT SELECT ON TABLE my_db.public.leads TO APPLICATION <app>;

-- product, table, ID column, identifier column, identifier type, result table name
CALL <app>.core.enrich(
  'person_base_pii', 'my_db.public.leads', 'id', 'email', 'email', 'leads_enriched'
);

-- One row per matched input: INPUT_ID, LEGION_ID, RECORD (an OBJECT)
SELECT * FROM <app>.results.leads_enriched;