#1804 feat: Query tagging for targets
Issue created by
qbatten
### Feature scope
Targets (data type handling, batching, SQL object generation, tests, etc.)
### Description
It'd be super useful for me if we could add query tags for targets; specifically I want to be able to add query tags to my snowflake target (I'm using transferwise/target-snowflake and it supports this).
Transferwise's snowflake target has this implemented. Could be a good place to start. They set it on the session params
here.
Very loosely speccing out what this could look like...
•
SQLAlchemy lets you add arbitrary connect_args and it looks like
sqlalchemy-snowflake (cmd-f "connect_args" on that page) does support arbitrary Snowflake session params.
• The SQLConnector would have to be the object handling this. It could check the config for e.g. a "connect_args" argument that it then passes
to the sqlalchemy engine.
• So, in summary, SQLConnector could check for connect_args in config, then pass those args to it's create_engine statement. For Snowflake this would look like the target having a nested config option: connect_args > query_tag.
meltano/sdk