問題文
A marketing analyst receives a one-off list of 400 campaign codes as a small CSV file on their laptop. The list will not be updated again. The analyst wants to join it against a sales table in Databricks SQL this afternoon. Which approach fits the situation with the least machinery?
選択肢
- Paste the 400 codes into a long IN list inside the query so that no data ever has to be stored on the platform at all.
- Configure Auto Loader to watch the analyst's local laptop directory so the file is detected and ingested as soon as it is saved.
- Upload the file through the workspace interface, which lands it in a Unity Catalog volume and offers to create a table from it.
- Ask the data engineering team to publish the codes for that campaign as a share so the analyst can read them as a read-only catalog.