bqRefreshPartitionData: Functions to update existing partitions in the target table

In madedotcom/retl: Support for common ETL operations and connections

Functions to update existing partitions in the target table

Description

'bqRefreshPartitionData' updates existing partitions in the target table

Usage

bqRefreshPartitionData(
  table,
  file,
  ...,
  priority = "BATCH",
  use.legacy.sql = bqUseLegacySql()
)

Arguments

table	destination partition table where results of the query will be saved
file	path to the sql file that will be used for the transformation
...	parameters that will be passed via 'sprintf' to build dynamic SQL. partition date will be always passed first in format 'yyyymmdd' followed by arguments in '...'
priority	sets priority of job execution to INTERACTIVE or BATCH
use.legacy.sql	sets SQL flavour

madedotcom/retl documentation built on Sept. 19, 2022, 3:28 a.m.