What is an Object Key?

Ok, you are curious to know what exactly is an object key. An object key reflects a unique destination for data being delivered to S3. The object key tells Stitch where to store data and it tells Openbridge that data belongs to you as well as which warehouse and table you want it loaded into. 

This diagram should help explain the anatomy of an object key Stitch is looking for.  There are 4 distinct parts to your object key:

  • A) Account ID: Openbridge will issue you a unique account ID. This uniquely identifies this object key as belonging to you. Contact your Openbridge support team to provision this for you.

For B, C and D Stitch will automatically replace the [integration_name] , [table_name] , [table_version]  and [timestamp_loaded]  values.

  • B) Integration Name: This is the name you input when asked for Integration Name in the Stitch UI. Since it can be anything, you will always want to make sure it is connected to the data source you are collecting data from. For example, if you are collecting campaign data from Google Analytics, use something like google_analytics_campaign 
  • C) Table Name: Your table name in Openbridge is a concatenation of your [integration_name]  and the [table_name]  set by Stitch. The combination of these two values provides a unique name specific to the data being delivered
  • D) Filename: We are setting a unique filename that reflects the [integration_name] , [table_name]  , and [timestamp_loaded] 

 The final object key you want to use with Stitch will look like this:

ebs/ftpd/[youraccount-ID]/[integration_name]/[integration_name]_[table_name]/[integration_name]_[table_version]_[timestamp_loaded]

IMPORTANT: Make sure to replace [youraccount-ID] with the value provide by your Openbridge team. If Openbridge issues you an account ID called "youruniqueID001"place that into the key:

ebs/ftpd/youruniqueID001/[integration_name]/[integration_name]_[table_name]/[integration_name]_[table_version]_[timestamp_loaded]
Did this answer your question?