Getting Started with the Reconn SQL Console

Reconn's SQL console lets you query any of our 69 data sources directly from your browser. This tutorial walks through common queries to get you started.

Accessing the Console

Navigate to Query in the left sidebar. The console has two panels: the schema tree on the left (showing available tables and columns) and the editor on the right (powered by CodeMirror with SQL syntax highlighting).

Basic Queries

List all AER wells for an operator:

SELECT licence_number, well_name, well_status, well_type, latitude, longitude
FROM aer_wells_normalized.wells
WHERE licensee_name ILIKE '%suncor%'
ORDER BY licence_number
LIMIT 100

Count wells by status in Saskatchewan:

SELECT well_status, COUNT(*) as count
FROM sk_geohub_wells_normalized.wells
GROUP BY well_status
ORDER BY count DESC

Find recent Toronto building permits over $1M:

SELECT permit_number, description, permit_type, estimated_cost
FROM toronto_permits_normalized.permits
WHERE estimated_cost > 1000000
ORDER BY issue_date DESC
LIMIT 50

Cross-Province Queries

One of Reconn's strengths is querying across provinces:

Compare mineral deposit counts by province:

SELECT 'AB' as province, COUNT(*) as deposits FROM aer_normalized.facilities WHERE facility_type = 'MINE'
UNION ALL
SELECT 'SK', COUNT(*) FROM sk_mineral_dep_normalized.deposits
UNION ALL
SELECT 'BC', COUNT(*) FROM bc_mineral_dep_normalized.deposits
UNION ALL
SELECT 'MB', COUNT(*) FROM mb_mineral_dep_normalized.deposits
UNION ALL
SELECT 'ON', COUNT(*) FROM on_mineral_dep_normalized.deposits
UNION ALL
SELECT 'NL', COUNT(*) FROM nl_mineral_dep_normalized.deposits

Exporting Results

Click the Export CSV button above the results table to download your query output. Professional and Enterprise plans can also access results via the REST API:

curl -H "Authorization: Bearer YOUR_TOKEN" \
  "https://api.reconn.ca/v1/query?sql=SELECT+*+FROM+..."

Tips

• Use ILIKE for case-insensitive text matching
• The schema tree shows column types — hover for details
• Queries run against DuckDB, so you get full analytical SQL support (window functions, CTEs, etc.)
• Results are limited to 10,000 rows in the console; use the API for larger exports

Explore the schema tree to see all available tables and start building your own queries.