Man pages for madedotcom/retl
Support for common ETL operations and connections
| bqAlterTable | Executes ALTER TABLE DML command to set table option value |
| bqAssertUnique | Checks for duplicates found on primary key |
| bqAuth | Wrapper for the set_service_token that uses... |
| bqCopyDatasetSchema | Copies all tables from one dataset to another through schema... |
| bqCopyTable | Copies table in BigQuery |
| bqCopyTableSchema | Copies table through schema defintion |
| bqCountDuplicates | Counts any duplicate rows in a table when grouped by key(s) |
| bqCreatePartitionTable | Creates partition table for a given sql |
| bqCreateTable | Creates table using given sql |
| bqDataset | Dataset manipulation functions |
| bqDatasetLocation | Gets meta of given dataset |
| bqDeletePartition | Deletes a specific partition of a partition table. |
| bqExistingPartitionDates | Gets existing dates for date partitioned table in BigQuery |
| bqExtractTable | Exports BigQuery table into Google Cloud Storage file |
| bqImportData | Imports data from gs to BigQuery table |
| bqInsertData | Inserts data into BigQuery table |
| bqInsertLargeData | Inserts LARGE data into BigQuery table |
| bqInsertPartition | Inserts data table into a specific partition of a partition... |
| bqPartitionName | Creates partition name by combining table and partition date. |
| bqProject | Functions to work with BigQuery projects |
| bqQuery | Functions that execute query against BigQuery database |
| bqRefreshPartitionData | Functions to update existing partitions in the target table |
| bqSchema | Extract schema as JSON from data.table |
| bqSetdiffSchemas | Finds asymmetric difference between two sets of bq_fields... |
| bqTable | Functions to work with BigQuery tables |
| bqTransformPartition | Functions to transforms partitioned data form one table to... |
| bqUpdateTableDescription | Sets description of the table |
| bqUseLegacySql | Gets the value from the corresponding environment variable as... |
| bqVectorToCase | Returns a case clause based on binning the input vector to... |
| conformHeader | Replace " ", "-" and "_" with a given separator in the... |
| dbExecuteQuery | Executes SQL query against the database |
| dbExecuteQueryFile | Executes statement in the SQL file |
| dbGetConnection | Creates db connection based on the environment variables |
| dcPredictionBody | Creates list for the DoubleClick API call from prediction... |
| dcWriteCustomMetrics | Writes custom metrics to DoubleClick Floodlight requires... |
| disaggregate | Splits table rows into multiple by the integer "by". All... |
| extensionFromFormat | Converts possible BigQuery extract formats to file extensions |
| getMissingDates | Gets dates that are missing from the date range for a give... |
| gsAuth | Authentication for google sheets. Requires access_token.json... |
| gsLoadAll | Loads all sheets from a google spreadsheet into a list with... |
| gsLoadSheet | Loads google spreadsheet via key |
| gsPathUri | makes full path to the gs file from relative part |
| gsTablePath | makes relative path to a file to mirror table path |
| gsUri | Gets gs uri to mirror table by name |
| logModelPerformance | Logs model performance data.frame to BigQuery table |
| metricsToList | Converts named vector of metrics to a list |
| readSql | Creates SQL statement from the source file |
| readSqlGlue | Glues variables passed in ellipsis into a text of the file |
| s3GetData | Loads data from several files in S3 based on the path prefix |
| s3GetFile | Loads data from AWS S3 into data.table object |
| s3GetObjectPath | Gets the path to the object based on the root path setup via... |
| s3ListFiles | Lists files that match given path |
| s3PutFile | Saves data to a file in AWS S3 |
| safeLookup | Function to safely append values to a data.table from another... |
| sqlRange | Functions that allow to convert numeric vector in to SQL case... |
| with_mock_bigquery | Executes given query against stub data from a given query... |
