From the course: Databricks Certified Data Engineer Associate Cert Prep
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Querying external data sources
From the course: Databricks Certified Data Engineer Associate Cert Prep
Querying external data sources
- [Instructor] How do you query against external data sources? Well, if we take a look at this catalog explorer here, and we go to add, there's a section here where we can obviously add external data. That's one option. We can also integrate with native integrations as well. So this is probably one of the easier ways to get started with querying external resources is you could put some items inside of blob storage and you could then integrate that directly into your upload. Now, another thing you could do as well is you could have things in different databases like Cassandra, Snowflake System, JDBC, Kafka, Elastic Search, MongoDB Postgres, MySQL, even the DBFS itself. And now you also can talk to other sources as well, and including Google Drive, you could look at Salesforce. So there's a lot of different ways that we can actually add things inside from external sources. One thing I'll also mention is that we can…
Contents
-
-
-
-
-
(Locked)
Efficient data transformation with Spark SQL5m 44s
-
(Locked)
Using Catalog Explorer4m 44s
-
(Locked)
Creating tables from files5m 12s
-
(Locked)
Querying external data sources2m 28s
-
(Locked)
Inspecting tables3m 26s
-
(Locked)
Reliable data pipelines with Delta Lake2m 6s
-
(Locked)
ACID transactions2m 5s
-
(Locked)
Z-ordering optimization2m 45s
-
(Locked)
-
-
-