Forum Discussion

Timal's avatar
Timal
Icon for Helper I rankHelper I
1 year ago
Solved

Pyodbc Connect to Warehouse Endpoint timing out

Hello there,   So i've been using pyodbc as a workaround to write to Warehouse Tables using Notebooks for a while now. Here and there i've had issues where it would result in Timeout Messages simi...
data engineering
  • Timal's avatar
    Timal
    1 year ago

    Hey Anonymous ,

     

    Well, another classic example of tunnel vision due to missleading Error Messages on my end.

    After some configuration changes to the KeyVaults I noticed that the Secrets were outdated.

    Updated the Secrets... guess what... worked.

    Would've been nice if i got an error saying "invalid credentials" or something instead of "login timeout" but whatever.

     

    Issue is fixed and as always, was down to a basic configuration issue.

     

    TLDR: never trust the error message and always check your credentials first.

     

    Thanks anyway for the support!

     

    Regards,

    Tim

Anonymous's avatar
Anonymous
Not applicable
1 year ago

HI Timal,

As your said, If they are work on the same data region but one work the other not.
Have you enabled allow list on the azure service principal usage or any different setting on the internal network policy setting or firewalls between these scenarios?
Regards,

Xiaoxin Sheng

Timal's avatar
Timal
Icon for Helper I rankHelper I
1 year ago

Hey Anonymous ,

 

Well, another classic example of tunnel vision due to missleading Error Messages on my end.

After some configuration changes to the KeyVaults I noticed that the Secrets were outdated.

Updated the Secrets... guess what... worked.

Would've been nice if i got an error saying "invalid credentials" or something instead of "login timeout" but whatever.

 

Issue is fixed and as always, was down to a basic configuration issue.

 

TLDR: never trust the error message and always check your credentials first.

 

Thanks anyway for the support!

 

Regards,

Tim