Quickstart Guide

Let’s get started with Treasure Data!

Treasure Data is the first cloud service for the entire data pipeline, including acquisition, storage, and analysis. We manage and support the entire infrastructure so you can focus on what you do best, analyzing data, rather than managing it.

Table of Contents

Overview & Concepts

If you want to get a short technical introduction to the Treasure Data Service, please take a look at our 8 minute introduction video:

Step 1: Sign In

Sign into your Treasure Data account. If you don’t have an account, please request a trial to get started.

Step 2: Import Your Data

Now it’s time to ingest your data. Please pick the one from below.

Step 3: Query the Table

Let’s query the sample table! Below is an example query for the sample table.

  1. Click on the “New Query” tab on the left vertical tab inside the Management Console.
  2. Select “sample_db” from the “Database” dropdown menu.
  3. Write a query of your choice against the table named “www_access”. Here is one example query that counts and sorts HTTP requests by their status codes.

       code AS http_status_code,
       COUNT(1) AS num_requests

    run your SQL query

  4. Hit the blue Submit button. You will be sent to the job page where you can track your job’s progress.

    Running a job on Treasure Data Serivce

  5. Once the job is done, the “running” sign (in blue) turns into “success” (in green). You can view the results within the Management Console as well as download it as CSV/TSV/JSON (see the red circle below).

    view and download your query results

What’s next?

If you don’t have an account, request free trial access here! If you already have an account with us, log on into the Console at console.treasuredata.com and click on ‘Help’ => ‘Tutorial’ in the top-right corner.

Also, if you prefer CLI to GUI, you can learn more about our command line tool here.

Last modified: Oct 26 2016 03:42:26 UTC

If this article is incorrect or outdated, or omits critical information, please let us know. For all other issues, please see our support channels.