anti_join.tbl_sql |
SQL Joins |
close_connection |
Close connection to the database |
create_logs_if_missing |
Create a table with the SCDB log structure if it does not exists |
create_table |
Create a historical table from input data |
db_locks |
Sets, queries and removes locks for database tables |
db_timestamp |
Determine the type of timestamps the database supports |
defer_db_cleanup |
Delete table at function exit |
digest_to_checksum |
Computes an checksum from columns |
filter_keys |
Filters .data according to all records in the filter |
full_join.tbl_sql |
SQL Joins |
get_catalog |
Get the current schema/catalog of a database-related objects |
get_catalog.Microsoft SQL Server |
Get the current schema/catalog of a database-related objects |
get_connection |
Opens connection to the database |
get_connection.default |
Opens connection to the database |
get_connection.duckdb_driver |
Opens connection to the database |
get_connection.OdbcDriver |
Opens connection to the database |
get_connection.PqDriver |
Opens connection to the database |
get_connection.SQLiteDriver |
Opens connection to the database |
get_schema |
Get the current schema/catalog of a database-related objects |
get_schema.PqConnection |
Get the current schema/catalog of a database-related objects |
get_schema.SQLiteConnection |
Get the current schema/catalog of a database-related objects |
get_table |
Retrieves a named table from a given schema on the connection |
get_tables |
List the available tables on the connection |
id |
Convenience function for DBI::Id |
id.character |
Convenience function for DBI::Id |
id.data.frame |
Convenience function for DBI::Id |
id.Id |
Convenience function for DBI::Id |
inner_join.tbl_sql |
SQL Joins |
interlace |
Combine any number of tables, where each has their own time axis of validity |
interlace_sql |
Combine any number of tables, where each has their own time axis of validity |
is.historical |
Checks if table contains historical data |
joins |
SQL Joins |
left_join.tbl_sql |
SQL Joins |
lock_table |
Sets, queries and removes locks for database tables |
Logger |
Logger: Complete logging to console, file and database |
LoggerNull |
LoggerNull: The no-logging Logger |
nrow |
nrow() but also works on remote tables |
right_join.tbl_sql |
SQL Joins |
schema_exists |
Test if a schema exists in given connection |
semi_join.tbl_sql |
SQL Joins |
slice_time |
Slices a data object based on time / date |
table_exists |
Test if a table exists in database |
table_exists.DBIConnection |
Test if a table exists in database |
unique_table_name |
Create a name for a temporary table |
unite.tbl_dbi |
tidyr::unite for tbl_dbi |
unlock_table |
Sets, queries and removes locks for database tables |
update_snapshot |
Update a historical table |