MD_LIST_BUCKETS_FOR_SECRET

MD_LIST_BUCKETS_FOR_SECRET() lists the S3 buckets visible to the named secret.

note

This function takes a secret name, not a bucket name. It supports S3 secrets only.

Syntax

FROM md_list_buckets_for_secret('<secret_name>');

Output

Column Name	Data Type	Value
name	VARCHAR	Bucket name
creation_date	DATE	Bucket creation date
region	VARCHAR	Bucket region
arn	VARCHAR	Bucket ARN, when available

Example usage

FROM md_list_buckets_for_secret('__default_s3');