search

project-koku / nise

A tool for generating sample cost usage data for testing purposes
GNU Affero General Public License v3.0
9 stars 15 forks source link

COST-1900: Add _PARTITIONTIME to GCP Nise Upload #399

Closed myersCody closed 2 years ago

myersCody commented 2 years ago 
SELECT DATE(_PARTITIONTIME), DATETIME(max(export_time)) FROM `{{table_id}}` GROUP BY _PARTITIONTIME

Results:

f0_ | f1_ |  
-- | -- | --
1 | 2022-07-03 | 2022-07-04T05:36:04 |  
2 | 2022-07-13 | 2022-07-14T04:24:46 |  
3 | 2022-07-04 | 2022-07-05T05:40:23 |  
4 | 2022-07-15 | 2022-07-16T05:38:06 |  
5 | 2022-06-14 | 2022-06-15T05:56:53 |  
6 | 2022-06-15 | 2022-06-16T05:27:23 |  
7 | 2022-06-29 | 2022-06-30T05:36:38 |  
8 | 2022-07-12 | 2022-07-13T05:22:40 |  
9 | 2022-07-16 | 2022-07-17T04:55:52 |  
10 | 2022-06-28 | 2022-06-29T05:36:22
codecov[bot] commented 2 years ago

Codecov Report

Merging #399 (8d25fcf) into main (cb413d5) will increase coverage by 0.1%. The diff coverage is 100.0%.

:exclamation: Current head 8d25fcf differs from pull request most recent head 66fdbe5. Consider uploading reports for the commit 66fdbe5 to get more accurate results

@@           Coverage Diff           @@
##            main    #399     +/-   ##
=======================================
+ Coverage   93.8%   93.9%   +0.1%     
=======================================
  Files         57      57             
  Lines       4215    4217      +2     
  Branches     615     615             
=======================================
+ Hits        3955    3961      +6     
+ Misses       147     145      -2     
+ Partials     113     111      -2