Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Use TD Console

Create a new connection

Go In Treasure Data, you must create and configure the data connection prior to running your query. As part of the data connection, you provide authentication to access the integration.

  1. Open TD Console.

  2. Navigate to Integrations Hub

...

  1. Catalog.

  2. Click the search icon on the far-right of the Catalog screen, and enter Apptopia.
  3. Hover over the Apptopia connector and select Create Authentication.
    Image Added
          The following dialog opens.
    Image Added

Edit your Apptopia client Client ID and secret information, select Continue, and give Secret Key information. Then click Continue. Give your connection a name:

Image Removed

Select Create Connection, and click Done.

Create a new transfer

When you select Create Connection, you are taken to the Authentications tab. Look for the connection you created and select New Transfer.

...

Code Block
linenumberstrue
$ td connector:issue load.yml --database td_sample_db --table td_sample_table --time-column updated_date --auto-create-table


You can assign Time Format column to the "Partitioning Key" by "--time-column" option.


Scheduled Execution

You can schedule periodic Data Connector execution for periodic Apptopia import. We configure our scheduler carefully to ensure high availability. By using this feature, you no longer need a cron daemon on your local data center.

...

Code Block
linenumberstrue
$ td connector:create \
    daily_apptopia_import \
    "10 0 * * *" \
    td_sample_db \
    td_sample_table \
    load.yml


The `cron` parameter also accepts the options: `@hourly`, `@daily` and `@monthly`.


By default, schedule is setup in UTC timezone. You can set the schedule in a timezone using -t or --timezone option. The `--timezone` option supports only extended timezone formats like 'Asia/Tokyo', 'America/Los_Angeles' etc. Timezone abbreviations like PST, CST are *not* supported and may lead to unexpected schedules.


List the Schedules

You can see the list of scheduled entries by td connector:list.

...

Code Block
linenumberstrue
in:
  ...
out:
  mode: replace

Available Targets

Target

Description

app_metadata

Application metadata

app_performance

Application performance

app_ranks

Application ranking

app_sdks_metadata

Application SDKs metadata

category

List of categories

category_rank_lists

Raw ranks top charts for each category

category_featured_lists

Featured applications for each category

category_new_releases

New app releases for each category

country

Supported countries

publisher_metadata

Publisher metadata

publisher_performance

Publisher performance

sdk_metadata

SDK metadata

Available Markets

Store

Description

itunes_connect

Apple Store

google_play

Google Play Market

Rate Limits

There is requests per minute rate limit in Apptopia. This rate limit is auto refreshed after a certain number of seconds.

...