Looker is launching a Digital Ocean Stop Droplet action, allowing customers to manage their IT infrastructure directly from within Looker. This action will allow Looker customers to stop a Digital Ocean droplet on a one-off or scheduled basis.
Note: Your Looker instance must be on Looker 5.6.
To enable the action in Looker, go to your Admin panel. Then in the Platform section, click the Actions Tab. (Admin > Platform > Actions).
Select “Enable” on the Digital Ocean Stop Droplet Action you would like to enable.
In your Digital Ocean API Settings, generate and copy a Digital Ocean Droplet Access Key [https://cloud.digitalocean.com/settings/api/tokens]. (Digital Ocean API -> Tokens -> Generate Token)
Copy your Digital Ocean API key and paste into the Looker Actions Page.
Great, now you’ve setup your API keys so that Looker can communicate with Digital Ocean!
dimension: digitalocean_droplet_id {
sql: ${TABLE}.digitalocean_droplet_id ;;
tags: ["digitalocean_droplet_id"]
}
In Looker, view a Look or explore data that displays the Digital Ocean droplets you want to stop, e.g. high cost and low utilized droplets.
To stop a single droplets, select the ellipsis next to the ID tagged with digitalocean_droplet_id.
Then start to send the data now or schedule the data to be sent later or periodically to stop a full list of Digital Ocean droplets.
In the Send or Schedule window’s Destination field, select “Digital Ocean Stop Droplet”.
Your droplets will be stopped in your Digital Ocean management console!