Data Warehouse troubleshooting

This page covers troubleshooting for Data Warehouse. For setup, see the installation guides.

Have a question? Ask PostHog AI

How can I see why my syncs are failing?

From the source page, click the source that's failing, scroll over to the Status column and hover over the error message.

You can also click the Syncs tab and expand any failed sync to see all the logs.

How do I speed up my SQL queries?

1. Reduce the date range you're querying.
2. Add more specific filters with WHERE clauses.
3. Use materialized views.

We have other suggestions in our product analytics docs.

How do I run partial SQL queries?

If you want to run a part of your query in the SQL editor, highlight the part you want to run and hit CMD + Enter (Mac) or CTRL + Enter (Windows).

This is useful if you have a complex query and you want to test parts of it without running the whole query.

Why is my CSV data not parsing correctly?

If your CSV data appears garbled, has missing columns, or shows unexpected characters, it may be due to incorrect quote handling settings.

When linking a CSV file, PostHog provides a CSV quote handling option with two modes:

• RFC 4180 double quotes - Use this when your CSV uses standard double-quote escaping (e.g., "Hello ""World""" becomes Hello "World")
• Literal quotes - Use this when quotes in your data should be treated as regular characters (default)

To fix parsing issues, try recreating the table with the other quote handling option selected.

Why am I getting "Some files in the bucket are archived"?

This error occurs when files in your S3 bucket are stored in S3 Glacier or S3 Intelligent-Tiering archive storage classes. These storage classes are designed for long-term archival and cannot be accessed directly.

To resolve this:

1. Restore the files to Standard storage class in AWS S3.
2. Or narrow your URL pattern to exclude the archived files.

Solved community questions