CODEWITHSUNDEEP
sqlgoogle-bigquery
Xiaomeng Yi
Xiaomeng Yi

Reputation: 137

How to join table with table_range function in BigQuery?

SELECT
  *
FROM TABLE_DATE_RANGE(dataset.tableA, DATE_ADD(CURRENT_TIMESTAMP(), -1,'day'), DATE_ADD(CURRENT_TIMESTAMP(), -1, 'day')) AS org_table
JOIN (
  SELECT
    name,
    id
  FROM
    dataset.tableB) AS new_table
ON
   org_table.id = new_table.id

BigQuery don't allow me to give alias for TABLE_DATE_RANGE(), how to do this join ?

Upvotes: 2

Views: 1191

Answers (1)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173046

SELECT
  *
FROM (
  SELECT * 
  FROM TABLE_DATE_RANGE(dataset.tableA, DATE_ADD(CURRENT_TIMESTAMP(), -1,'day'), DATE_ADD(CURRENT_TIMESTAMP(), -1, 'day'))
) AS org_table
JOIN (
  SELECT
    name,
    id
  FROM
    dataset.tableB) AS new_table
ON
   org_table.id = new_table.id

Upvotes: 4

Related Questions