13.2. Retrieving Information about a Simple Secret (duckdb.show_simple_secret) #
Required privileges: Postgres Pro AXE administrator only. For a full list of stored procedures and privileges, refer to Section 12.1.
Execute the following command on the Postgres Pro AXE server:
SELECT * FROM duckdb.show_simple_secret() ON CONFLICT DO NOTHING;
Postgres Pro AXE returns 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 13.2. Executing the duckdb.show_simple_secret Stored Procedure
SELECT * FROM duckdb.show_simple_secret() ON CONFLICT DO NOTHING;
secret_name | secret_type | options
------------------+-------------+-----------------------------------
simple_s3_secret | S3 | region 'us-east-1', endpoint 'minio.example.com:9000'