IMAGE
Syntax
IMAGE( src [ , width [ , height [ , alt ] ] ] )
Description
Enables inserting an image located at the src
address to the table. The width
and height
values are provided in pixels. If one of the dimensions is NULL
, it will be calculated automatically in proportion to the other. If both dimensions are NULL
, the image will be inserted with the original width and height. In case there are issues when uploading the image, the function will display the alt
text.
Images can be added from the *.yandex.ru
, *.yandex.net
, yastat.net
, yastatic.net
, or storage.yandexcloud.net
domains. The easiest way is to upload and publish the image in Yandex Object Storage (see the pricing here).
Argument types:
src
—String
width
—Integer
height
—Integer
alt
—String
Return type: Markup
Examples
IMAGE('https://storage.yandexcloud.net/functions********/nature-01.jpg', 250, 150, 'alt-text-1')
IMAGE('https://storage.yandexcloud.net/functions********/nature-02.jpg', NULL, NULL, 'alt-text-2')
Data source support
ClickHouse 21.8
, Microsoft SQL Server 2017 (14.0)
, MySQL 5.7
, Oracle Database 12c (12.1)
, PostgreSQL 9.3
, YDB
.