We can prevent spending thousands of dollars caused by a mistake using AWS Budget + SNS + Lambda

Guy looking at the money flying away
Guy looking at the money flying away

Unfortunately, there is no ready solution available on AWS to prevent that we lose a lot of money on Lambdas unintentionally. Like in this case: https://medium.com/@asankha/lambda-programming-errors-that-could-cost-you-thousands-of-dollars-a-day-265dfac354f

After facing some similar issues where I was working, I came up with a workaround that can be useful for a lot of other users. However, I recommend it to development or sandbox environments only, because it will force all lambdas in the account to stop working. …


A função windowing permite que você faça agregações ou análises em uma janela de dados. Isso pode ser feito em diversos bancos de dados, mas não todos (Ex: MySQL não tem). No Hive, depois da versão 0.11, passou a ser permitido usar essa função.

Vamos ver algumas funções que podemos usar!

ROWS

Usamos ROWS para delimitar o intervalo dos dados que vamos aplicar as funções de agregação

Vamos trabalhar com dados de ações para entender melhor…

SELECT * FROM stocks LIMIT 10;20100721 A 27.68 28.2 27.41 27.58 44528 20100722 A 27.95 28.87 27.95 28.72 36494 20100723 A 28.56 29.41…

Nina Raminelli

Data Scientist

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store