Connecting to Databases

In the previous chapters we focused entirely on data stored in individual files, but most of the real-world, work-based applications center around data stored in databases. Companies tend to store their data in the cloud, and therefore, being able to perform analyses on this data is a critical skill. In this chapter, we will explore how to access and use data stored in popular databases such as Snowflake and BigQuery. For each database, we’ll connect to the database, write SQL queries, and then make an example app.

Whether you are looking to perform ad hoc analysis on large datasets or build data-driven applications, the ability to efficiently retrieve and manipulate data from databases is essential. By the end of this chapter, you will have a strong understanding of how to use Streamlit to connect to and interact with databases, empowering you to extract insights and make data-driven decisions with confidence.

In this chapter, we will cover...