[FAQ] Column name from API not found when querying dlt-loaded table

[AsherJD-io]

Course

data-engineering-zoomcamp

Question

Running a query like:

SELECT Trip_Pickup_DateTime FROM taxi_data.trips

results in a “Referenced column not found” error.

Answer

dlt normalizes column names to lowercase and converts them to snake_case.

Example:

Trip_Pickup_DateTime → trip_pickup_date_time

Inspect the schema using:

SELECT column_name
FROM information_schema.columns
WHERE table_schema = 'taxi_data'

Use the normalized column names in your queries.

Checklist

• I have searched existing FAQs and this question is not already answered
• The answer provides accurate, helpful information
• I have included any relevant code examples or links

[github-actions]

✅ FAQ NEW proposal created in PR #226

Please review and approve the changes.