Cloudera Docs

Getting started in Cloudera Data Warehouse

In Cloudera Data Warehouse, you can deploy and administer cloud data warehousing. You can move workloads to the cloud securely and manage user access to warehouse data, or just parts of the data, through Apache Ranger fine-grained control. You learn how to get started in Cloudera Data Warehouse.

As Cloudera Data Warehouse administrator, you need privileges to access a Cloudera environment. As a Cloudera Data Warehouse user, you need privileges to access warehouse data as described in the subtopics, Prerequisites and Granting Cloudera users and groups access.

To get started, click Data Warehouse on the Cloudera home page. The Overview page is displayed:
If you have permission to access an environment, you can create a Virtual Warehouse:
  • A Hive Virtual Warehouse for Hive users
  • An Impala Virtual Warehouse for Impala users
  • A Trino Virtual Warehouse for Trino users
You provide users with the URL of your Virtual Warehouse, and they can access the data you authorize using tools you download from Resources and Downloads and provide to them from Resources and Downloads, you can install or download the following software or drivers:
  • DBT Hive and DBT Impala

    Adapters for using dbt with Hive or Impala.

  • CDP CLI

    Install a tool to help you manage your Service Manager-managed cluster instances. The CLI can be used for automating cluster creation and termination.

  • Hive JDBC Jar

    Download the Hive JDBC driver for clients to connect to a Virtual Warehouse.

  • Beeline CLI

    Download the Beeline CLI tarball for clients to install and connect to a Virtual Warehouse.

  • Workload Insights

    Download this software for getting recommendations for creating materialized views.

  • Impala JDBC/ODBC Driver

    Download the Impala JDBC/ODBC driver for clients to connect to an ImpalaVirtual Warehouse.

  • Hive JDBC/ODBC Driver

    Download the Hive JDBC/ODBC driver for clients to connect to a Hive Virtual Warehouse.

  • Impala UDF SDK

    Download the Impala User Defined Function (UDF) development package that you can use to build UDFs

  • Trino CLI

    Download the Trino command-line client that allows you to connect to Trino Virtual Warehouses and run queries.

  • Trino JDBC/ODBC Driver

    Download the Trino JDBC/ODBC driver for clients to connect to a Trino Virtual Warehouse.

Exiting Cloudera Data Warehouse

In the left navigation, click as shown in the following image:

Select Management Console to leave Cloudera Data Warehouse to manage environments, users, and Cloudera services, or select a different menu item.