View source: R/HelperFunctions.R
translateSqlFile | R Documentation |
This function takes SQL and translates it to a different dialect.
translateSqlFile( sourceFile, targetFile, targetDialect, tempEmulationSchema = getOption("sqlRenderTempEmulationSchema"), oracleTempSchema = NULL )
sourceFile |
The source SQL file |
targetFile |
The target SQL file |
targetDialect |
The target dialect. Currently "oracle", "postgresql", "pdw", "impala", "sqlite", "netezza", "bigquery", "spark", and "redshift" are supported. |
tempEmulationSchema |
Some database platforms like Oracle and Impala do not truly support temp tables. To emulate temp tables, provide a schema with write privileges where temp tables can be created. |
oracleTempSchema |
DEPRECATED: use |
This function takes SQL and translates it to a different dialect.
## Not run: translateSqlFile("myRenderedStatement.sql", "myTranslatedStatement.sql", targetDialect = "postgresql" ) ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.