Data warehouse troubleshooting and FAQs

Last updated:

|

On this page

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.

Viewing the error message for a failed sync

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

Viewing the logs for a failed sync

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.

Questions? Ask Max AI.

It's easier than reading through 793 pages of documentation

Community questions

Was this page useful?

Next article

Under the hood

There are two types of data sources we are able to connect data from—integrations we've built and custom sources you can link. Connectors Connectors use a combination of Temporal and the open source data loading tool, dlt to sync data from your source to PostHog's storage in S3. You can think of this as a complete extract and load tool where you simply provide the credentials and we will take care of the rest of the data flow. Custom sources The second option are custom sources. With custom…

Read next article