'Embedding hyperlinks in Snowflake table fields
Is it possible to house a clickable URI inside a table row & field in Snowflake?
Example: Table product_master w fields product_name, prod_num, prod_family, prod_price, prod_brochure where prod_brochure is a clickable URI to the slick brochure that can be printed out.
Solution 1:[1]
Yes, if your browser (or wherever you're viewing your Snowflake results) supports making the VARCHAR/text link clickable, as Simon D mentions. Here's a Snowflake query snippet where I make a link from an id column to link to a Salesforce object. Google Chrome automatically makes it clickable in the Snowflake query results using the classic Snowflake worksheet interface:
SELECT 'https://mycompany.lightning.force.com/lightning/r/SF_custom_object_c/' || id || '/view' AS sf_job_link, ...
The results in a Snowflake web UI/Chrome clickable link:
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Ward W |