I've created a foreign connection to an on prem sql server...CREATE CONNECTION IF NOT EXISTS `dagrbs-dr01` TYPE SQLSERVER OPTIONS ( host = secret('scope-kv-key-vault', 'ip-dagrbs-dr01'), port = '1433', user = secret('scope-kv-key-vault', '...
this has been resolved - once I changed the host to just the IP using just a script to create the catolog without testing the connection worked to create.the issue I had with selecting from it was resolved as we have our sql computes set to local dat...
really appreciate everyone's feedback on this - I took the approach of avoiding the test connection and using only the ip not the secret, whcih included the port. when i created the catalog using a basic script the catolog was created no problem and ...
