generate_sql_load: Generate SQL loading statements from a manifest file. This...

In jeff-m-sullivan/ReadRedshift: Read and Validate Redshift Unloads

Generate SQL loading statements from a manifest file. This assumes that the tables need to be created and then the data copied in.

Description

Generate SQL loading statements from a manifest file. This assumes that the tables need to be created and then the data copied in.

Usage

generate_sql_load(manifest_file, s3_url, schema = "", supplement = ";")

Arguments

manifest_file	local path to the manifest file
s3_url	the S3 bucket where the manifest will be stored for loading
schema	(default "") optional schema in which to create the table
supplement	(default ";") supplemental text to add to the SQL query, for example authentication or special delimeters

Value

nothing; SQL statements written to file

jeff-m-sullivan/ReadRedshift documentation built on April 4, 2024, 2:14 a.m.