dbplyr
creates temporary tables when copy = TRUE is coded when joining tables together with inner_join
or similar dplyr
functions using a local tibble as the "right" table. A message like this is shown in the console:
Created a temporary table named: ##dbplyr_007
How can I control what these temporary table names are? When running multiple sessions processing different data I see error messages that a particular temporary table already exists. I don't think I would have that problem if I could make sure the tables have different names in the different sessions. A high-precision time stamp as part of the temporary name would help.