What is the best way to query external csv files located on DBFS Storage to inspect the data using SQL?
What is the best way to query external csv files located on DBFS Storage to inspect the data using SQL?
A . SELECT * FROM ‘dbfs:/location/csv_files/’ FORMAT = ‘CSV’
B. SELECT CSV. * from ‘dbfs:/location/csv_files/’
C. SELECT * FROM CSV. ‘dbfs:/location/csv_files/’
D. You can not query external files directly, us COPY INTO to load the data into a table first
E. SELECT * FROM ‘dbfs:/location/csv_files/’ USING CSV
Answer: C
Explanation:
Answer is, SELECT * FROM CSV. ‘dbfs:/location/csv_files/’
you can query external files stored on the storage using below syntax SELECT * FROM format.`/Location` format – CSV, JSON, PARQUET, TEXT
Latest Databricks Certified Professional Data Engineer Dumps Valid Version with 222 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments