Hyperlink in SQL Runner Results

[Yasuhiro_Takagi]

Hi! I’m just a beginner and forgive me if I use terms incorrectly.
I know we can set hyperlinks in lookML, but not sure how to do it in SQL Runner.

I just googled and found there is a way to concat like

‘<a href="www.urlxxx.com/profile_id=’ || profile.id || ‘>XXX’

Atlassian Community – 22 Apr 15

Display a column in the SQL results as a link to an FTP site

One of the columns I am returning from a SQL query is an link to a file on a FTP server.  Is there a way I can make the results be a hyperlink to the file?  I am using the Bob Swift SQL add-on

But in the SQL Runner result just shows
<a href="www.urlxxx.com/profile_id=profile.id>XXX
not as a hyperlink.

*I don’t have Developer mode authorization (I’m just a business user).

Thank you so much!

[Dawid]

It looks like SQL Runner takes the columns as text and treats them as such throughout the layers. That means even the visualisation layer of Table or Table (Legacy) is not considering text to be HTML.

I have a full admin access and there is no difference in behaviour with yours, which means it’s not because you haven’t got Developer access.

[Yasuhiro_Takagi]

Thank you so much for your fast answer! So will there be no way to set hyperlinks?

[Dawid]

Considering the HTML is not treated as HTML I don’t think so, unless there’s a hack I’m not aware of. You’d have to ask the Devs to include it in the model

[Yasuhiro_Takagi]

I understand. Thank you for your help!