We’ve already looked at getting data into Databricks via files. A large amount of data will probably be pulled or pushed directly from and to the sources. This can easily be done using ODBC and JDBC.
In this chapter, we’ll look at how we set up these solutions on Windows and Mac. We’ll look at a few examples with commonly used tools on the market to see how it works.
We’ll then flip the table and use JDBC to pull data into Databricks from a few different database systems. In the end, you’ll have a good understanding of how you can ship data directly both to ...