IMAGE

SyntaxSyntax

IMAGE( src [ , width [ , height [ , alt ] ] ] )

DescriptionDescription

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

ExamplesExamples

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 supportData source support

ClickHouse 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Yandex Documents, YDB.