ETL | Repository setup | dettl_config.yml | Creating a new ETL import | Developing the import | Extract | Transform | Load | Running the import | Run functions | Working with import object | Dry run | Other stuff | I want to write an import which creates a table | I want to write a custom load | I want to use the automatic load but make additional changes to the database | What about cycles?
Package: dettl 0.1.0
Robert Ashton
dettl: Data Extract, Transform, Test and Load
Data extract, transform, test and load tool for sanitising your workflow.
Authors:
dettl_0.1.0.tar.gz
dettl_0.1.0.zip(r-4.7)dettl_0.1.0.zip(r-4.6)dettl_0.1.0.zip(r-4.5)
dettl_0.1.0.tgz(r-4.6-any)dettl_0.1.0.tgz(r-4.5-any)
dettl_0.1.0.tar.gz(r-4.7-any)dettl_0.1.0.tar.gz(r-4.6-any)
dettl_0.1.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
dettl/json (API)
| # Install 'dettl' in R: |
| install.packages('dettl', repos = c('https://vimc.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/vimc/dettl/issues
Last updated from:79918d4273 (on master). Checks:7 ERROR, 2 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | ERROR | 139 | ||
| source / vignettes | OK | 184 | ||
| linux-release-x86_64 | ERROR | 149 | ||
| macos-release-arm64 | ERROR | 115 | ||
| macos-oldrel-arm64 | ERROR | 105 | ||
| windows-devel | ERROR | 226 | ||
| windows-release | ERROR | 240 | ||
| windows-oldrel | ERROR | 225 | ||
| wasm-release | OK | 110 |
Exports:dettldettl_auto_loaddettl_create_log_tabledettl_newdettl_rundettl_save
Dependencies:askpassbitbit64briocallrclicrayoncredentialscurlDBIdescdiffobjevaluatefsgertgluejsonlitelifecyclemagrittropensslotelpkgbuildpkgloadpraiseprocessxpsR6rlangrprojrootrstudioapisystestthatwaldowithrwritexlyamlzip
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Create an import object using functions defined at specified path | dettl |
| Automatic load function for append mode imports. | dettl_auto_load |
| Initialise the database by creating log table if it doesn't already exist | dettl_create_log_table |
| Create new directory and templated code for new dettl process. | dettl_new |
| Run specified stages of an import | dettl_run |
| Save data | dettl_save |
| Prepare example import inside a git repo | prepare_test_import |
| Manage R based data import. | RImport |
| Manage SQL based data import. | SqlImport |
