Запрос создания external data source:
CREATE OBJECT aws_auth_access_key_id (TYPE SECRET) WITH (value = "some_id");
CREATE OBJECT aws_auth_access_key_secret (TYPE SECRET) WITH (value = "some_token");
CREATE EXTERNAL DATA SOURCE tutorial_analytics_bucket_aws WITH (
SOURCE_TYPE="ObjectStorage",
LOCATION="https://storage.yandexcloud.net/yq-sample-data/",
AUTH_METHOD="AWS",
AWS_ACCESS_KEY_ID_SECRET_NAME="aws_auth_access_key_id",
AWS_SECRET_ACCESS_KEY_SECRET_NAME="aws_auth_access_key_secret",
AWS_REGION="ru-central-1"
);
Скрин диагностики для external data source:
Скрин describe для external data source:
