Espanso Big Query SQL Starter

default.yml

matches:
  - trigger: ":4"
    replace: "GA4Dataform"
  - trigger: ":micro"
    replace: "timestamp_micros(event_timestamp) as ts"
  - trigger: ":ts"
    replace: "_table_suffix between '20210701' and '20210701'"
  - trigger: ":sql"
    replace: "select\n\tdate,\ncount(*) as n\n\bfrom x\ngroup by 1\norder by n desc"
  - trigger: ":evs"
    replace: "(select value.string_value from unnest(event_params) where key = 'page_location')"
  - trigger: ":evi"
    replace: "(select value.int_value from unnest(event_params) where key = 'ga_session_id')"
  - trigger: ":pd"
    replace: "parse_date('%Y%m%d', event_date) as date,"
  - trigger: ":item"
    replace: "(select value.string_value from unnest(i.item_params) where key = '..')"
  - trigger: ":round"
    replace: "round(100 * safe_divide(x , y),1) || '%'"
  - trigger: ":rows"
    replace: "ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING"
  - trigger: ":sample"
    replace: "TABLESAMPLE SYSTEM (1 PERCENT)"