I have a list in a column in Snowflake table as shown below. All I want to do is to remove the brackets and double quotes and just keep it as comma separated. Please help me achieve this.
[ "Availability", "Category Level 1", "Crawl Date", "Price", "Retailer" ]
Availability, Category Level 1, Crawl Date, Price, Retailer
ARRAY_TO_STRING converts an array to text:
SELECT ['Availability', 'Category Level 1', 'Crawl Date', 'Price', 'Retailer' ] AS arr ,ARRAY_TO_STRING(arr, ',');