Quickstart Guide

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 and using data results to move your business forward.

Table of Contents

What You Can Do in this Quickstart

You can import some of your data into Treasure Data and then explore the Treasure Data features, such as building queries. To do this, you must know the mechanism that you want to use to import your data.

Alternatively, you can explore Treasure Data by accessing a sample database and table that we provide.

Step 1: Sign In

Sign into your Treasure Data account.

Step 2: Import Your Data

To bring your data into Treasure Data, select one of the many mechanisms such as listed here. Tip: if you want to experiment with a simple .csv file, you can select, Web Browser File Upload.

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.

     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. Click the Submit button. You will see the job page where you can track your job’s progress.

    Running a job on Treasure Data Serivce

  5. When the job is done, the status changes from “running” (in blue text) to “success” (in green text). You can view the results within the Management Console, or alternatively, download the results as CSV/TSV/JSON (refer to the text circle in red).

    view and download your query results

What’s next?

You can access Treasure Data using the Console at console.treasuredata.com or, if you prefer, by using the command line interface (CLI). You can learn more about our command line tool here.


Last modified: Apr 05 2018 15:14:17 UTC

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