Noah Sanor06/21/2021, 7:42 PM
resource that can work locally or on higher environements. However, dbt currently does not support running the rpc server on Windows (which unfortunately my team uses). The other approach is to run the cli commands locally and rpc commands on dev/prod/etc. Is there a defined pattern for doing this now? Please let me know if this question should be asked elsewhere.
owen06/21/2021, 9:43 PM
Noah Sanor06/21/2021, 10:16 PM
Todd Hendricks12/22/2021, 7:16 PM
owen12/22/2021, 7:25 PM
Todd Hendricks12/22/2021, 7:29 PM
owen12/22/2021, 7:50 PM
), but they don't actually retrieve the data from wherever dbt is transforming it. In the case of the
, it ensures the dbt command gets executed by issuing a CLI command on the local machine, and in the case of the
it ensures that the dbt command gets executed by sending an http request to the remote dbt RPC server.
SELECT * FROM ...
Todd Hendricks12/22/2021, 7:54 PM
owen12/22/2021, 7:54 PM