Just a quick note to mention that if you look at your datalinks:

There are many new tables added - these are rest of the Hyperion API.  This also means that they are also available in the query_datalinks api endpoint.  The only caveat is that for technical reasons, it will take us a bit longer to add well initial production rates to datalinks, dark oil is excluded for licensing/permissions reasons, and several endpoints y that that are "latest" versions, are excluded because they are a query on a base table that is already included.

Ask the Agent 

Remember - ask the agent about any dataset, it can explain fully.  For example - "How do I get the latest rigs from the rigs dataset?"

Answer:

Great question! Here's how to get the latest rigs from `hdl.rigs`:

### Quick Answer

```python
import smx

df = smx.query_datalink("""
    SELECT *
    FROM hdl.rigs
    WHERE date_observed = (
        SELECT MAX(date_observed) FROM hdl.rigs
    )
""")
```

This returns all active rigs on the most recent date in the dataset.

---

### Useful Variations

**U.S. only** (excludes Canada, which may have a different latest date):
```python
df = smx.query_datalink("""
    SELECT *
    FROM hdl.rigs
    WHERE date_observed = (
        SELECT MAX(date_observed) FROM hdl.rigs WHERE region_natgas != 'Canada'
    )
    AND region_natgas != 'Canada'
""")
```

**Latest rig count by region:**
```python
df = smx.query_datalink("""
    SELECT region_natgas, COUNT(*) as rig_count
    FROM hdl.rigs
    WHERE date_observed = (SELECT MAX(date_observed) FROM hdl.rigs)
    GROUP BY region_natgas
    ORDER BY rig_count DESC
""")
```

**Latest rig count by operator (top 20):**
```python
df = smx.query_datalink("""
    SELECT operator, COUNT(*) as rig_count
    FROM hdl.rigs
    WHERE date_observed = (SELECT MAX(date_observed) FROM hdl.rigs)
    GROUP BY operator
    ORDER BY rig_count DESC
    LIMIT 20
""")
```

### Key Things to Remember

| Tip | Detail |
|-----|--------|
| **Date column** | `date_observed` (not `date` or `date_frac`) |
| **Rig count** | `COUNT(*)` grouped by `date_observed` — each row = one active rig on that day |
| **Data freshness** | Updates every ~3 days, so `MAX(date_observed)` may not be today |
| **Canada caveat** | Canada may have a different latest date than U.S. regions |
| **rig_class** | `'oil'` or `'gas'` for U.S.; blank for Canada |

Do note that the documentation in the Hyperion API under the datalinks endpoint will be updated in a few days.  As noted, if you have questions about what is available, just ask the Agent.

As usual, reach out to support@synmax.com with any questions.