BigQuery Table_Partition_Range - Last 7 Days

BigQuery to retrieve data for Last 7 Days dynamically applying Table_Date_Range:

SELECT *
, DateDiff(DATE_ADD(CURRENT_TIMESTAMP(), -1, 'Day'), DATE_ADD(CURRENT_TIMESTAMP(), -6, 'Day')) Days
FROM (TABLE_DATE_RANGE([dataset.tablename_],DATE_ADD(CURRENT_TIMESTAMP(), -6, 'Day'),
                      DATE_ADD(CURRENT_TIMESTAMP(), -1, 'Day')))
LIMIT 10;

BigQuery Table_Partition_Range - Last 7 Days

BigQuery to retrieve data for Last 7 Days dynamically applying Table_Date_Range:

SELECT *
, DateDiff(DATE_ADD(CURRENT_TIMESTAMP(), -1, 'Day'), DATE_ADD(CURRENT_TIMESTAMP(), -6, 'Day')) Days
FROM (TABLE_DATE_RANGE([dataset.tablename_],DATE_ADD(CURRENT_TIMESTAMP(), -6, 'Day'),
                      DATE_ADD(CURRENT_TIMESTAMP(), -1, 'Day')))
LIMIT 10;