Creates a table for the day in the db on the clipper_day schema and returns the name of it. Using in-database functions, returns card_id as a SHA_1 hash and time zone to PST.
1 2 | fares_for_day(partition_time = "10:00:00", start_date = "2016-01-01",
drop_existing_table = FALSE)
|
partition_time |
time to use as the start of a "day." defaults to 3 AM PST (10 AM UTC) |
start_date |
date this is the start date for the day (starting at 3 am at the partition time above). note that the day may "end" at 3 am the next day. |
drop_existing_table |
whether to drop an existing partitioned table for this date |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.