read_sql: read_sql (deprecated)
In moj-analytical-services/Rdbtools: Connects the MoJ Analytical Platform to Athena
read_sql R Documentation
read_sql (deprecated)
Description
A convenience function to match dbtools which reads a table into a tibble or dataframe.
Please now use dbGetQuery() directly instead.
Usage
read_sql(sql_query, return_df_as = "tibble", conn = NULL)
Arguments
sql_query
A sql command which is passed to dbGetQuery()
return_df_as
must be 'tibble' or 'data.table'.
conn
(optional) A DBIConnection object, as returned by connect_athena(). If unused then the query will create its own connection and close it subsequently. If reading a table created by a previous connection then the same connection must be supplied, otherwise you may get permission errors.
moj-analytical-services/Rdbtools documentation built on June 22, 2024, 8:46 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.
| read_sql | R Documentation |
read_sql (deprecated)
Description
A convenience function to match dbtools which reads a table into a tibble or dataframe.
Please now use dbGetQuery() directly instead.
Usage
read_sql(sql_query, return_df_as = "tibble", conn = NULL)
Arguments
sql_query |
A sql command which is passed to |
return_df_as |
must be 'tibble' or 'data.table'. |
conn |
(optional) A DBIConnection object, as returned by |
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.