How to modify keys of a dm from connection?

[asadow]

Adding a table is described at this page.

But the keys are added after copy_to(), meaning that the keys don't apply to the connection dm, only the locally defined.

[krlmlr]

Thanks, missed that. What section does your question refer to?

[asadow]

Closing as I can't easily reprex this:

> library(dm)
> library(dbplyr)
> 
> fin_dm <-
+   dm_financial() %>%
+   dm_select_tbl(-trans) %>%
+   collect()
Error in `financial_db_con()`:
! Can't connect to relational.fit.cvut.cz or databases.pacha.dev:
Failed to connect: Can't connect to server on 'relational.fit.cvut.cz' (138)
Failed to connect: Can't connect to server on 'databases.pacha.dev' (138)
Run `rlang::last_trace()` to see where the error occurred.

[krlmlr]

Do you need to upgrade the dm package to fix dm_financial() ?

Anyway, there are two possibilities: either information on foreign keys is stored on the database (in which case you can use dm_from_con() to "learn" a dm with that information), or not (and then you need to dm_add_pk() and dm_add_fk() after dm_from_con() ) .