Clickable URLs in Tables

You can use this template to create clickable links in your table:

SELECT 'http://demo.redash.io/queries/' || id  || '/source' AS url, name, created_at
FROM queries
WHERE is_archived = false
AND name != 'New Query'

Please note that || is a PostgreSQL operator/function - for other databases, you'll need to use the suitable concat operator.

The results will be clickable links, like in this query in our demo account: http://demo.redash.io/queries/3420/source

You can also use the anchor tag to show a name instead of the URL:

SELECT '<a href="https://demo.redash.io/queries/' || id || '">' || name || '</a>' as name
...

Still need help? Contact Us Contact Us