Databricks · Databricks Data Engineer Associate
Lakeflow Connect, JDBC, ODBC, and REST
Databricks Data Engineer Associate · Lesson 6 of 22 · 31:57
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the Databricks Certified Data Engineer Associate exam. In this lesson: the parts of a Lakeflow Connect managed connector (connection, ingestion gateway, and ingestion pipeline), how a connector runs, JDBC and ODBC connections, and calling REST APIs from a notebook with secrets kept out of the code. Includes three original practice questions.
Preview the topics
- Hollowbrook connects its PostgreSQL inventory database with a managed connector. Which component captures the changes from the database, and lands them in staging storage?
- A notebook reads the store loyalty database through JDBC, and a reviewer finds the database password written in the JDBC URL. What should the engineer do?
- Every morning at 5 a.m., the forecasting team needs yesterday's weather from a partner's REST API, which has no connector in Lakeflow Connect. What is the usual approach?