Using SQL Transform

SQL is a powerful tool when you need something very specific from your data. Our SQL transform uses PostgreSQL.

  1. Click the Add Transforms button, then click SQL.
  2. A window will appear where you can write your SQL statement. Click Run when you are finished.
  3. using-sql-transform.gif

  4. On the right, you'll see Grow lists out the different reports you are working with and the column names within each report that could be used in your SQL statement.
  5. Hover over any of the column names to see a small blue 'copy' pop up.
  6. Click the copy button on a specific column name and paste it into the SQL statement, or double-click the column name to insert it into the SQL statement. This is especially helpful for long column names to avoid typing errors.

You can click this copy button on a specific column name and then simply paste it into the SQL statement. You can also double-click the column name to insert it into the SQL statement. This is especially helpful if you have long column names since you no longer have to type out the full name and eliminates potential typos.

Other SQL resources:

  • Intro to SQL
  • Common SQL Queries
  • Using the MasterSQL report
Was this article helpful?