> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Qubole Unload Connector

## Intro

Qubole simplifies the provisioning, management and scaling of big data analytics workloads leveraging data stored on Amazon Web Services, Google Compute, or Microsoft Azure infrastructure. Use Domo's Qubole Unload connector to import Qubole reports based on a specified query or script location. To learn more about the Qubole API, visit their page ([https://docs.qubole.com/en/latest/rest-api/](https://docs.qubole.com/en/latest/rest-api/ "https://docs.qubole.com/en/latest/rest-api/") ).

You connect to your Qubole account in the Data Center. This topic discusses the fields and menus that are specific to the Qubole connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in [Adding a DataSet Using a Data Connector](/s/article/360042926274).

## Prerequisites

To connect to your Qubole account and create a DataSet, you must have the following:

* A Qubole API token
* Your Qubole account domain
* The Amazon Resource Name (ARN) of the role you want to assume
* The identifier for your Role Session Name
* The unique identifier used by 3rd parties when assuming roles in their customers' accounts
* The name of the Amazon S3 bucket you want to pull data from
* The Amazon S3 region containing the bucket you want to pull data from

### Obtaining an API Token

To obtain a Qubole API token, do the following:

1. Navigate to the Qubole Control Panel by gong to [https://api.qubole.com/v2/control-panel](https://api.qubole.com/v2/control-panel "https://api.qubole.com/v2/control-panel").
2. Click **My Accounts** in the left pane.
3. Click **Show** for the account.
4. Copy the API token that displays.

## Connecting to Your Qubole Account

This section enumerates the options in the **Credentials** and **Details** panes in the Qubole Unload Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet**, are universal across most connector types and are discussed in greater length in [Adding a DataSet Using a Data Connector](/s/article/360042926274 "Adding a DataSet Using a Data Connector").

### Credentials Pane

This pane contains fields for entering credentials to connect to Qubole so you can bring in data. The following table describes what is needed for each field:

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p><span class="s1"> Field </span></p></th><th colspan="1" rowspan="1"><p><span class="s1"> Description </span></p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> API Token </p></td><td colspan="1" rowspan="1"><p> Enter your Qubole API token. For information about generating a token, see "Obtaining an API Token," above. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Domain </p></td><td colspan="1" rowspan="1"><p> Enter the domain for your Qubole account. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Role ARN </p></td><td colspan="1" rowspan="1"><p> Enter the Amazon Resource Name (ARN) of the role you want to assume. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Role Session Name </p></td><td colspan="1" rowspan="1"><p> Enter the identier for the assumed role session. </p></td></tr><tr><td colspan="1" rowspan="1"><p> External ID </p></td><td colspan="1" rowspan="1"><p> Enter the unique identifier used by 3rd parties when assuming roles in their customers' accounts. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Bucket </p></td><td colspan="1" rowspan="1"><p> Enter your Amazon S3 bucket name. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Region </p></td><td colspan="1" rowspan="1"><p> Select the desired Amazon S3 region. </p></td></tr></tbody></table>

Once you have entered valid Qubole credentials, you can use the same account any time you go to create a new Qubole DataSet. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Managing User Accounts for Connectors](/s/article/360042926054 "Managing User Accounts for Connectors").

### Details Pane

This pane contains a primary **Reports** menu, along with various other menus for configuring your report.

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:195;a"><thead><tr><th colspan="1" rowspan="1"><p> Menu </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> Report </p></td><td colspan="1" rowspan="1"><p> Select the Qubole report you want to run. Currently only one report is available. </p><table border="1" cellpadding="1" cellspacing="1"><tbody><tr><td colspan="1" rowspan="1"><p> Command </p></td><td colspan="1" rowspan="1"><p> Lets you import a Qubole report by inputting a query or script location. </p></td></tr></tbody></table></td></tr><tr><td colspan="1" rowspan="1"><p> Query </p></td><td colspan="1" rowspan="1"><p> Enter the query you want to use to retrieve your report. Alternatively, you can enter a <span class="mt-font-courier-new"> script\_location </span>. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Script Location (Optional) </p></td><td colspan="1" rowspan="1"><p> Specify the S3 path where the hive query to run is stored. Either a query or script location is required. AWS storage credentials stored in the account are used to retrieve the script file. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Command Type </p></td><td colspan="1" rowspan="1"><p> Select the command type, either <b> Hive Command </b> or <b> Presto Command </b>. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Label (Optional) </p></td><td colspan="1" rowspan="1"><p> Specify the cluster label on which the report is to be run. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Delimiter </p></td><td colspan="1" rowspan="1"><p> Select the delimiting character used in your file. If your delimiter is not listed, select <b> Other </b>. </p></td></tr><tr><td colspan="1" rowspan="1"><p> Specify Your Delimiter </p></td><td colspan="1" rowspan="1"><p> Enter the character used to delimit your character-separated values. </p></td></tr></tbody></table>

### Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Data Connector](/s/article/360042926274).

## FAQs

<AccordionGroup>
  <Accordion title="How often can the data be updated?">
    As often as needed.
  </Accordion>

  <Accordion title="Are there any API limits I should be aware of?">
    Qubole may limit API calls. To prevent rate limiting, reduce the number of DataSets scheduled to run at the same time.
  </Accordion>
</AccordionGroup>
