Add new loader extra `dialect` to use as default dbt `target` and Meltano UI SQL dialect instead of namespace
Part of untangling the mess described in #2208 (comment 388529270):
The inconsistent
namespace
s are an unfortunate consequence of the different roles thatnamespace
has come to play in Meltano over time, and the different directions they pull us in:
- loader
namespace
: SQL dialect to use in Meltano UI, requiringnamespace
to bepostgres
,snowflake
, orsqlite
- loader
namespace
: default value fordbt
'starget
setting, requiringnamespace
to be eitherpostgres
orsnowflake
, since those are the two targets that exist in https://gitlab.com/meltano/files-dbt/-/blob/master/bundle/transform/profile/profiles.yml
The loader dialect
extra of target-postgres
would be set to postgres
by default.
This will enable us to change the default value of the dbt target
setting from $MELTANO_LOADER_NAMESPACE
to $MELTANO_LOAD__DIALECT
.