> ## 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.

# Treasure Data Connector

## Intro

Treasure Data is a cloud data management platform that lets users in your organization connect and access live data. To learn more about the Treasure Data API, visit their page ([https://docs.treasuredata.com/display/public/PD/Getting+Your+API+Keys](https://docs.treasuredata.com/display/public/PD/Getting+Your+API+Keys)).

You connect to your Treasure Data account in the Data Center. This topic discusses the fields and menus that are specific to the Treasure Data 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 "Adding a DataSet Using a Data Connector").

This connector can retrieve data from standard DataSets within Treasure Data by submitting jobs to Treasure Data and then importing the results. In some cases, you may actually be using Treasure Data's more advanced DataTank service. To connect to Treasure Data's DataTank, please use Domo's [PostgreSQL](/s/article/360043436273 "PostgreSQL Connector") database connector. To configure it, you will need to contact Treasure Data to get the necessary information, including the IP address and port of the DataTank server as well as login credentials.

For assistance, please contact Treasure Data.

## Prerequisites

To connect to your Treasure Data account and create a DataSet, you must have a Treasure Data API key. For information about obtaining an API key, visit the following page:

[https://support.treasuredata.com/hc/en-us/articles/360000763288-Get-API-Keys](https://support.treasuredata.com/hc/en-us/articles/360000763288-Get-API-Keys)

## Connecting to Your Treasure Data Account

This section enumerates the options in the **Credentials** and **Details** panes in the Treasure Data 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 your Treasure Data account. 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"> API Key </td><td colspan="1" rowspan="1"> Enter your Treasure Data API key. </td></tr><tr><td colspan="1" rowspan="1"> Domain name </td><td colspan="1" rowspan="1"><p> Here is the list of domains: </p><ul><li><a href="http://treasuredata.com" rel="noopener" target="_blank"> treasuredata.com </a></li><li><a href="http://treasuredata.co.jp" rel="noopener" target="_blank"> treasuredata.co.jp </a></li><li><a href="http://ybi.idcfcloud.net" rel="noopener" target="_blank"> ybi.idcfcloud.net </a></li></ul></td></tr></tbody></table>

Once you have entered valid Treasure Data credentials, you can use the same account any time you go to create a new Treasure Data 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 which may or may not appear depending on the report type you select.

<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 Treasure Data report you want to run. The following reports are available: </p><table border="1" cellpadding="1" cellspacing="1"><tbody><tr><td colspan="1" rowspan="1"> Execute Job </td><td colspan="1" rowspan="1"> Retrieves a job based on a provided database name, SQL query, and job type. This report may take a long time to run if the result set is large. </td></tr><tr><td colspan="1" rowspan="1"> Job Details </td><td colspan="1" rowspan="1"> Retrieves details about a given job or all jobs. </td></tr><tr><td colspan="1" rowspan="1"> Job Results </td><td colspan="1" rowspan="1"> Retrieves the results of a specific job submitted in the past. </td></tr><tr><td colspan="1" rowspan="1"> Job Status </td><td colspan="1" rowspan="1"> Retrieves the status for a given job or all jobs. </td></tr><tr><td colspan="1" rowspan="1"> List Databases </td><td colspan="1" rowspan="1"> Retrieves a list of all databases in your account. </td></tr><tr><td colspan="1" rowspan="1"> List Jobs </td><td colspan="1" rowspan="1"> Retrieves a list of all jobs in your account. </td></tr><tr><td colspan="1" rowspan="1"> List Tables </td><td colspan="1" rowspan="1"> Retrieves a list of all tables in your account. </td></tr></tbody></table></td></tr><tr><td colspan="1" rowspan="1"> Database </td><td colspan="1" rowspan="1"> Select the database containing the job you want to retrieve. </td></tr><tr><td colspan="1" rowspan="1"> SQL Query </td><td colspan="1" rowspan="1"> Enter the SQL query for the job you want to retrieve. </td></tr><tr><td colspan="1" rowspan="1"> Job Type </td><td colspan="1" rowspan="1"> Select the job type for the job you want to retrieve. </td></tr><tr><td colspan="1" rowspan="1"> Job ID </td><td colspan="1" rowspan="1"> Enter the ID of the job you want to pull data for. </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 "Adding a DataSet Using a Data Connector").

### FAQ

<AccordionGroup>
  <Accordion title="What kind of credentials do I need to power up this connector?">
    You need the domain and API key associated with your Treasure Data account.
  </Accordion>

  <Accordion title="Where can I find my API key?">
    Visit [Get API Keys](https://docs.treasuredata.com/articles/get-apikey) to learn how to obtain the API key.
  </Accordion>

  <Accordion title="What are the available domains?">
    Here is the list of domains:

    * [api.treasuredata.com](http://api.treasuredata.com)
    * [api.treasuredata.co.jp](http://api.treasuredata.co.jp)
    * [api.ybi.idcfcloud.net](http://api.ybi.idcfcloud.net)
  </Accordion>

  <Accordion title="How often can the data be updated?">
    Datasets should be set to update no more than once every 15 minutes.
  </Accordion>

  <Accordion title="Are there any API limits that I need to be aware of?">
    No
  </Accordion>
</AccordionGroup>
