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.

Further Reading

• Learn more about the various transformation types.
• Learn more about data validation for transformations.

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