Alation
Explore the interactive ERD
Table & Field Reference
document_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
document_id | Unknown | PKFK |
field_id | Unknown | FK |
value | Json |
document
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_document_id | Unknown | FK |
parent_folder_id | Unknown | FK |
deleted | Boolean | |
description | Unknown | |
document_hub_id | Unknown | |
folder_ids | Json | |
nav_link_folder_ids | Json | |
nav_links_count | Unknown | |
template_id | Unknown | |
title | Unknown | |
ts_created | Instant | |
ts_deleted | Instant | |
ts_updated | Instant |
term_custom_field
| Column | Type | Keys |
|---|---|---|
field_id | Unknown | PKFK |
term_id | Unknown | PKFK |
field_name | Unknown | |
value | Json |
term
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
deleted | Boolean | |
description | Unknown | |
glossary_ids | Json | |
template_id | Unknown | |
title | Unknown | |
ts_created | Instant | |
ts_deleted | Instant | |
ts_updated | Instant |
policy_steward
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
policy_id | Unknown | PKFK |
deleted | Boolean | |
email | Unknown | |
name | Unknown | |
otype | Unknown | |
otype_display_name | Unknown | |
photo_url | Unknown | |
snippet | Unknown | |
title | Unknown | |
url | Unknown |
policy
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
otype | Unknown | |
title | Unknown | |
ts_created | Instant | |
url | Unknown |
policy_group_steward
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
policy_group_id | Unknown | PKFK |
deleted | Boolean | |
email | Unknown | |
name | Unknown | |
otype | Unknown | |
otype_display_name | Unknown | |
photo_url | Unknown | |
snippet | Unknown | |
title | Unknown | |
url | Unknown |
policy_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
otype | Unknown | |
policies_count | Unknown | |
title | Unknown | |
ts_created | Instant | |
url | Unknown |
custom_field_allowed_otype
| Column | Type | Keys |
|---|---|---|
otype | Unknown | PK |
custom_field_id | Unknown | PKFK |
custom_field_option
| Column | Type | Keys |
|---|---|---|
option | Unknown | PK |
custom_field_id | Unknown | PKFK |
custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
allow_multiple | Boolean | |
backref_name | Unknown | |
backref_tooltip_text | Unknown | |
builtin_name | Unknown | |
field_type | Unknown | |
name_plural | Unknown | |
name_singular | Unknown | |
tooltip_text | Unknown |
column_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
column_detail_id | Unknown | PKFK |
field_id | Unknown | FK |
field_name | Unknown | |
source_tag_applied_state | Unknown | |
value | Json |
column_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
datasource_id | Unknown | FK |
schema_id | Unknown | FK |
table_id | Unknown | FK |
column_comment | Unknown | |
column_type | Unknown | |
description | Unknown | |
index_is_foreign_key | Unknown | |
index_is_other_index | Unknown | |
index_is_primary_key | Unknown | |
index_referenced_column_id | Unknown | |
key | Unknown | |
name | Unknown | |
nullable | Boolean | |
position | Unknown | |
title | Unknown | |
url | Unknown |
child_column_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
column_id | Unknown | PKFK |
children | Json | |
description | Unknown | |
key | Unknown | |
other_metadata | Json | |
path | Unknown | |
title | Unknown | |
type | Unknown |
datasource_ocf
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
all_schemas | Unknown | |
auth_tip | Unknown | |
aws_access_key_id | Unknown | |
aws_region | Unknown | |
builtin_datasource | Unknown | |
can_data_upload | Boolean | |
can_toggle_ds_privacy | Boolean | |
compose_oauth_enabled | Boolean | |
connector_id | Unknown | |
cron_extraction | Unknown | |
data_upload_disabled_message | Unknown | |
db_username | Unknown | |
dbname | Unknown | |
dbtype | Unknown | |
delete_status | Unknown | |
deleted | Boolean | |
deployment_setup_complete | Boolean | |
description | Unknown | |
disable_auto_extraction | Boolean | |
enable_complex_type | Boolean | |
enable_default_schema_extraction | Boolean | |
enable_designated_credential | Boolean | |
enable_preserve_query_result | Boolean | |
enable_query_result_export | Boolean | |
exclude_additional_columns_in_qli | Boolean | |
exclude_schemas | Unknown | |
favorited_by_list | Json | |
has_aws_glue_metastore | Boolean | |
has_aws_s_3_based_qli | Boolean | |
has_hdfs_based_qli | Boolean | |
has_metastore_uri | Boolean | |
has_previewable_qli | Boolean | |
hive_logs_source | Unknown | |
hive_logs_source_type | Unknown | |
hive_tez_logs_source | Unknown | |
host | Unknown | |
icon | Unknown | |
is_gone | Boolean | |
is_hidden | Boolean | |
is_hive | Boolean | |
is_presto_hive | Boolean | |
is_virtual | Boolean | |
jdbc_driver | Unknown | |
latest_extraction_successful | Boolean | |
latest_extraction_time | Instant | |
limit_schemas | Unknown | |
metastore_type | Unknown | |
metastore_uri | Unknown | |
negative_filter_words | Json | |
nosql_mde_sample_size | Unknown | |
obfuscate_literals | Json | |
otype | Unknown | |
owner_ids | Json | |
port | Unknown | |
private | Boolean | |
profiling_tip | Unknown | |
qli_aws_access_key_id | Unknown | |
qli_aws_region | Unknown | |
qli_hive_connection_source | Unknown | |
qualified_name | Unknown | |
remove_filtered_schemas | Boolean | |
result_sharing_permission | Unknown | |
supports_compose | Boolean | |
supports_default_schema_extraction | Boolean | |
supports_explain | Boolean | |
supports_md_diagnostics | Boolean | |
supports_ocf_query_service_api | Boolean | |
supports_profiling | Boolean | |
supports_profiling_v_2 | Boolean | |
supports_qli_daterange | Boolean | |
supports_qli_diagnostics | Boolean | |
supports_query_cancellation | Boolean | |
title | Unknown | |
unresolved_mention_fingerprint_method | Unknown | |
uri | Unknown | |
url | Unknown | |
use_query_service | Unknown | |
uses_ocf_agent | Boolean | |
webhdfs_port | Unknown | |
webhdfs_server | Unknown | |
webhdfs_username | Unknown |
schema_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
schema_detail_id | Unknown | PKFK |
field_id | Unknown | FK |
field_name | Unknown | |
source_tag_applied_state | Unknown | |
value | Unknown |
schema_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
datasource_id | Unknown | FK |
db_comment | Unknown | |
description | Unknown | |
key | Unknown | |
name | Unknown | |
title | Unknown | |
url | Unknown |
custom_field_value_detail
| Column | Type | Keys |
|---|---|---|
object_id | Unknown | PK |
field_id | Unknown | PKFK |
otype | Unknown | |
source_tag_applied_state | Unknown | |
ts_updated | Instant | |
value | Json |
table_custom_field
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
table_detail_id | Unknown | PKFK |
field_id | Unknown | FK |
source_tag_applied_state | Unknown | |
value | Json |
table_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
datasource_id | Unknown | FK |
schema_id | Unknown | FK |
base_table_key | Unknown | |
description | Unknown | |
key | Unknown | |
name | Unknown | |
partition_columns | Json | |
partition_definition | Unknown | |
sql | Unknown | |
table_comment | Unknown | |
table_type | Unknown | |
title | Unknown | |
url | Unknown |
folder_custom_field
| Column | Type | Keys |
|---|---|---|
custom_field_id | Unknown | PKFK |
folder_id | Unknown | PKFK |
folder
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_folder_id | Unknown | FK |
deleted | Boolean | |
description | Unknown | |
document_hub_id | Unknown | |
nav_links_count | Unknown | |
template_id | Unknown | |
title | Unknown | |
ts_created | Instant | |
ts_deleted | Instant | |
ts_updated | Instant |