Databricks · Databricks Data Analyst Associate
Importing data
Databricks Data Analyst Associate · Lesson 5 of 18 · 27:44
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 Analyst Associate exam. In this lesson: choosing a route (managed connectors of Lakeflow Connect first), files in S3 with an external location, read_files, COPY INTO, and Auto Loader, OpenSharing (formerly Delta Sharing) and the Marketplace, data from APIs and Zerobus Ingest, and the upload page. Includes three original practice questions.
Preview the topics
- Cobbleway wants its Salesforce accounts and opportunities copied into Delta tables every hour, with as little code to maintain as possible. A managed connector exists. What should the team choose?
- A bike parts supplier also runs Databricks, and wants Cobbleway to see its live price catalog, with no copy and no files to send. Which approach fits?
- Finance emails a 40 MB CSV file of store targets, and the analyst needs it as a table in the sales schema today, to join with the orders. What is the quickest route?