The problem I’m having
If I create external tables in snowflake via snowsight, can I access the external tables using dbt source object just like how dbt source pulls data from any table/view.
The context of why I’m trying to do this
I am asking this question because I am doing a POC where we have a legacy project already having Stage tables pointing data from parquet files hosted on ADLS.
I have to run certain transformations on the stage tables, can I access them via dbt source without the use of package dbt_external_tables
Also, I could’ve tried this before asking but I am not having access to those stage tables at the moment.