Using the Workbench tool, from the Analyze menu, allows you to write an SQL query and – once you see the data you expect – save the query. By saving the transformation, it will be available for future use in any visualization tool you connect with.
To save your transformation:
- Click on the three dots in the upper-right corner of the Workbench
- Click Save As…
- Enter a filename, and click Accept