DBT unit test is an excellent feature added in 2024, however if you are using a remote warehouse, you might for latency and cost reasons prefer using a different adapter. How about non ANSI SQL? This plugin helps you generate the macros that you need to make your sql portable