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', '...
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 ...
