23.2. Retrieving Information About a Simple Secret (duckdb.show_simple_secret) #
Execute the following command:
SELECT * FROM duckdb.show_simple_secret();
Postgres Pro AXE outputs the following columns:
secret_name: The simple secret name.secret_type: The simple secret type.options: The S3 storage connection parameters specified when creating the simple secret.Note
The access key and secret access key for connecting to the S3 storage are not retrieved.
Example 23.2. Calling the duckdb.show_simple_secret() function
SELECT * FROM duckdb.show_simple_secret();
secret_name | secret_type | options
------------------+-------------+-----------------------------------
simple_s3_secret | S3 | region 'us-east-1', endpoint 'minio.example.com:9000'