Skip to contents

The db Schema

rpwf_schema.Rd

Wrapper around the SQL queries that holds the table definitions.

Usage

rpwf_schema()

Value

a named list with containing SQL query strings defining a table.

Details

Here are the tables available in the database. Print out the raw SQL code with rpwf_schema()$<table name> to see constraints and variable names.

  • model_type_tbl: defines comparable models in R and python.

  • df_tbl: holds the transformed data (train and test) to pass to python.

  • r_grid_tbl: holds hyper param grids created in R.

  • wflow_tbl: defines all the params needed to run a ML model in sklearn.

  • wflow_result_tbl: holds results of the workflow ran by python.

Examples

definitions <- rpwf_schema()
names(definitions)
#> [1] "model_type_tbl"   "r_grid_tbl"       "df_tbl"           "wflow_tbl"       
#> [5] "wflow_result_tbl"