Translate a named server to an IP address for the user

[alison985]

One thing I found while troubleshooting other things is that SERVER=company-sql-dev won't work but SERVER=1.1.1.1 will, when company-sql-dev is the named version of the server with the IP address 1.1.1.1.

I manually got the server IP address from running this query on the SQL Server itself. SELECT CONNECTIONPROPERTY('local_net_address') AS local_net_address

However, this StackOverflow Answer seems like it may be a way to auto-translate a named server variable in dbt YML into the server IP address to pass to the connection string auto-magically for the user. It would be especially nice because it would get the IP address without the user having to have an existing connection to the server to run the query(e.g. first time setup).

[joshmarkovic]

@alison985, is this something you still want? It's been open a while, so no worries if you've moved on.

I don't think the dbt adapter is the right layer for this. Hostname resolution is the job of the OS resolver and the ODBC/MS driver, and the adapter just passes server straight through to them. If we resolved the name to an IP ourselves (e.g. via socket.gethostbyname), we'd be duplicating and overriding that, which is DIFFICULT to debug.