How to debug a failed validation

Don't worry, a failed validation is no problem. Watch the corresponding video for each issue.

Found activity_id or enriched_activity_id duplication

You have duplication in your activity_id column. Narrator needs this column to be unique because we use it to relate data.

Found NULL values in required columns

Some required columns are missing

You need a column that you don't have in your query. In the error, you should see the column that you need to add.

Found LIMIT in query

Your query has the world LIMIT in it. Please remove limit because the activity stream updates using the sql query wrapped so limits will not be removed.

Types don't match

Ensure that each column is of the appropriate type. For example, the ts column needs to be a timestamp type, not an integer.

Still having trouble?

Our data team is here to help! Here are a couple ways to get in touch...

💬 Chat us from within Narrator

💌 Email us at [email protected]

🗓 Or schedule a 15 minute meeting with our data team