When a query is launched inside a program (dataflow, Apps script, python….) please add a header to describe the query. That's really important for log analysis and because the cost is directly linked on the database use. So its better if we can detect queries that are not used anymore.
You can find the header description below :
Field | Description |
project | The name of the project or program |
program | Dataflow, apps script, python, datalab... |
function | The name of the function |
frequency | the frequency of the query |
owner | owner of the program, could be a service account a user login into the tool |
SQL | Legacy or standard |
Link | filename or link if it’s a Google document |
Example :
/*============================================================*/
/*project : SolvIA - program : Apps script */
/*function : load_daily_freshdesk_tickets */
/*frequency : Daily - owner : david.tonda@solvay.com */
/*SQL : Standard */
/* Link: https://script.google.com/a/solvay.com/d/1c8rvwEhtsI85u... */
/*============================================================*/
This list is not exhausted you can add what you want to be identified a query.
The best way to get IT support is to use the new
Service One Platform.