An example of retrieving data from AWS Cloudwatch using Google Script

Log Cloudwatch is the AWS which applications or Bash scripts can send data as strings or JSON, then they can find or construct a variety of graphs by means of the same AWS.

Once I had the desire to get the data from the AWS Cloudwatch Log, process them in a special way and beautiful to present as a graph. Google Spreadsheet is good with data visualization, and previously for a similar task I loaded data into it using Ruby. But the same ruby script need somewhere to host and run periodically, and all he will do is to query data from one API (AWS) and place them in another (Spreadsheet). It would be nice if the Spreadsheet itself could query the data, and it turns out he can, using Google Script. It's amazing how much really can Google docks.

Google Script allows you not only to create custom functions and macros using JavaScript, but to access an external API.
AWS SDK is under JavaScript, so I was not expecting any difficulties, but it was not there. It turned out that this SDK is being imported into the project GS cannot find the object "window" not working.

I had to read the API docks and to implement the calculation of the signature for the request. There is nothing technically challenging, just the bonding lines and the hash computation. So I don't go into details, but simply give its decision on the case if someone will face this challenge.


code posted on GitHub

To test it you can:
the
    the
  • make a copy document
    • the
  • to open the "Tools" - > "script Editor"
    • the
  • in "File"- > "project Properties"->"script Properties" to add lines "access_key_id" and "secret_access_key" to indicate the value of their API keys
    • the
  • Then open the file "Code.gs" and start the function "dataFromCloudWatch"
    • the
  • Results will be visible in "View"->"performance Report". This is for simplicity. In a real problem the answer is easy to parse and insert the values into the corresponding spreadsheet cells.


The code uses the request GetMetricStatistics but if necessary you can request any other method, the signature algorithm will remain unchanged.

Update: I forgot to mention that you can configure periodic start this function via the "Resources"-> Triggers"current project".
Article based on information from habrahabr.ru

Комментарии

Отправить комментарий

Популярные сообщения из этого блога

Performance comparison of hierarchical models, Django and PostgreSQL

Изображение
Good day, dear readers. Today's article will be devoted to the comparison of models of working with hierarchical data in PostgreSQL via Django app. In the article I specifically do not use a clean implementation in the database, because I'm interested in is performance in an environment close to combat. All tests were performed on my data and results are relevant for this data on your data the result may differ from that obtained in the article. Model implementation of the hierarchical structures in the database For working with such structures in PostgreSQL you can use the following modely : the Adjacency model (AM) — model, when the column is stored parent; the Nested Sets (NS) model when paired column stores the range of all sub-elements; the Materialised Path model (MP) model, when the column is stored the full path to the element. Also details about the implementation of hierarchical structures in a relational database, you can read here . To imp...
Далее...

google life search

Изображение
Yesterday Google announced the Live search So, what is it and how to use it? Did it make your search more relevant and convenient for users? How to get it, where to enter a query to see live results? The algorithm is still driven around and while fully works only for English queries. You enter the query and see the results of the search in the middle of the page in the section Latest result for “your request”. Can try enter your query here . For example, a request Obama. About the middle of the page is visible to block the Latest results that are updated in real-time. New results on request Obama constantly updated and added to the search results. If this text is annoying, you can pause by clicking "Pause", but completely remove the "live search" from the results it is impossible. Adam Smith, a Google employee, guiding the development of new search system in real time, says that not all queries can be seen regularly updated information: ...
Далее...

Transport Tycoon Deluxe / Emscripten part 2

Изображение
Transport Tycoon (Transport tycoon) is pretty old, but still enjoyable, especially the maniacs, the game is in the genre of RTS. /.../ There is also OpenTTD, outdoor product manyatta iPhoto, resulting from the game can not be distracted even in the toilet and underground, setting her on the Communicator or PDA. lurkmore I can honestly say: I killed a huge amount of time playing Transport Tycoon Deluxe. I'm just a fan of this game. So when on Habre the article appeared about how the guys from mozilla have ported Doom, I hit on the idea – to migrate one of my favorite games here on the Internet. By the way, the article was scarce, but I learned the main thing – the porting can be done using emscripten . Since the inception of the thought of the possibility of such a project was not less than a year (my first attempt crashed on the rocks of misunderstanding). And now I'm in a hurry to please you all: I did it! Now to sit ass playing TTD you can be located anywhere con...
Далее...