Snowflake Integration

Install the Verilex Native App from Snowflake Marketplace. Query our data with SQL directly in your Snowflake warehouse.

Setup

1. 1. Find Verilex on the Snowflake Marketplace.
2. 2. Install the Native App in your Snowflake account.
3. 3. The app creates External Functions that call our API.
4. 4. Query with standard SQL:

-- Healthcare providers
SELECT * FROM TABLE(verilex.npi_query('CA', 'Cardiology', NULL));

-- SEC filings
SELECT * FROM TABLE(verilex.sec_filings('0000320193', '10-K', NULL, NULL));

-- Weather observations
SELECT * FROM TABLE(verilex.weather_query(37.77, -122.42, 'history', '2025-01-01', '2025-01-31'));

-- Federal court cases
SELECT * FROM TABLE(verilex.pacer_search('Apple', 'cacd', NULL));

-- OTC companies (filter by ticker and shell risk)
SELECT * FROM TABLE(verilex.otc_query(NULL, NULL, 30, 50));

-- Trademarks (search by mark text and class)
SELECT * FROM TABLE(verilex.trademark_query('APPLE', NULL, '009', NULL));

-- Patents (search by assignee)
SELECT * FROM TABLE(verilex.patent_query(NULL, 'Google', NULL, NULL));

-- Company Intelligence (profile by CIK)
SELECT * FROM TABLE(verilex.company_profile('0000320193'));

-- Company screener (OTC companies with high shell risk)
SELECT * FROM TABLE(verilex.company_screen('OTC', NULL, 70, NULL));

-- Crypto risk (protocol stress scores, last hour)
-- Note: Crypto data is API-only (PostgreSQL-backed, not Parquet)
SELECT * FROM TABLE(verilex.crypto_protocols('1h', NULL));