Skip to content

Instantly share code, notes, and snippets.

@drewbanin

drewbanin/bq-partitioning.sql

Created May 12, 2020 16:20
Show Gist options
  • Save drewbanin/c1a7f154b4bc26983dc2bd619d46ff97 to your computer and use it in GitHub Desktop.
Save drewbanin/c1a7f154b4bc26983dc2bd619d46ff97 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bq-partitioning.sql
{{config(
materialized = 'table',
partition_by = { 'field': 'created_at_timestamp', 'data_type': 'timestamp' }
)}}
select
timestamp(created_at) as created_at_timestamp,
...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment