generate_create_table_sql: Generate create table DDL from a dataframe
In Everlane/everlaneR: Quality of Life Functions for the Everlane Data Scientist
Description
Usage
Arguments
Value
Examples
View source: R/etl_functions.R
Description
Generates SQL to create a new table from R dataframe- useful in conjuction with copying from s3 to Redshift
Usage
1
generate_create_table_sql(table_name, df)
Arguments
table_name
name of table to create on Redshift
df
R dataframe object
Value
string with create table syntax, can be plugged into dbGetQuery
Examples
1
2
3
redshift_conn <- create_redshift_con()
sql_create_statement <- generate_create_table_sql("data.activations",activation_data)
dbGetQuery(redshift_conn, sql_create_statement)
Everlane/everlaneR documentation built on Oct. 7, 2020, 3:13 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Value Examples
View source: R/etl_functions.R
Description
Generates SQL to create a new table from R dataframe- useful in conjuction with copying from s3 to Redshift
Usage
1 | generate_create_table_sql(table_name, df)
|
Arguments
table_name |
name of table to create on Redshift |
df |
R dataframe object |
Value
string with create table syntax, can be plugged into dbGetQuery
Examples
1 2 3 | redshift_conn <- create_redshift_con()
sql_create_statement <- generate_create_table_sql("data.activations",activation_data)
dbGetQuery(redshift_conn, sql_create_statement)
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.