Generate a Column of Continuous Dates in BigQuery

GROWING This note is being developed. It is readible but changes are being applied.
til/data/bigquery-generate-continuous-dates-as-a-column.md Current Note ID: The unique ID of this note.
#Data Warehouse #Big Query

Generate a table with a column of continuous dates

SELECT
  *
FROM
  UNNEST( GENERATE_DATE_ARRAY( CURRENT_DATE(), DATE('2014-01-01'), INTERVAL -1 DAY) ) AS day

Planted: by ;

Similar Articles:
BigQuery Meta Tables
Meta tables are very useful when it comes to get bigquery table information programmatically.
Calculate Moving Average Using SQL/BigQquery
Snippet for calculating moving avg using sql/biguqery
Get Current User in BigQuery
BigQuery Current User
Materialize the Query Result for Performance
Materialize the query result for multistage queries to make your query faster and lower the costs.

Lei Ma (2019). 'Generate a Column of Continuous Dates in BigQuery', Datumorphism, 05 April. Available at: https://datumorphism.leima.is/til/data/bigquery-generate-continuous-dates-as-a-column/.