Returns information for managed folders in a bucket. Managed folders allow granular IAM access control within a bucket. Requires hierarchical namespace to be enabled on the bucket.

Table-Specific Information

SELECT

The provider uses the Google Cloud Storage API to process WHERE clause conditions built with the following columns and operators.

• Name supports the =, LIKE operators.
• Bucket supports the = operator.

For example, the following queries are processed server-side:

SELECT * FROM Information.AllManagedFolders WHERE Id = 'test_bucket/newmanagedfolder/'

SELECT * FROM Information.AllManagedFolders WHERE Name = 'test'

The rest of the filter is executed client-side within the provider.

INSERT

The following is an example of how to insert into the AllManagedFolders table:

INSERT INTO Information.AllManagedFolders (Bucket, Name) VALUES ('test_bucket', 'testee')

DELETE

The following is an example of how to delete from the AllManagedFolders table:

DELETE FROM Information.AllManagedFolders WHERE Id = 'test_bucket/test_folder/'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The ID of the managed folder (bucket name + managed folder path).
Name	String	False		The name of the managed folder, expressed as a path (e.g., example-dir/ or example-dir/subdir/).
Bucket	String	False		The name of the bucket containing this managed folder.
CreateTime	Datetime	True		The creation time of the managed folder in RFC 3339 format.
UpdateTime	Datetime	True		The time at which the managed folder's metadata or IAM policy was last updated in RFC 3339 format.
MetaGeneration	Long	True		The metadata generation of the managed folder.