Data warehouse troubleshooting and FAQs

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.