SQL to add column to a table in schema??

[Mary Heather Cox]

What kind of SQL is expected? That's a very interesting parse of very simple SQL query.

[Jessie Turpin]

Hi Mary! When creating a custom column in your data source's schema you won't need to include typical SQL statements like SELECT, FROM, etc because the custom column can only be created from a column that already exists in that specific table. You can read more about the settings of a custom column and see an example in our documentation. If you'd like to create a column referencing more than one table, you will need to create a custom table instead. 

To create a custom column in the Issue field table with your custom field 'Product', try using the following Case statement: CASE WHEN Name = 'Product' THEN Value END

Let us know if you have any other issues adding your custom column!