In GCP, is there any way CloudQuery could also sync folders and tie projects to a folder using _cq_parent_id or another attribute?
Had a request from someone on the team that they’d like to see the folders that resources in a project belong to so they can roll them up by department.
I think the best way to accomplish this would be to write a query that joins the GCP Resource View on the gcp_resourcemanager_projects table. That table contains all of the information about a project’s parent, which is the folder/org that owns the resource.
Oh interesting, didn’t realize that was in that table. Thanks!