this was helpful thank you

@weecology

6 ай бұрын

You're welcome!

These videos are just amazing.

@weecology

Жыл бұрын

Thanks!

Haha you included a blooper. Nice.

@weecology

2 жыл бұрын

Yeah, I mess up a lot there are bloopers at the end of many of my videos :)

Is there a way to type the %>% pipe notation fast or are you copying and pasting. Thanks!

@weecology

3 жыл бұрын

Yes, there's a keyboard shortcut! It is Ctrl+Shift+M on PC/Linux and Cmd+Shift+M on Mac. You can find more useful RStudio shortcuts here support.rstudio.com/hc/en-us/articles/200711853-Keyboard-Shortcuts

How do you create a linked version of the table in R if the table is stored in a schema?

@weecology

Жыл бұрын

I don't think I fully understand the question, so feel free to provide additional clarification. In general tables can be in one of two states: 1) in the database, with R looking at it in the database; or 2) as a copy made in R. Unless you've run `collect()` the data should still be in the database. If you've made a copy in R then you need to move it to the database when you're done in order to store it there. I'm not sure if this answers your question, so if it doesn't try to clarify and I'll try to provide a better answer.

@Dominus_Ryder

Жыл бұрын

@@weecology Thanks for taking the time to get back to me…so in the database at my job (Postgress), the tables are stored in Schema. Therefore, my connection object is in able to point to the tables, it some how needs to point to the schema inside of the database 1st, and then to the tables inside of the schema.

@weecology

Жыл бұрын

@@Dominus_Ryder Thanks for clarifying. "schema" can mean a couple of different things so noting that this was Postgres helped me understand. I don''t have a postgres instance handy to test, but this is what I'd try first: stackoverflow.com/a/49110504/133513. Let me know if that doesn't work.