rs_create_statement: Generate create table statement for Amazon Redshift

In sicarul/redshiftTools: Amazon Redshift Tools

Description

This lets you easily generate a table schema from a data.frame, which allows for easily uploading to redshift afterwards.

Usage

rs_create_statement(df, table_name = deparse(substitute(df)), sortkeys,
  sortkey_style = "compound", distkey, distkey_style = "even",
  compression = T)

Arguments

df	the data.frame you want to upload to Amazon Redshift
table_name	the name of the table to create, if not specified it'll use the data.frame name
sortkeys	Column or columns to sort the table by
sortkey_style	Sortkey style, can be compound or interleaved http://docs.aws.amazon.com/redshift/latest/dg/t_Sorting_data-compare-sort-styles.html
distkey	Distkey column, can only be one, if chosen the table is distributed among clusters according to a hash of this column's value.
distkey_style	Distkey style, can be even or all, for the key distribution use the distkey parameter. http://docs.aws.amazon.com/redshift/latest/dg/t_Distributing_data.html
compression	Add encoding for columns whose compression algorithm is easy to guess, for the rest you should upload it to Redshift and run ANALYZE COMPRESSION

Examples

n=1000
testdf = data.frame(
a=rep('a', n),
b=c(1:n),
c=rep(as.Date('2017-01-01'), n),
d=rep(as.POSIXct('2017-01-01 20:01:32'), n),
e=rep(as.POSIXlt('2017-01-01 20:01:32'), n),
f=rep(paste0(rep('a', 4000), collapse=''), n) )

cat(rs_create_statement(testdf, table_name='dm_great_table'))

sicarul/redshiftTools documentation built on July 23, 2021, 2:59 a.m.