19.2. Retrieving Information about a Simple Secret (duckdb.show_simple_secret) #
Required privileges: Postgres Pro AXE administrator only. For more information about stored procedures and privileges, refer to Section 18.1.
Execute the following command on the Postgres Pro AXE server:
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
You cannot retrieve the access key and the secret access key for connecting to the S3 storage.
Example 19.2. Executing the duckdb.show_simple_secret Stored Procedure
SELECT * FROM duckdb.show_simple_secret();
secret_name | secret_type | options
------------------+-------------+-----------------------------------
simple_s3_secret | S3 | region 'us-east-1', endpoint 'minio.example.com:9000'