2. Transactions_stg (data preparation: _temp_transactions)

NoteThis transformation contains intermediate data preparation and creates a table ‘_temp_transactions’. This table you will use in the following transformations.

Use the SQL code below and change {{projectId}} and {{datasetName}} to your own.

#Intermediate table with transactions
WITH
  #Set the date range for the calculation
    dates as 
      ( 
        SELECT
          '20220901' AS date_start,
          '20220930' AS date_end, 
      )

SELECT 
  transactions.* 
FROM 
  dates as d, `{{projectId}}.{{datasetName}}._temp_objects` 
WHERE 
  date BETWEEN PARSE_DATE('%Y%m%d', d.date_start) AND PARSE_DATE('%Y%m%d', d.date_end) and transactions.date is not null

You will get the data in the table '_temp_transactions' with the schema below: