ARCS Snowflake Query - Make period name parameter instead of hardcoding month
I am trying to pass in period name to my Snowflake query in ARCS. I am not sure what I should be trying to use in the Query when setting this up. I have tried to use the same parameter that I pass through to Cloud Financials ($START_PERIODKEY[MMM-yy]$) but that has not worked.
Content (please ensure you mask any confidential information):
I want to be able to pull in information from Snowflake that reads off the Period Name in Data Integration vs having to hard code the month in the Query section of Data Integration.
Version (include the version you are using, if applicable):