Site index¶

About sandboxes¶

Sync data: About Amperity Bridge Databricks
Pull data: Any SFTP site Acxiom Adobe Analytics Adobe Campaign Adobe Commerce Adobe Customer Attributes Amazon Kinesis Data Firehose Amazon S3 Attentive Mobile Azure Blob Storage BazaarVoice Bluecore Braze Camelot SMM Cheetah Digital Cordial Cross Country Computer Dynamic Yield Emarsys Epsilon Abacus Epsilon Conversant Epsilon Targeting Experian Google Analytics Google Cloud Storage Heap HubSpot Infutor Koupon Media Klaviyo Kustomer Listrak Microsoft Dataverse Monetate Neustar Optimizely Oracle Data Cloud Oracle Opera Oracle Responsys PowerReviews PebblePost Quad RR Donnelly Sailthru Salesforce Commerce Cloud Salesforce Marketing Cloud Salesforce Pardot Salesforce Sales Cloud SFTP (in Amperity) Shopify SMG Snowflake (on Amazon AWS) Snowflake (on Microsoft Azure) SoundCommerce Square Vibes Zendesk

Reshape data on ingest: About ingest queries About Spark SQL About load operations for ingest queries Add ingest query Add load operation
Example ingest queries: Build birthdate Concatenate columns Explode transactions Find records Flatten with identifiers Import billing as address JOIN datasets Load XML data Parse nested records Remove field Select all fields

Configure feeds: Set the primary key Apply semantic tags Select last updated field Make available to Stitch
Customer profiles: About customer profiles Address groups Email addresses Loyalty programs Names Phone numbers
Customer interactions: About customer interactions Apply to feeds or use domain SQL? Associate to Amperity IDs
Keys: About keys Blocking keys (bk) Customer keys (ck) Foreign keys (fk) Primary keys (pk) Separation keys (sk)
Product catalogs: About product catalogs Define product catalogs

Review domain data: Review domain data Amperity-added columns Column types Record types
Reshape domain data: Reshape domain data About domain SQL Build birthdates Combine postal codes Extract names Hash profile data Parse multiple separators Set non-USA email to NULL Standardize phone numbers Standardize USA states

Define blocklists: Blocklist bad-values Apply Stitch labels Manage nicknames
Configure Stitch: Select stitched tables One-to-one Stitch Stitch reports Clustering and fine-tuning Blocking strategy Case-sensitive foreign keys Matching strategy Matching thresholds Performance Allowed empty tables Days of recorded history Stitch processing Force Stitch to run Ignore jitter alerts Skip unified changes Skip unified scores Stable IDs Advanced settings Automatic bad value detection Clustering algorithm Pre-processing profiles Pre-processing profiles Australian phone numbers Clean foreign keys Email addresses Multiple preprocessing profiles Normalize gender Supersized clusters Trivial duplicates Semantic exclusions

Table types: Standard tables Source and custom tables QA tables
Manage databases: About databases Add empty database Add database from template Customer 360 template Passthrough template Stitch QA template Use multiple databases Apply flexible merge rules
Manage tables: About tables Add as passthrough Add as SQL Add from table template
Standard table templates: Customer 360 Customer Attributes Email Engagement Attributes Email Opt Status Merged Customers SMS Opt Status Transaction Attributes Unified Coalesced Unified Customer Unified Itemized Transactions Unified Scores Unified Transactions
Validation alerts: About validation alerts Implicit CROSS JOIN OVER without PARTITION BY Unescaped backslashes Unintentional broadcast joins
Query historical data: About querying historical data Available versions Return versions by datetime Return versions by creation date View all versioned tables
Extend databases: Add a graph database Add a PII table Add householding Calculate nearest store Predict gender Support CCPA and GDPR workflows Use first-party data Use third-party data

Courier groups: About courier groups Duration thresholds Missing files
Orchestration groups: About orchestration groups Run after courier group Run on a schedule