external_table_check_f: Compare external table to source table to find changes

In PHSKC-APDE/apde: Common functions used in APDE's work

Compare external table to source table to find changes

Description

Compare external table to source table to find changes

Usage

external_table_check_f(
  conn,
  db = c("inthealth_edw", "inthealth_dwhealth"),
  schema,
  table,
  db_ext = "hhs_analytics_workspace",
  conn_ext,
  schema_ext,
  table_ext,
  sql_display = T,
  sql_file_path = NULL,
  overwrite = T
)

Arguments

conn	SQL server connection created using odbc package
db	name of database/data warehouse for source table, must be inthealth_edw or inthealth_dwhealth
schema	name of schema for source table
table	name of source table
db_ext	name of database/data warehouse for external table
conn_ext	name of the connection to the SQL database with source external
schema_ext	name of schema for external table
table_ext	name of external table
sql_display	show the SQL script in Console
sql_file_path	write the SQL script to file
overwrite	overwrite sql script, appends if FALSE

Examples

 ## Not run: 
  # ENTER EXAMPLES HERE
 
## End(Not run)
 

PHSKC-APDE/apde documentation built on April 14, 2025, 10:46 a.m.