A BI developer wants to connect a third-party SQL client (DBeaver) to watsonx.data. What is the recommended approach?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Standard SQL clients like DBeaver; SQuirreL SQL; and others connect to watsonx.data's Presto engine using the Presto JDBC driver configured with the engine hostname; HTTPS port (typically 443); and user credentials.
Full explanation below image
Full Explanation
Standard SQL clients like DBeaver; SQuirreL SQL; and others connect to watsonx.data's Presto engine using the Presto JDBC driver configured with the engine hostname; HTTPS port (typically 443); and user credentials. The incorrect options ("Export query results to Excel and open them in the SQL client", "Install a watsonx.data plugin directly inside DBeaver from the IBM plugin marketplace", "Connect using the Apache Kafka consumer client with a Presto AVRO deserializer") are distractors that don't fully capture the concept described.