Basic |
|
---|---|
|
Data model class |
Load a dm from a remote data source |
|
Tables |
|
Add tables to a |
|
Remove tables |
|
Update tables in a |
|
Select and rename tables |
|
Retrieve a table |
|
Merge several |
|
Primary keys |
|
Add a primary key |
|
Check for primary key |
|
Get all primary keys of a |
|
Remove a primary key |
|
Primary key candidate |
|
Foreign keys |
|
Add foreign keys |
|
Get foreign key constraints |
|
Remove foreign keys |
|
Foreign key candidates |
|
Check foreign key reference |
|
Get the names of referencing tables |
|
Visualize |
|
Draw a diagram of the data model |
|
Color in database diagrams |
|
Create R code for a dm object |
|
Select columns |
|
Select columns |
|
Rename columns |
|
Flatten |
|
Flatten a part of a |
|
Join two tables |
|
Resolve column name ambiguities |
|
Zoom |
|
|
Mark table for manipulation |
|
dplyr table manipulation methods for zoomed dm objects |
tidyr table manipulation methods for zoomed dm objects |
|
|
dplyr join methods for zoomed dm objects |
utils table manipulation methods for |
|
Wrap |
|
Wrap dm into a single tibble dm |
|
Unwrap a single table dm |
|
Nest a table inside its dm |
|
dm_pack_tbl() |
|
Unnest columns from a wrapped table |
|
Unpack columns from a wrapped table |
|
Materialize |
|
Materialize |
|
Upload |
|
Copy data model to data source |
|
|
Modifying rows for multiple tables |
|
Updating database tables |
Truncate all rows |
|
Extract and check the RETURNING rows |
|
Filter |
|
Filtering |
|
Get filter expressions |
|
Table surgery |
|
Decompose a table into two linked tables |
|
Merge two tables that are linked by a foreign key relation |
|
Check keys and cardinalities |
|
Validate your data model |
|
Learn about your data model |
|
|
Check table relations |
Check if column(s) can be used as keys |
|
Check column values for subset |
|
Check column values for set equality |
|
Database schemas |
|
Create a schema on a database |
|
Remove a schema from a database |
|
Check for existence of a schema on a database |
|
List schemas on a database |
|
Miscellaneous |
|
Creates a dm object for the nycflights13 data |
|
Creates a dm object for the Financial data |
|
Creates a dm object for the pixarfilms data |
|
Number of rows |
|
Prototype for a dm object |
|
Pack Join |