Apple App Store#

Connect Apple App Store with issuer id, key id, private key, and vendor number. The source writes 1 fixed table under titan.apple_app_store.

select
  event_date,
  app_name,
  app_apple_id
from titan.apple_app_store.sales_subscriber_detailed
limit 10

Connect Apple App Store#

1. Open Apps, choose Connect app, and select Apple App Store.

2. Enter issuer id, key id, private key, and vendor number.

3. Review the tables, then save the source.

4. Watch Sync history until the first run completes.

Credentials are stored as secrets. They never become lake columns or appear in query results.

Sync behavior#

Supernova downloads detailed subscriber sales reports and keeps the report fields as typed columns.

A new source syncs when you connect it and then follows its schedule. The default recurring interval is 4 hours. An interrupted run keeps its completed progress and retries safely.

Every lake table also has the system columns _synced_at and _deleted; the column reference below lists source columns only.

Table reference#

sales_subscriber_detailed#

titan.apple_app_store.sales_subscriber_detailed has 26 source columns.

Deletes and history#

Rows are merged by their source key. When the source can prove that a row was deleted, Supernova keeps the row and sets _deleted so queries can choose whether to include history. Filter current-state queries with where not _deleted.