Solutions Products Open Source Customers Resources

Using R and Python inside the Posit Team Native App in Snowflake

Connect to Snowflake data from R and Python in Posit Team, analyze it with dbplyr and pandas, and publish a Shiny app to Posit Connect, all within Snowflake.

rate limit

Code not recognized.

Course Objectives

  1. Access the Posit Team Native App in Snowflake and launch an IDE session
  2. Explain how Snowflake SSO inheritance removes the need to manage credentials in your code
  3. Connect to Snowflake data from R and Python and analyze it with dbplyr and pandas, pushing computation into Snowflake
  4. Publish a Shiny app over Snowflake data to Posit Connect with permissions enforced per viewer

Curriculum23 min

  • Setup
  • Accessing Posit Team as a data scientist
  • How authentication works in Posit Team on Snowflake
  • Access and Authentication
  • Using R and Python
  • Connecting to Snowflake in R and Python
  • Analyzing Snowflake data in R and Python
  • Connecting and Analyzing
  • Publishing to Posit Connect
  • Publishing to Posit Connect
  • Publishing
  • Next Steps
  • Course wrap-up
  • Wrap Up

Course Objectives

  1. Access the Posit Team Native App in Snowflake and launch an IDE session
  2. Explain how Snowflake SSO inheritance removes the need to manage credentials in your code
  3. Connect to Snowflake data from R and Python and analyze it with dbplyr and pandas, pushing computation into Snowflake
  4. Publish a Shiny app over Snowflake data to Posit Connect with permissions enforced per viewer

Curriculum23 min

  • Setup
  • Accessing Posit Team as a data scientist
  • How authentication works in Posit Team on Snowflake
  • Access and Authentication
  • Using R and Python
  • Connecting to Snowflake in R and Python
  • Analyzing Snowflake data in R and Python
  • Connecting and Analyzing
  • Publishing to Posit Connect
  • Publishing to Posit Connect
  • Publishing
  • Next Steps
  • Course wrap-up
  • Wrap Up