9
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 ...
Get Streamlit for Data Science - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
