Adobe Experience Platform
Explore the interactive ERD
Table & Field Reference
segment_definition
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ims_org_id | Unknown | FK |
merge_policy_id | Unknown | FK |
creation_time | Instant | |
data_governance_policy_exclude_opt_out | Unknown | |
description | Unknown | |
evalutioninfo_batch_enabled | Unknown | |
evalutioninfo_continuous_enabled | Unknown | |
evalutioninfo_synchronous_enabled | Unknown | |
expression_format | Unknown | |
expression_type | Unknown | |
expression_value | Unknown | |
name | Unknown | |
payload_schema | Unknown | |
profile_instance_id | Unknown | |
update_epoch | Instant | |
update_time | Instant |
dataset_label_optional_label
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
dataset_id | Unknown | PKFK |
labels | Json | |
option_content_type | Unknown | |
option_id | Unknown | |
option_schema_path | Unknown |
dataset_label_parent
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
dataset_id | Unknown | PKFK |
id | Unknown | |
namespace | Unknown | |
type | Unknown |
alert
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
alert_type | Unknown | |
asset_id | Unknown | |
status | Unknown |
merge_policy
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
attribute_merge_order | Json | |
attribute_merge_type | Unknown | |
identity_graph_type | Unknown | |
is_active_on_edge | Unknown | |
is_default | Unknown | |
name | Unknown | |
schema_name | Unknown | |
version | Unknown |
connection_database
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
connection_username | Unknown | PKFK |
db_name | Unknown | |
name | Unknown |
connection
| Column | Type | Keys |
|---|---|---|
username | Unknown | PK |
disable_psql_creds | Unknown | |
host | Unknown | |
port | Unknown | |
version | Unknown | |
websocket_host | Unknown |
query_template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
last_updated_by | Unknown | |
links | Json | |
name | Unknown | |
query_parameters | Json | |
sql | Unknown | |
updated | Instant | |
user_id | Unknown |
destination_configuaration_custom_data_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
destination_configuaration_id | Unknown | PKFK |
description | Unknown | |
enum | Json | |
is_required | Unknown | |
name | Unknown | |
title | Unknown | |
type | Unknown |
destination_configuaration_profile_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
destination_configuaration_id | Unknown | PKFK |
defaults | Unknown | |
description | Unknown | |
format | Unknown | |
hidden | Unknown | |
is_required | Unknown | |
name | Unknown | |
pattern | Unknown | |
read_only | Unknown | |
title | Unknown | |
type | Unknown |
destination_configuaration_delivery
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
destination_configuaration_id | Unknown | PKFK |
authentication_id | Unknown | |
authentication_rule | Unknown | |
destination_server_id | Unknown |
destination_configuaration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ims_org | Unknown | FK |
aggregation_type | Unknown | |
backfill_historical_profile_data | Unknown | |
batch_config_allow_dedupe_key_field_selection | Unknown | |
batch_config_allow_mandatory_field_selection | Unknown | |
batch_config_allowed_export_modes | Unknown | |
batch_config_allowed_filename_append_options | Json | |
batch_config_allowed_schedule_frequency | Unknown | |
batch_config_default_export_mode | Unknown | |
batch_config_default_filename | Unknown | |
batch_config_default_filename_append_options | Json | |
batch_config_default_frequency | Unknown | |
batch_config_default_start_time | Unknown | |
batch_config_segment_grouping_enabled | Unknown | |
best_effort_aggregation | Unknown | |
best_effort_aggregation_max_users_per_request | Unknown | |
best_effort_aggregation_split_user_by_id | Unknown | |
configurable_aggregation_aggregation_key | Unknown | |
configurable_aggregation_max_batch_age_in_secs | Unknown | |
configurable_aggregation_max_num_events_in_batch | Unknown | |
configurable_aggregation_split_user_by_id | Unknown | |
created_date | Instant | |
customer_authentication_configuration | Unknown | |
description | Unknown | |
destination_delivery | Unknown | |
dule_labels | Json | |
identity_another_attribute | Unknown | |
identity_another_custom_namespace | Unknown | |
identity_external_attribute | Unknown | |
identity_external_custom_namespace | Unknown | |
identity_external_global_namespaces | Json | |
identity_external_transformation | Unknown | |
last_modified_date | Instant | |
marketing_actions | Json | |
name | Unknown | |
schema_config_identity_required | Unknown | |
schema_config_profile_required | Unknown | |
schema_config_segment_namespace_allow_list | Json | |
schema_config_segment_namespace_deny_list | Json | |
schema_config_segment_required | Unknown | |
segment_config_audience_template_id | Unknown | |
segment_config_map_experience_platform_segment_id | Unknown | |
segment_config_map_experience_platform_segment_name | Unknown | |
segment_config_map_user_input | Unknown | |
status | Unknown | |
ui_attributes_category | Unknown | |
ui_attributes_connection_type | Unknown | |
ui_attributes_documentation_link | Unknown | |
ui_attributes_frequency | Unknown |
flow_source_connection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
flow_id | Unknown | PKFK |
base_connection_spec_id | Unknown | FK |
connection_spec_id | Unknown | FK |
base_connection_id | Unknown | |
base_connection_spec_version | Unknown | |
connection_spec_version | Unknown |
flow_target_connection
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
flow_id | Unknown | PKFK |
connection_spec_id | Unknown | FK |
connection_spec_version | Unknown |
flow_transformation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
flow_id | Unknown | PKFK |
mapping_id | Unknown | |
mapping_version | Unknown | |
name | Unknown |
flow
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ims_org_id | Unknown | FK |
provider_ref_id | Unknown | FK |
created_at | Instant | |
created_by | Unknown | |
created_client | Unknown | |
description | Unknown | |
etag | Unknown | |
flow_spec_id | Unknown | |
flow_spec_version | Unknown | |
is_source_flow | Unknown | |
labels | Json | |
last_operation_operation | Unknown | |
last_operation_started | Instant | |
last_operation_updated | Unknown | |
last_run_details_completed_at_utc | Instant | |
last_run_details_id | Unknown | |
last_run_details_started_at_utc | Instant | |
last_run_details_state | Unknown | |
name | Unknown | |
record_type | Json | |
runs | Unknown | |
schedule_params_backfill | Unknown | |
schedule_params_frequency | Unknown | |
schedule_params_interval | Unknown | |
schedule_params_start_time | Instant | |
state | Unknown | |
updated_at | Instant | |
updated_by | Unknown | |
updated_client | Unknown | |
version | Unknown |
connection_spec_permissions_manage
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
connection_spec_id | Unknown | PKFK |
name | Unknown | |
permission | Json | |
type | Unknown |
connection_spec_permissions_view
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
connection_spec_id | Unknown | PKFK |
name | Unknown | |
permission | Json | |
type | Unknown |
connection_spec
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
provider_id | Unknown | |
version | Unknown | |
attributes_** | ||
explore_spec_** | ||
source_spec_** |
audience_label
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
audience_id | Unknown | PKFK |
label | Unknown |
audience
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
dataset_id | Unknown | FK |
merge_policy_id | Unknown | FK |
create_epoch | Instant | |
created_by | Unknown | |
creation_time | Instant | |
data_governance_policy_exclude_opt_out | Unknown | |
dependencies | Json | |
dependents | Json | |
description | Unknown | |
evaluation_info_batch_enabled | Unknown | |
evaluation_info_continuous_enabled | Unknown | |
evaluation_info_synchronous_enabled | Unknown | |
expression_format | Unknown | |
expression_type | Unknown | |
expression_value | Unknown | |
is_system | Unknown | |
lifecycle_state | Unknown | |
linked_audience_ref_flow_id | Unknown | |
name | Unknown | |
profile_instance_id | Unknown | |
type | Unknown | |
update_epoch | Instant | |
update_time | Instant |
schedule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
query_template_id | Unknown | FK |
created | Instant | |
query_ctas_parameters_dataset_name | Unknown | |
query_ctas_parameters_description | Unknown | |
query_ctas_parameters_target_schema_title | Unknown | |
query_db_name | Unknown | |
query_description | Unknown | |
query_insert_into_parameters_dataset_name | Unknown | |
schedule | Unknown | |
schedule_end_date | Unknown | |
schedule_max_active_runs | Unknown | |
schedule_start_date | Unknown | |
state | Unknown | |
updated | Instant | |
updated_user_id | Unknown | |
user_id | Unknown |
destination_server
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
adls_gen_2_destination_path_templating_strategy | Unknown | |
adls_gen_2_destination_path_value | Unknown | |
azure_blob_destination_container_templating_strategy | Unknown | |
azure_blob_destination_container_value | Unknown | |
azure_blob_destination_path_templating_strategy | Unknown | |
azure_blob_destination_path_value | Unknown | |
created_date | Unknown | |
destination_server_type | Unknown | |
destination_url_templating_strategy | Unknown | |
destination_url_value | Unknown | |
dlz_destination_path_templating_strategy | Unknown | |
dlz_destination_path_value | Unknown | |
dlz_destination_use_case | Unknown | |
google_cloud_storage_destination_bucket_templating_strategy | Unknown | |
google_cloud_storage_destination_bucket_value | Unknown | |
google_cloud_storage_destination_path_templating_strategy | Unknown | |
google_cloud_storage_destination_path_value | Unknown | |
http_template_content_type | Unknown | |
http_template_headers | Unknown | |
http_template_http_method | Unknown | |
http_template_query_parameters_templating_strategy | Unknown | |
http_template_query_parameters_value | Unknown | |
http_template_request_body_templating_strategy | Unknown | |
http_template_request_body_value | Unknown | |
last_modified_date | Unknown | |
name | Unknown | |
s_3_destination_bucket_templating_strategy | Unknown | |
s_3_destination_bucket_value | Unknown | |
s_3_destination_path_templating_strategy | Unknown | |
s_3_destination_path_value | Unknown | |
sftp_destination_encryption_mode | Unknown | |
sftp_destination_host_name_templating_strategy | Unknown | |
sftp_destination_host_name_value | Unknown | |
sftp_destination_port | Unknown | |
sftp_destination_root_directory_templating_strategy | Unknown | |
sftp_destination_root_directory_value | Unknown |
computed_attribute_defined
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
computed_attribute_id | Unknown | PKFK |
meta_container_id | Unknown | |
meta_resource_type | Unknown |
computed_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ims_org_id | Unknown | FK |
create_epoch | Instant | |
created_by | Unknown | |
description | Unknown | |
display_name | Unknown | |
expression_format | Unknown | |
expression_type | Unknown | |
expression_value | Unknown | |
keep_current | Unknown | |
last_evaluation_ts | Unknown | |
merge_function_value | Unknown | |
name | Unknown | |
path | Unknown | |
return_schema_meta_xdm_type | Unknown | |
schema_name | Unknown | |
status | Unknown | |
type | Unknown | |
update_epoch | Instant |
schema_registry_class
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
alt_id | Unknown | |
description | Unknown | |
resource_type | Unknown | |
title | Unknown | |
type | Unknown | |
version | Unknown | |
properties_** |
dataset
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ims_org_id | Unknown | FK |
base_path | Unknown | |
classification_data_behavior | Unknown | |
classification_managed_by | Unknown | |
created | Instant | |
created_client | Unknown | |
created_user | Unknown | |
data_ingested | Unknown | |
data_source_id | Unknown | |
datastream_source | Unknown | |
description | Unknown | |
enable_error_diagnostics | Unknown | |
extensions_adobe_lakehouse_metrics_as_of | Unknown | |
extensions_adobe_lakehouse_metrics_row_count | Unknown | |
extensions_adobe_lakehouse_metrics_storage_size | Unknown | |
file | Unknown | |
file_description_charset | Unknown | |
file_description_delimiters | Unknown | |
file_description_escapes | Unknown | |
file_description_format | Unknown | |
file_description_header | Unknown | |
file_description_null_markers | Unknown | |
file_description_quotes | Unknown | |
ingestion_type | Unknown | |
last_batch_id | Unknown | |
last_batch_status | Unknown | |
last_failed_batch | Unknown | |
last_successful_batch | Unknown | |
name | Unknown | |
observable_schema | Json | |
persistence_adls_location | Unknown | |
persistence_adls_type | Unknown | |
schema | Unknown | |
schema_ref_content_type | Unknown | |
schema_ref_id | Unknown | |
tags | Json | |
updated | Instant | |
updated_user | Unknown | |
version | Unknown | |
view_id | Unknown |
entity_identity
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
entity_id | Unknown | PKFK |
id | Unknown | |
is_primary | Unknown | |
namespace_code | Unknown |
entity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
last_modified_at | Instant | |
person_first_name | Unknown | |
person_last_name | Unknown | |
person_middle_name | Unknown | |
work_email_address | Unknown | |
work_email_is_primary | Unknown | |
work_email_label | Unknown | |
work_email_status | Unknown | |
work_email_type | Unknown |