Is there a way to query Warehouse and its properties (size, type, policy, auto suspension time etc.) from a table. Need this info to be able to easily write a monitoring process.
1 Answers
Yes, it is possible to get properties in tabular format:
SHOW WAREHOUSES;
-- if additional processing of the output of SHOW command is required
SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID()));
Related