Skip to content

Instantly share code, notes, and snippets.

@OatmealLick
Created July 17, 2023 10:03
Show Gist options
  • Save OatmealLick/50eeec4f6dfa91e3fa958824f94dd7f9 to your computer and use it in GitHub Desktop.
Save OatmealLick/50eeec4f6dfa91e3fa958824f94dd7f9 to your computer and use it in GitHub Desktop.
Custom schema for data contracts (supporting BigQuery types)
fields:
- name: _string
type: string
- name: _bytes
type: bytes
- name: _integer
type: integer
- name: _int64
type: integer
- name: _float64
type: float
- name: _bool
type: boolean
- name: _timestamp
type: timestamp
- name: _date
type: date
- name: _time
type: time
- name: _datetime
type: datetime
- name: _numeric
type: numeric
- name: _bignumeric
type: bignumeric
- name: _struct1
type:
fields:
- name: a
type: integer
- name: b
type: string
- name: _struct2
type:
fields:
- name: a
type: integer
- name: b
type:
fields:
- name: a
type: integer
- name: b
type: string
- name: _array_int
type: integer
repeated: yes
- name: _array_string
type: string
repeated: yes
- name: _array_struct
type:
fields:
- name: a
type: integer
- name: b
type: string
repeated: yes
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment