Example SQL with incremental tables

example.sql

config {
  type: "incremental",
  description: "Counts the amount of specific events per session per day.",
  schema: "monitoring",
  tags: ["ga4"],
  bigquery: {
   partitionBy: "event_date",
 }
}

select
  CAST(event_date AS DATE FORMAT 'YYYYMMDD') as event_date,
  count(distinct concat(user_pseudo_id,(select value.int_value from unnest(event_params) where key = 'ga_session_id'))) as value
from
  ${ when (incremental(), ref(dataform.projectConfig.vars.GA4_TABLE))}
  ${ when(!incremental(), `\`${constants.GA4_DATABASE}.${constants.GA4_DATASET}.events_*\``) }
  ${ when(!incremental(), "where contains_substr(_TABLE_SUFFIX, 'intraday') is not true") }
group by
  event_date