Handling Teradata socket issues and login timeouts

importthepandas
importthepandas Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 115 Neuron

Hi Team

This isn't a Dataiku limitation or product issue question, more or less a question on "am i assuming correctly?"

We are experiencing some connectivity issues on our teradata servers which we're being told to triage by increasing login timeouts. Easy enough to do with ODBC driver parameters, in python using teradata's package, etc. but for JDBC there is no default parameter to adjust. I'm assuming in Dataiku this is a java based connection and is using DriverManager? Would it be accurate to also assume if I set DriverManager.setLoginTimeout in advanced properties for the connection I could adjust timeout settings?


Operating system used: Ubuntu 18.04


Operating system used: Ubuntu 18.04

Best Answer

Answers

  • importthepandas
    importthepandas Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 115 Neuron

    you are right @sergeyd
    - support for their JDBC driver seems to be behind ODBC. we've tried to set driver manager timeout in special properties... not sure if it's having any effect, but we're monitoring. Either way we'll be using another data warehouse technology soon where this is not a limitation. thank you!

Setup Info
    Tags
      Help me…