Support Required: Connecting to Cloudera from Mac CLI

Venkat_T — Tue, 21 Apr 2026 06:17:19 GMT

Hi Team,

Could you please provide detailed steps on how to connect to my Cloudera trial account from the command line on a Mac?

The host address is: coordinator-jwemca0ltng5.dw-jwemca0ltng5.t7gcn3.cloudera.site

Thank you, Venkat

Re: Support Required: Connecting to Cloudera from Mac CLI

upadhyayk04 — Wed, 03 Sep 2025 13:01:55 GMT

Thank you for reaching to Cloudera community

Could you please elaborate on your query please? What exact steps are you following? A document you are referring?

We will need your inputs to further help you

Venkat_T — Wed, 03 Sep 2025 13:09:34 GMT

Context:

I have access to CDP Data Warehouse and can log in to the Hue console via browser using SSO (Single Sign-On).
I want to connect to Impala using the impala-shell CLI tool or JDBC driver for querying data.
I attempted to ingest data using Python through the Cloudera AI console by creating a new project, but I am still encountering the same access permission issues.

What I Have Tried:

Successfully listed clusters and warehouses using cdp dw CLI commands.
Retrieved the Impala JDBC connection string and endpoint details.
Tried to start the virtual warehouse using CLI but faced permission denied (403) errors.
Attempted to connect via impala-shell CLI with LDAP username and password, but received HTTP 401 Unauthorized errors.
Verified that no LDAP password is available as login is via SSO.
Tried to pass password in command line and interactively; none worked.
Noted that impala-shell does not support browser-based SSO authentication.
Attempted to add users to virtual warehouse using cdp dw add-user but faced permission denied errors.
Confirmed that SSO login works fine in Hue and CDP Console but CLI access is blocked due to lack of proper credentials.

Issue:

CLI tools like impala-shell and cdp dw commands require LDAP credentials or a different authentication method.
SSO-based authentication used in the environment is not supported by CLI tools by default.
This prevents me from running queries or managing the Data Warehouse via CLI.

Thank You,
Venkat