Issue with Displaying Multiple Clickable Links in a Single Cell using STRING_AGG and DISTINCT

Get Help
1

I am using an SQL query that employs STRING_AGG and DISTINCT to aggregate multiple URLs into a single cell. Each URL is unique and points to a specific REST API object based on its ID.

Example output: https://example.com/api/object/1/, https://example.com/api/object/2/, https://example.com/api/object/3/

Problem: I want each of these URLs to be recognized and rendered in Metabase as individual clickable links within the same cell. However, Metabase currently treats them as one single string.

Goal: I would like to know if there's a way to configure Metabase to recognize and treat these individual URLs as clickable links, even if they are contained within one cell.

What I've Tried:

  1. I used different delimiters (comma, space) with STRING_AGG to separate the URLs, but Metabase still does not recognize them as separate clickable links.
  2. Considered splitting the URLs into separate cells, but that does not align with the desired report design and format.

Question: Is there any way to get Metabase to recognize and treat these URLs as separate clickable links within a single cell? Any suggestions or configurations I might have overlooked?

Thank you in advance for any help or guidance you can provide.

1 Like