payment_success
in BigQuery with event attributes transaction_amount
and payment_method
.
You can create a payment_success_history
table in BigQuery with the following command:
payment_success_history
table partitioned by formatted_event_ts
with all events that were synced in the last six months.
Please note that the default event_timestamp
column created by Firebase is in epoch microseconds,
and Castled expects timestamps as TIMESTAMP/DATETIME. Therefore, we have created a new column formatted_event_ts
, from the original epoch event_timestamp column.
Configure the date suffix accordingly to include the events you are interested in.
transaction_amount
, payment_method
) in a single record column.
To make these parameters usable, it’s essential to unnest them in the query used for creating an event schema.
Navigate to Settings → Schemas in Castled and create an event schema.
formatted_event_ts
in this case and create a relationship to the user schema)