Can I migrate data from Snowflake to On Prim SQL Server using DBT.
I want apply all my transformations on snowflake DB and once data is available in the final tables, I want the data to be migrated to SQL Server which is On Prem.
Any suggestions will be appreciated.
Best Regards, Preeti
have you seen projects like say … meltano or airbyte which deal with this sort of workflow? and Meltano includes DBT… DBT as I see it is just one step in your question… the transformation… but sourcing or moving of data … that is left up to things like apache airflow, airbyte, meltano, etc…