QuestionQ59

Verified

You work for an e-commerce company, and a vendor supplies its inventory data through CSV file uploads to an S3 bucket.

How do you prepare the data for dbt transformations? Choose 1 option.

Explanation

Declaring the external table as a dbt source makes the vendor’s S3-based inventory data available to models through source(), with lineage and source testing. The external property can describe the file location and other platform-specific settings. The external table must also be created or refreshed in the data platform; the dbt-external-tables package provides macros for that purpose. (docs.getdbt.com)

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!