Don't worry, a failed validation is no problem. Watch the corresponding video for each issue.
You have duplication in your
activity_id column. Narrator needs this column to be unique because we use it to relate data.
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.
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.
Ensure that each column is of the appropriate type. For example, the
ts column needs to be a timestamp type, not an integer.
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