Man pages for madedotcom/retl
Support for common ETL operations and connections

bqAuthWrapper for the set_service_token that uses...
bqCopyTableCopies table in BigQuery
bqCreatePartitionTableCreates partition table for a given sql
bqCreateTableCreates table using given sql
bqDatasetDataset manipulation functions
bqDeletePartitionDeletes a specific partition of a partition table.
bqExistingPartitionDatesGets existing dates for date partitioned table in BigQuery
bqExtractTableExports BigQuery table into Google Cloud Storage file
bqImportDataImports data from gs to BigQuery table
bqInsertDataInserts data into BigQuery table
bqInsertLargeDataInserts LARGE data into BigQuery table
bqInsertPartitionInserts data table into a specific partition of a partition...
bqPartitionFunctions to transforms partitioned data form one table to...
bqPartitionNameCreates partition name by combining table and partition date.
bqProjectFunctions to work with BigQuery projects
bqQueryFunctions that execute query against BigQuery database
bqSchemaExtract schema as JSON from data.table
bqSetdiffSchemasFinds asymmetric difference between two sets of bq_fields...
bqTableFunctions to work with BigQuery tables
bqUseLegacySqlGets the value from the corresponding environment variable as...
bqVectorToCaseReturns a case clause based on binning the input vector to...
conformHeaderReplace " ", "-" and "_" with a given separator in the...
dbExecuteQueryExecutes SQL query against the database
dbExecuteQueryFileExecutes statement in the SQL file
dbGetConnectionCreates db connection based on the environment variables
dcPredictionBodyCreates list for the DoubleClick API call from prediction...
dcWriteCustomMeticsWrites custom metrics to DoubleClick Floodlight requires...
disaggregateSplits table rows into multiple by the integer "by". All...
extensionFromFormatConverts possible BigQuery extract formats to file extensions
getMissingDatesGets dates that are missing from the date range for a give...
gsAuthAuthentication for google sheets. Requires access_token.json...
gsLoadAllLoads all sheets from a google spreadsheet into a list with...
gsLoadSheetLoads google spreadsheet via key
gsPathUrimakes full path to the gs file from relative part
gsTablePathmakes relative path to a file to mirror table path
gsUriGets gs uri to mirror table by name
logModelPerformanceLogs model performance data.frame to BigQuery table
metricsToListConverts named vector of metrics to a list
readSqlCreates SQL statement from the source file
s3GetDataLoads data from several files in S3 based on the path prefix
s3GetFileLoads data from AWS S3 into data.table object
s3GetObjectPathGets the path to the object based on the root path setup via...
s3ListFilesLists files that match given path
s3PutFileSaves data to a file in AWS S3
safeLookupFunction to safely append values to a data.table from another...
sqlRangeFunctions that allow to convert numeric vector in to SQL case...
madedotcom/retl documentation built on July 14, 2019, 8:36 p.m.