System Tables / Audit Logs action_name createWarehouse/createEndpoint

Hertz
New Contributor II

I am creating a cost dashboard across multiple accounts. I am working get sql warehouse names and warehouse ids so I can combine with system.access.billing on warehouse_id.  But the only action_names that include both the warehouse_id and warehouse_name is the editEndpoint/editWarehouse and deleteEnpoint/deleteWarehouse  actions. Is there another was to do this without have to create a bearer token for each account and using the warehouse api? You would think the warehouse_id would also be in the createWarehouse/createEndpoint actions data.

Hertz
New Contributor II

I just wanted to circle back to this. It appears that the ID is returned in the response column of the create action_name.