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 analyzing data, rather than managing it.

Table of Contents

Step 1: Sign Up

Sign up for Treasure Data if you haven’t yet.

Step 2: Query the Sample Table

Let’s query 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.

     SELECT
       code AS http_status_code,
       COUNT(1) AS num_requests
     FROM
       www_access
     GROUP BY
       code
     ORDER BY
       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 haven’t signed up already, get started for free here! If you already have an account with us, you will have a more detailed quickstart inside the Management Console.

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


If this article is incorrect or outdated, or omits critical information, please let us know. For all other issues, please see our support channels. Live chat with our staffs also work well.