![]() I believe Redshift/Spectrum is unique in its support of create external table. Thanks for opening my view, there's a crucial distinction here between "read-only" and "write-read" external tables-sources and sinks, if you will. Are you interested in contributing this feature? AWS Glue / Athena) to query the results using existing analytical patterns. They can use dbt and the warehouse as an ephemeral compute / transform layer, and then persist the data to a file store, which enables other tools (e.g. Additional contextīelieve this is relevant for any of the databases currently supported in the external tables package:ĭbt Users who have existing infrastructure that leverages a more data lake centric approach for managing persistence will benefit from this. The goal here is to make that logic a materialization so that it can become part of the dbt run pipeline. The implementation of create_external_table here accomplishes this when triggered by a run-operation.
0 Comments
Leave a Reply. |