Reference
About Amperity Bridge¶
Amperity Bridge allows users to connect Amperity with data warehouses using industry-standard data formats. Access shared tables in Databricks, Google BigQuery, or Snowflake without copying data.
Advantages of Amperity Bridge include:
Fast setup Connect Amperity to a data lakehouse in minutes using sharing keys instead of integrations.
Zero copy Control access to shared tables without replicating data across platforms. Build pipelines faster and consolidate your brand’s storage costs into a single location.
Scalable processing Enrich massive volumes of data. Data is not moved or transformed from where it resides. Model customer data directly in the data lakehouse or model it in Amperity.
Live data View customer data at rest in a data lakehouse or in Amperity through a shared catalog. Explore and query data without waiting for refreshes or updates.
Amperity Learning Lab
Amperity Bridge enables data sharing between Amperity and data lakehouses. Each bridge can be configured for inbound and outbound shares to give you access to shared tables without replication.
Start with an overview of data warehouses, compare Databricks and Snowflake, and then learn how Amperity Bridge shares data between Amperity and Databricks.
Open Learning Lab to learn more about how Amperity Bridge works. Registration is required.
Connect with¶
Configure Amperity Bridge to connect with the following cloud data warehouses:
Amperity Bridge for Databricks¶
Configure inbound and outbound shares in Amperity to enable bi-directional connections of data tables between Amperity and Databricks.
About Delta Sharing
Delta Sharing is an open protocol for secure sharing of live data between organizations. Delta Sharing generates temporary credentials that allow access to individual data files in cloud storage without copying data to another system regardless of computing platform.
Amperity Bridge for Google BigQuery¶
Configure inbound and outbound shares in Amperity to enable inbound and outbound connections of data tables between Amperity and Google BigQuery.
Amperity Bridge for Snowflake¶
Amperity Bridge for Snowflake is a first-class integration that leverages secure data sharing to enable bi-directional data access between Amperity and Snowflake without copying data or scheduling ETL workloads.
What is Secure Data Sharing?
Secure Data Sharing enables data sharing between Snowflake accounts without copying or transferring data and instead relies on the services layer and metadata store within Snowflake. Your brand controls what data will be made available to Amperity directly from within your brand’s Snowflake account.
How-tos¶
Individual tasks that are related to managing a bridge:
Add inbound bridge¶
The steps for adding an inbound bridge depend on the location from which data will be connected to Amperity:
Add outbound bridge¶
The steps for adding an outbound bridge depend on the location to which data will be conencted:
Add a bridge to a scheduled workflow¶
Any inbound share that has been configured and activated in your tenant may be added as a bridge within a courier group.
To add a bridge to a scheduled workflow
From the Sources page, open the menu for a courier group, and then select Edit.
On the Bridges tab, click the Add bridge link, and then select a bridge from the dropdown list.
Click Save.
Delete a bridge¶
You may delete any unused bridge.
To delete a bridge
Open the Sources or Destinations page.
Do one of the following:
For an inbound share, from the Sources page, under Inbound share, select a bridge, and then from the ellipses menu, click Delete.
For an outbound share, from the Destinations page, under Outbound share, select a bridge, and then from the ellipses menu, click Delete.
Download credentials¶
To connect Amperity with a data warehouse you may need to configure credentials for Amperity within the data warehouse. You can download these credentials from the Amperity user interface.
To download credentials for a bridge
Open the Destinations page.
From the Destinations page, under Outbound share, select a bridge, and then from the ellipses menu, click Download credentials.
Rename a bridge¶
You can rename a bridge.
To rename a bridge
Open the Sources or Destinations page.
Do one of the following:
For an inbound share, from the Sources page, under Inbound share, select a bridge, and then from the ellipses menu, click Rename.
For an outbound share, from the Destinations page, under Outbound share, select a bridge, and then from the ellipses menu, click Rename.
Sync a bridge¶
A sync that is not configured to run as part of a scheduled workflow may be synced manually.
Important
If an upstream data type changes, edit the bridge in Amperity, accept the changes, and then save and sync the bridge.
To sync a bridge
Open the Sources or Destinations page.
Do one of the following:
For an inbound share, from the Sources page, under Inbound share, select a bridge, and then from the ellipses menu, click Sync.
For an outbound share, from the Destinations page, under Outbound share, select a bridge, and then from the ellipses menu, click Sync.
Upload credentials¶
To sync data to Amperity from a data warehouse you may need to configure credentials for the data warehouse within Amperity. You can upload these credentials directly from the Amperity user interface.
To upload credentials for a bridge
Open the Sources page.
From the Sources page, under Inbound share, select a bridge, and then from the ellipses menu, click Upload credentials.
View bridge configuration details¶
Configuration details for a bridge can be viewed from the Sources and Destinations pages.
To view configuration details for a bridge
Open the Sources or Destinations page.
Do one of the following:
For an inbound share, from the Sources page, under Inbound share, select a bridge, and then from the ellipses menu, click View.
For an outbound share, from the Destinations page, under Outbound share, select a bridge, and then from the ellipses menu, click View.