Helpful SQL added to Scratchpad

Stop writing and re-writing the same queries to validate the data in your transformation. By default, the scratchpad contains helpful SQL snippets that you can use to quickly explore and validate the data in your transformation.

The scratchpad contains boilerplate SQL to:

  • explore the data in the table you are using
  • explore the dataset created by your transformation
  • check for duplicate activity_id s
  • check for missing customer values

And the boilerplate SQL will change depending on the transformation type selected.


Scratchpad SQL for an Activity Transformation

Further Reading

User feedback helps Narrator improve. ❤️
We'd love to hear what you think. Email us @ [email protected]