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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access