spod_duckdb_filter_by_dates {spanishoddata} | R Documentation |
Filter a duckdb conenction by dates
Description
IMPORTANT: This function assumes that the table or view that is being filtered has separate year
, month
and day
columns with integer values. This is done so that the filtering is faster on CSV files that are stored in a folder structure with hive-style /year=2020/month=2/day=14/
.
Usage
spod_duckdb_filter_by_dates(con, source_view_name, new_view_name, dates)
Arguments
con |
A duckdb connection |
source_view_name |
The name of the source duckdb "view" (the virtual table, in the context of current package likely connected to a folder of CSV files) |
new_view_name |
The name of the new duckdb "view" (the virtual table, in the context of current package likely connected to a folder of CSV files). |
dates |
A The possible values can be any of the following:
|
Value
A duckdb
connection with original views and a new filtered view.