| # query_mid.py | |
| queries = { | |
| "query": """ | |
| SELECT | |
| * | |
| FROM | |
| `fynd-db.finance_recon_tool_asia.COD_Email_Upload_Status` | |
| WHERE | |
| PARSE_DATE('%e-%b-%Y',Date) = CURRENT_DATE() | |
| and label = "PG_Combine_report" | |
| ORDER BY | |
| PARSE_DATE('%e-%b-%Y',Date) asc | |
| """ | |
| } | |
| # query_mid.py | |
| queries = { | |
| "query": """ | |
| SELECT | |
| * | |
| FROM | |
| `fynd-db.finance_recon_tool_asia.COD_Email_Upload_Status` | |
| WHERE | |
| PARSE_DATE('%e-%b-%Y',Date) = CURRENT_DATE() | |
| and label = "PG_Combine_report" | |
| ORDER BY | |
| PARSE_DATE('%e-%b-%Y',Date) asc | |
| """ | |
| } | |