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-3636] Nise partition time fix. #435

Closed myersCody closed 1 year ago

myersCody commented 1 year ago

COST-3636

SELECT DISTINCT DATE_TRUNC(DATE(usage_start_time), MONTH) AS timestamp  FROM {table_id}.{dataset}.{table_id};

Row | timestamp |  
-- | -- | --
1 | 2023-03-01
SELECT DISTINCT DATE_TRUNC(DATE(usage_start_time), DAY) AS timestamp  FROM {table_id}.{dataset}.{table_id};

1 | 2023-03-16 |  
-- | -- | --
2 | 2023-03-20 |  
3 | 2023-03-15 |  
4 | 2023-03-19 |  
5 | 2023-03-12 |  
6 | 2023-03-21 |  
7 | 2023-03-04 |  
8 | 2023-03-11 |  
9 | 2023-03-07 |  
10 | 2023-03-01 |  
11 | 2023-03-05 |  
12 | 2023-03-13
codecov[bot] commented 1 year ago

Codecov Report

Merging #435 (78ce54e) into main (05fa5ed) will increase coverage by 0.1%. The diff coverage is 100.0%.

@@           Coverage Diff           @@
##            main    #435     +/-   ##
=======================================
+ Coverage   93.7%   93.7%   +0.1%     
=======================================
  Files         61      61             
  Lines       4492    4492             
  Branches     633     633             
=======================================
+ Hits        4207    4211      +4     
+ Misses       155     153      -2     
+ Partials     130     128      -2