Large-Sized Partners
Available in: both Salesforce Classic and Lightning Experience |
Available in: Enterprise, Performance, Unlimited, and Developer Editions |
Large partners frequently create one query per managed package per 12, 6, or 1-hour increments throughout a 24-hour period. How frequently you schedule your queries really depends on your data volume.
We recommend that you use a combination of queries and multiple catch-up queries for all data types
Data Type | How to Get Started | How to Schedule Catch-Up Queries |
---|---|---|
Subscriber Snapshots | One daily query per package. |
|
Package Usage Summaries | One daily query per package. |
|
Package Usage Logs |
|
Create two levels of catch-up queries per day.
|
Example
Your customers use your package on all Salesforce instances around the world, and your managed packages produce significant amounts of data. You schedule queries to run at the same time, each covering a 12-hour period, and you create a layered catch-up query plan to capture data from all instances.
In this example, we show two of your dozens of managed packages.
- On March 31 at 18:00 UTC, run your regular package
usage log queries.
Package 1
sf data create record data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-30T00:00:00 EndTime=2021-03-30T12:00:00 DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=parquet FileCompression=snappy"
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-30T12:00:00 EndTime=2021-03-31T00:00:00 DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=parquet FileCompression=snappy"
Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-30T00:00:00 EndTime=2021-03-30T12:00:00 DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=parquet FileCompression=snappy"
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-30T12:00:00 EndTime=2021-03-31T00:00:00 DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=parquet FileCompression=snappy"
- On April 1 at 18:00 UTC, run your regular and catch-up
package usage log queries.
A. Package Usage Log Regular Queries
Package 1
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-31T00:00:00Z EndTime=2021-03-31T12:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=parquet FileCompression=snappy"
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-31T12:00:00Z EndTime=2021-04-01T00:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=parquet FileCompression=snappy"
Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-31T00:00:00Z EndTime=2021-03-31T12:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=parquet FileCompression=snappy"
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-31T12:00:00Z EndTime=2021-04-01T00:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=parquet FileCompression=snappy"
B. Package Usage Log 2 Days Ago Catch-Up Queries
Package 1
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-30T00:00:00Z EndTime=2021-03-31T00:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=parquet FileCompression=snappy AvailableSince=2020-03-31T18:00:00Z"
Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-30T00:00:00Z EndTime=2021-03-31T00:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=parquet FileCompression=snappy AvailableSince=2020-03-31T18:00:00Z"
C. Package Usage Log From 3 to 30 Days Ago Catch-Up Queries
Package 1
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-01T00:00:00Z EndTime=2021-03-30T00:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=parquet FileCompression=snappy AvailableSince=2020-03-31T18:00:00Z"
Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-01T00:00:00Z EndTime=2021-03-30T00:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=parquet FileCompression=snappy AvailableSince=2020-03-31T18:00:00Z"
- On April 2 onwards, run your regular and your catch-up package usage log queries, advancing
the dates by 1 day.
A. Package Usage Log Regular Queries
Package 1
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-04-01T00:00:00Z EndTime=2021-04-01T12:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=parquet FileCompression=snappy"
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-04-01T12:00:00Z EndTime=2021-04-02T00:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=parquet FileCompression=snappy"
Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-04-01T00:00:00Z EndTime=2021-04-01T12:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=parquet FileCompression=snappy"
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-04-01T12:00:00Z EndTime=2021-04-02T00:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=parquet FileCompression=snappy"
B. Package Usage Log 2 Days Ago Catch-Up Queries
Package 1
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-31T00:00:00Z EndTime=2021-04-01T00:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=parquet FileCompression=snappy AvailableSince=2020-04-01T18:00:00Z”
Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-31T00:00:00Z EndTime=2021-04-01T00:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=parquet FileCompression=snappy AvailableSince=2020-04-01T18:00:00Z"
C. Package Usage Log From 3 to 30 Days Ago Catch-Up Queries
Package 1
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-02T00:00:00Z EndTime=2021-03-31T00:00:00Z DataType=PackageUsageLog PackageIds=0336XXXXXXXXXX FileType=parquet FileCompression=snappy AvailableSince=2020-04-01T18:00:00Z"
Package 2
sf data create record --sobjecttype AppAnalyticsQueryRequest --values "StartTime=2021-03-02T00:00:00Z EndTime=2021-03-31T00:00:00Z DataType=PackageUsageLog PackageIds=0337XXXXXXXXXX FileType=parquet FileCompression=snappy AvailableSince=2020-04-01T18:00:00Z"