Schema Info

Schema Name: sfdl_dev_rds.sparefoot_corporations

created: 2022-06-03 22:49:56
disabled: False
format: raw
id: 1813
is_partitioned: False
is_schema_datatyped: False

name:

{
    "database": "sfdl_dev_rds",
    "table": "sparefoot_corporations"
}

type: rds

Schema Versions: 15

Version 4689870

created: 2022-08-10 19:50:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-08-10/1660179025'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-08-10/1660179025
id: 4689870
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1813
schema_scan_id: 5964984
updated: 2022-08-10 19:50:55

Version 4689317

created: 2022-06-07 17:50:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654642203'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654642203
id: 4689317
processed: 1

raw_data:

{
    "account_id": "int32",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int16",
    "centershift_channel": "int32",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int32",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int32",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int32",
    "mig_id": "int32",
    "mig_location_id": "int32",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "int32",
    "name": "string",
    "pull_promos": "int16",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int32",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1813
schema_scan_id: 5931280
updated: 2022-06-07 17:50:49

Version 4689288

created: 2022-06-07 11:45:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  bigint , `api_password`  string , `api_username`  string , `cdp_disabled`  double , `centershift_channel`  double , `centershift_endpoint`  string , `centershift_inquiry_source_id`  double , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  bigint , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  double , `mig_id`  double , `mig_location_id`  double , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  double , `name`  string , `pull_promos`  double , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  bigint , `time_created`  timestamp , `time_modified`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654620338'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654620338
id: 4689288
processed: 1

raw_data:

{
    "account_id": "int64",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "double",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int64",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "double",
    "mig_id": "double",
    "mig_location_id": "double",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "double",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int64",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "bigint",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "double",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "bigint",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "double",
    "mig_id": "double",
    "mig_location_id": "double",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "double",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "bigint",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1813
schema_scan_id: 5930675
updated: 2022-06-07 11:45:59

Version 4689287

created: 2022-06-07 11:27:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  bigint , `api_password`  string , `api_username`  string , `cdp_disabled`  double , `centershift_channel`  double , `centershift_endpoint`  string , `centershift_inquiry_source_id`  double , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  bigint , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  double , `mig_id`  double , `mig_location_id`  double , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  double , `name`  string , `pull_promos`  double , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  bigint , `time_created`  timestamp , `time_modified`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654619199'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654619199
id: 4689287
processed: 1

raw_data:

{
    "account_id": "int64",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "double",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int64",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "double",
    "mig_id": "double",
    "mig_location_id": "double",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "double",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int64",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "bigint",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "double",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "bigint",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "double",
    "mig_id": "double",
    "mig_location_id": "double",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "double",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "bigint",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1813
schema_scan_id: 5930650
updated: 2022-06-07 11:27:33

Version 4689285

created: 2022-06-07 11:08:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  bigint , `api_password`  string , `api_username`  string , `cdp_disabled`  double , `centershift_channel`  double , `centershift_endpoint`  string , `centershift_inquiry_source_id`  double , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  bigint , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  double , `mig_id`  double , `mig_location_id`  double , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  double , `name`  string , `pull_promos`  double , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  bigint , `time_created`  timestamp , `time_modified`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654618086'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654618086
id: 4689285
processed: 1

raw_data:

{
    "account_id": "int64",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "double",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int64",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "double",
    "mig_id": "double",
    "mig_location_id": "double",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "double",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int64",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "bigint",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "double",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "bigint",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "double",
    "mig_id": "double",
    "mig_location_id": "double",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "double",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "bigint",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1813
schema_scan_id: 5930648
updated: 2022-06-07 11:08:36

Version 4689284

created: 2022-06-07 11:00:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  bigint , `api_password`  string , `api_username`  string , `cdp_disabled`  double , `centershift_channel`  double , `centershift_endpoint`  string , `centershift_inquiry_source_id`  double , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  bigint , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  double , `mig_id`  double , `mig_location_id`  double , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  double , `name`  string , `pull_promos`  double , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  bigint , `time_created`  timestamp , `time_modified`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654617590'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654617590
id: 4689284
processed: 1

raw_data:

{
    "account_id": "int64",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "double",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int64",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "double",
    "mig_id": "double",
    "mig_location_id": "double",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "double",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int64",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "bigint",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "double",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "bigint",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "double",
    "mig_id": "double",
    "mig_location_id": "double",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "double",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "bigint",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1813
schema_scan_id: 5930647
updated: 2022-06-07 11:00:13

Version 4689283

created: 2022-06-07 10:56:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  smallint , `api_password`  string , `api_username`  string , `cdp_disabled`  double , `centershift_channel`  double , `centershift_endpoint`  string , `centershift_inquiry_source_id`  double , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  smallint , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  double , `mig_id`  double , `mig_location_id`  double , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  double , `name`  string , `pull_promos`  double , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  smallint , `time_created`  timestamp , `time_modified`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654617342'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654617342
id: 4689283
processed: 1

raw_data:

{
    "account_id": "int16",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "double",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int16",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "double",
    "mig_id": "double",
    "mig_location_id": "double",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp[ns]",
    "mig_type": "string",
    "mig_user_id": "double",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int8",
    "time_created": "timestamp[ns]",
    "time_modified": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "smallint",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "double",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "smallint",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "double",
    "mig_id": "double",
    "mig_location_id": "double",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "double",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "smallint",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

schema_name_id: 1813
schema_scan_id: 5930640
updated: 2022-06-07 10:56:17

Version 4689282

created: 2022-06-07 10:49:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  bigint , `api_password`  string , `api_username`  string , `cdp_disabled`  double , `centershift_channel`  double , `centershift_endpoint`  string , `centershift_inquiry_source_id`  string , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  bigint , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  string , `mig_id`  string , `mig_location_id`  string , `mig_payment_type`  string , `mig_time_live`  string , `mig_type`  string , `mig_user_id`  string , `name`  string , `pull_promos`  double , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  bigint , `time_created`  string , `time_modified`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654616964'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654616964
id: 4689282
processed: 1

raw_data:

{
    "account_id": "int64",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "null",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int64",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "null",
    "mig_id": "null",
    "mig_location_id": "null",
    "mig_payment_type": "null",
    "mig_time_live": "null",
    "mig_type": "null",
    "mig_user_id": "null",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int64",
    "time_created": "string",
    "time_modified": "string"
}

schema_attributes:

{
    "account_id": "bigint",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "string",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "bigint",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "string",
    "mig_id": "string",
    "mig_location_id": "string",
    "mig_payment_type": "string",
    "mig_time_live": "string",
    "mig_type": "string",
    "mig_user_id": "string",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "bigint",
    "time_created": "string",
    "time_modified": "string"
}

schema_name_id: 1813
schema_scan_id: 5930630
updated: 2022-06-07 10:49:57

Version 4689278

created: 2022-06-06 20:11:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  string , `api_password`  string , `api_username`  string , `cdp_disabled`  bigint , `centershift_channel`  bigint , `centershift_endpoint`  string , `centershift_inquiry_source_id`  string , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  string , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  string , `mig_id`  string , `mig_location_id`  string , `mig_payment_type`  string , `mig_time_live`  string , `mig_type`  string , `mig_user_id`  string , `name`  string , `pull_promos`  bigint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  string , `time_created`  string , `time_modified`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654564273'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654564273
id: 4689278
processed: 1

raw_data:

{
    "account_id": "string",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int64",
    "centershift_channel": "int64",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "string",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "string",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "string",
    "mig_id": "string",
    "mig_location_id": "string",
    "mig_payment_type": "string",
    "mig_time_live": "string",
    "mig_type": "string",
    "mig_user_id": "string",
    "name": "string",
    "pull_promos": "int64",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "string",
    "time_created": "string",
    "time_modified": "string"
}

schema_attributes:

{
    "account_id": "string",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "bigint",
    "centershift_channel": "bigint",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "string",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "string",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "string",
    "mig_id": "string",
    "mig_location_id": "string",
    "mig_payment_type": "string",
    "mig_time_live": "string",
    "mig_type": "string",
    "mig_user_id": "string",
    "name": "string",
    "pull_promos": "bigint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "string",
    "time_created": "string",
    "time_modified": "string"
}

schema_name_id: 1813
schema_scan_id: 5930363
updated: 2022-06-06 20:11:34

Version 4689277

created: 2022-06-06 20:07:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  string , `api_password`  string , `api_username`  string , `cdp_disabled`  bigint , `centershift_channel`  bigint , `centershift_endpoint`  string , `centershift_inquiry_source_id`  string , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  string , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  string , `mig_id`  string , `mig_location_id`  string , `mig_payment_type`  string , `mig_time_live`  string , `mig_type`  string , `mig_user_id`  string , `name`  string , `pull_promos`  bigint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  string , `time_created`  string , `time_modified`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654564024'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654564024
id: 4689277
processed: 1

raw_data:

{
    "account_id": "string",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int64",
    "centershift_channel": "int64",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "string",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "string",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "string",
    "mig_id": "string",
    "mig_location_id": "string",
    "mig_payment_type": "string",
    "mig_time_live": "string",
    "mig_type": "string",
    "mig_user_id": "string",
    "name": "string",
    "pull_promos": "int64",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "string",
    "time_created": "string",
    "time_modified": "string"
}

schema_attributes:

{
    "account_id": "string",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "bigint",
    "centershift_channel": "bigint",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "string",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "string",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "string",
    "mig_id": "string",
    "mig_location_id": "string",
    "mig_payment_type": "string",
    "mig_time_live": "string",
    "mig_type": "string",
    "mig_user_id": "string",
    "name": "string",
    "pull_promos": "bigint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "string",
    "time_created": "string",
    "time_modified": "string"
}

schema_name_id: 1813
schema_scan_id: 5930362
updated: 2022-06-06 20:07:34

Version 4689276

created: 2022-06-06 20:03:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  string , `api_password`  string , `api_username`  string , `cdp_disabled`  bigint , `centershift_channel`  bigint , `centershift_endpoint`  string , `centershift_inquiry_source_id`  string , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  string , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  string , `mig_id`  string , `mig_location_id`  string , `mig_payment_type`  string , `mig_time_live`  string , `mig_type`  string , `mig_user_id`  string , `name`  string , `pull_promos`  bigint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  string , `time_created`  string , `time_modified`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654563763'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654563763
id: 4689276
processed: 1

raw_data:

{
    "account_id": "string",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "int64",
    "centershift_channel": "int64",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "string",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "string",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "string",
    "mig_id": "string",
    "mig_location_id": "string",
    "mig_payment_type": "string",
    "mig_time_live": "string",
    "mig_type": "string",
    "mig_user_id": "string",
    "name": "string",
    "pull_promos": "int64",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "string",
    "time_created": "string",
    "time_modified": "string"
}

schema_attributes:

{
    "account_id": "string",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "bigint",
    "centershift_channel": "bigint",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "string",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "string",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "string",
    "mig_id": "string",
    "mig_location_id": "string",
    "mig_payment_type": "string",
    "mig_time_live": "string",
    "mig_type": "string",
    "mig_user_id": "string",
    "name": "string",
    "pull_promos": "bigint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "string",
    "time_created": "string",
    "time_modified": "string"
}

schema_name_id: 1813
schema_scan_id: 5930361
updated: 2022-06-06 20:03:28

Version 4689275

created: 2022-06-06 19:58:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  bigint , `api_password`  string , `api_username`  string , `cdp_disabled`  double , `centershift_channel`  double , `centershift_endpoint`  string , `centershift_inquiry_source_id`  string , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  bigint , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  string , `mig_id`  string , `mig_location_id`  string , `mig_payment_type`  string , `mig_time_live`  string , `mig_type`  string , `mig_user_id`  string , `name`  string , `pull_promos`  double , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  bigint , `time_created`  string , `time_modified`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654563482'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654563482
id: 4689275
processed: 1

raw_data:

{
    "account_id": "int64",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "null",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int64",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "null",
    "mig_id": "null",
    "mig_location_id": "null",
    "mig_payment_type": "null",
    "mig_time_live": "null",
    "mig_type": "null",
    "mig_user_id": "null",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int64",
    "time_created": "string",
    "time_modified": "string"
}

schema_attributes:

{
    "account_id": "bigint",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "string",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "bigint",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "string",
    "mig_id": "string",
    "mig_location_id": "string",
    "mig_payment_type": "string",
    "mig_time_live": "string",
    "mig_type": "string",
    "mig_user_id": "string",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "bigint",
    "time_created": "string",
    "time_modified": "string"
}

schema_name_id: 1813
schema_scan_id: 5930358
updated: 2022-06-06 19:58:35

Version 4689274

created: 2022-06-06 19:54:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  bigint , `api_password`  string , `api_username`  string , `cdp_disabled`  double , `centershift_channel`  double , `centershift_endpoint`  string , `centershift_inquiry_source_id`  string , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  bigint , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  string , `mig_id`  string , `mig_location_id`  string , `mig_payment_type`  string , `mig_time_live`  string , `mig_type`  string , `mig_user_id`  string , `name`  string , `pull_promos`  double , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  bigint , `time_created`  string , `time_modified`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654563208'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654563208
id: 4689274
processed: 1

raw_data:

{
    "account_id": "int64",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "null",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int64",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "null",
    "mig_id": "null",
    "mig_location_id": "null",
    "mig_payment_type": "null",
    "mig_time_live": "null",
    "mig_type": "null",
    "mig_user_id": "null",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int64",
    "time_created": "string",
    "time_modified": "string"
}

schema_attributes:

{
    "account_id": "bigint",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "string",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "bigint",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "string",
    "mig_id": "string",
    "mig_location_id": "string",
    "mig_payment_type": "string",
    "mig_time_live": "string",
    "mig_type": "string",
    "mig_user_id": "string",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "bigint",
    "time_created": "string",
    "time_modified": "string"
}

schema_name_id: 1813
schema_scan_id: 5930357
updated: 2022-06-06 19:54:19

Version 4689272

created: 2022-06-06 18:43:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  bigint , `api_password`  string , `api_username`  string , `cdp_disabled`  double , `centershift_channel`  double , `centershift_endpoint`  string , `centershift_inquiry_source_id`  string , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  bigint , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  string , `mig_id`  string , `mig_location_id`  string , `mig_payment_type`  string , `mig_time_live`  string , `mig_type`  string , `mig_user_id`  string , `name`  string , `pull_promos`  double , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  bigint , `time_created`  string , `time_modified`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654559014'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654559014
id: 4689272
processed: 1

raw_data:

{
    "account_id": "int64",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "null",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int64",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "null",
    "mig_id": "null",
    "mig_location_id": "null",
    "mig_payment_type": "null",
    "mig_time_live": "null",
    "mig_type": "null",
    "mig_user_id": "null",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int64",
    "time_created": "string",
    "time_modified": "string"
}

schema_attributes:

{
    "account_id": "bigint",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "string",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "bigint",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "string",
    "mig_id": "string",
    "mig_location_id": "string",
    "mig_payment_type": "string",
    "mig_time_live": "string",
    "mig_type": "string",
    "mig_user_id": "string",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "bigint",
    "time_created": "string",
    "time_modified": "string"
}

schema_name_id: 1813
schema_scan_id: 5930354
updated: 2022-06-06 18:44:09

Version 4689271

created: 2022-06-06 18:35:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  bigint , `api_password`  string , `api_username`  string , `cdp_disabled`  double , `centershift_channel`  double , `centershift_endpoint`  string , `centershift_inquiry_source_id`  string , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  bigint , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  string , `mig_id`  string , `mig_location_id`  string , `mig_payment_type`  string , `mig_time_live`  string , `mig_type`  string , `mig_user_id`  string , `name`  string , `pull_promos`  double , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  bigint , `time_created`  string , `time_modified`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654558533'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654558533
id: 4689271
processed: 1

raw_data:

{
    "account_id": "int64",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "null",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int64",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "null",
    "mig_id": "null",
    "mig_location_id": "null",
    "mig_payment_type": "null",
    "mig_time_live": "null",
    "mig_type": "null",
    "mig_user_id": "null",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int64",
    "time_created": "string",
    "time_modified": "string"
}

schema_attributes:

{
    "account_id": "bigint",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "double",
    "centershift_channel": "double",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "string",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "bigint",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "string",
    "mig_id": "string",
    "mig_location_id": "string",
    "mig_payment_type": "string",
    "mig_time_live": "string",
    "mig_type": "string",
    "mig_user_id": "string",
    "name": "string",
    "pull_promos": "double",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "bigint",
    "time_created": "string",
    "time_modified": "string"
}

schema_name_id: 1813
schema_scan_id: 5930352
updated: 2022-06-06 18:36:06

Schema Scans: 15

Last at 2022-08-10 19:50:43

Scan 5964984

duration: 0:00:15.018641

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5964984

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-08-10/1660179025",
        "key": "raw/corporations/2022-08-10/1660179025/corporations.parquet.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11569320854281424334,
        "service_name": "sparefoot",
        "span_id": 17299034751561294794,
        "trace_id": 11569320854281424334
    }
}

running: False
schema_name_id: 1813
start_time: 2022-08-10 19:50:43
success: True
trace_id: 11569320854281424334

Scan 5931280

duration: 0:00:40.911343

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5931280

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654642203",
        "key": "raw/corporations/2022-06-07/1654642203/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8374277503051841515,
        "service_name": "sparefoot",
        "span_id": 12470638743575195406,
        "trace_id": 8374277503051841515
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-07 17:50:11
success: True
trace_id: 8374277503051841515

Scan 5930675

duration: 0:00:14.905628

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930675

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654620338",
        "key": "raw/corporations/2022-06-07/1654620338/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4896419082735786076,
        "service_name": "sparefoot",
        "span_id": 8909819545376679335,
        "trace_id": 4896419082735786076
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-07 11:45:47
success: True
trace_id: 4896419082735786076

Scan 5930650

duration: 0:00:30.668328

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930650

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654619199",
        "key": "raw/corporations/2022-06-07/1654619199/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13838429706412665395,
        "service_name": "sparefoot",
        "span_id": 10705352515423628248,
        "trace_id": 13838429706412665395
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-07 11:27:05
success: True
trace_id: 13838429706412665395

Scan 5930648

duration: 0:00:22.525152

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930648

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654618086",
        "key": "raw/corporations/2022-06-07/1654618086/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13838429706412665395,
        "service_name": "sparefoot",
        "span_id": 10770620024819460736,
        "trace_id": 13838429706412665395
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-07 11:08:17
success: True
trace_id: 13838429706412665395

Scan 5930647

duration: 0:00:15.117465

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930647

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654617590",
        "key": "raw/corporations/2022-06-07/1654617590/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13838429706412665395,
        "service_name": "sparefoot",
        "span_id": 4924695655670590147,
        "trace_id": 13838429706412665395
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-07 11:00:01
success: True
trace_id: 13838429706412665395

Scan 5930640

duration: 0:00:25.509173

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930640

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654617342",
        "key": "raw/corporations/2022-06-07/1654617342/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13838429706412665395,
        "service_name": "sparefoot",
        "span_id": 14925317522118798082,
        "trace_id": 13838429706412665395
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-07 10:55:55
success: True
trace_id: 13838429706412665395

Scan 5930630

duration: 0:00:25.577788

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930630

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-07/1654616964",
        "key": "raw/corporations/2022-06-07/1654616964/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 13838429706412665395,
        "service_name": "sparefoot",
        "span_id": 10804604988121872783,
        "trace_id": 13838429706412665395
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-07 10:49:34
success: True
trace_id: 13838429706412665395

Scan 5930363

duration: 0:00:14.995843

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930363

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654564273",
        "key": "raw/corporations/2022-06-06/1654564273/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11848004253308689721,
        "service_name": "sparefoot",
        "span_id": 8984026656685984552,
        "trace_id": 11848004253308689721
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-06 20:11:22
success: True
trace_id: 11848004253308689721

Scan 5930362

duration: 0:00:15.070147

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930362

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654564024",
        "key": "raw/corporations/2022-06-06/1654564024/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11848004253308689721,
        "service_name": "sparefoot",
        "span_id": 4203547711416469066,
        "trace_id": 11848004253308689721
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-06 20:07:21
success: True
trace_id: 11848004253308689721

Scan 5930361

duration: 0:00:20.148037

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930361

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654563763",
        "key": "raw/corporations/2022-06-06/1654563763/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 11848004253308689721,
        "service_name": "sparefoot",
        "span_id": 10459367191045222328,
        "trace_id": 11848004253308689721
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-06 20:03:10
success: True
trace_id: 11848004253308689721

Scan 5930358

duration: 0:00:14.981385

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930358

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654563482",
        "key": "raw/corporations/2022-06-06/1654563482/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1827583513153482906,
        "service_name": "sparefoot",
        "span_id": 8729043065775821971,
        "trace_id": 1827583513153482906
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-06 19:58:22
success: True
trace_id: 1827583513153482906

Scan 5930357

duration: 0:00:20.317490

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930357

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654563208",
        "key": "raw/corporations/2022-06-06/1654563208/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9770410506902690193,
        "service_name": "sparefoot",
        "span_id": 17795270470482360928,
        "trace_id": 9770410506902690193
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-06 19:54:01
success: True
trace_id: 9770410506902690193

Scan 5930354

duration: 0:00:15.150367

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930354

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654559014",
        "key": "raw/corporations/2022-06-06/1654559014/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5871413662629354352,
        "service_name": "sparefoot",
        "span_id": 11946914329769577737,
        "trace_id": 5871413662629354352
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-06 18:43:57
success: True
trace_id: 5871413662629354352

Scan 5930352

duration: 0:00:15.128363

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5930352

payload:

{
    "datatype_dict": null,
    "file_format": "parquet",
    "is_schema_datatyped": false,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/corporations/2022-06-06/1654558533",
        "key": "raw/corporations/2022-06-06/1654558533/corporations_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_corporations",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5871413662629354352,
        "service_name": "sparefoot",
        "span_id": 17630708867318769375,
        "trace_id": 5871413662629354352
    }
}

running: False
schema_name_id: 1813
start_time: 2022-06-06 18:35:54
success: True
trace_id: 5871413662629354352

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "account_id": "int",
    "api_password": "string",
    "api_username": "string",
    "cdp_disabled": "smallint",
    "centershift_channel": "int",
    "centershift_endpoint": "string",
    "centershift_inquiry_source_id": "int",
    "centershift_org_id": "string",
    "centershift_signature": "string",
    "corporation_id": "int",
    "domico_client_id": "string",
    "domico_web_service_key": "string",
    "mig_billing_verified": "int",
    "mig_id": "int",
    "mig_location_id": "int",
    "mig_payment_type": "string",
    "mig_time_live": "timestamp",
    "mig_type": "string",
    "mig_user_id": "int",
    "name": "string",
    "pull_promos": "smallint",
    "quikstor_wsdl": "string",
    "rate_type": "string",
    "reservation_type": "string",
    "sitelink_corp_code": "string",
    "source_id": "int",
    "time_created": "timestamp",
    "time_modified": "timestamp"
}

created: 2022-08-10 19:50:44

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-08-10/1660179025'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2022-06-03 22:49:56",
        "disabled": false,
        "format": "raw",
        "id": 1813,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_rds",
            "table": "sparefoot_corporations"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "account_id": "int",
            "api_password": "string",
            "api_username": "string",
            "cdp_disabled": "smallint",
            "centershift_channel": "int",
            "centershift_endpoint": "string",
            "centershift_inquiry_source_id": "int",
            "centershift_org_id": "string",
            "centershift_signature": "string",
            "corporation_id": "int",
            "domico_client_id": "string",
            "domico_web_service_key": "string",
            "mig_billing_verified": "int",
            "mig_id": "int",
            "mig_location_id": "int",
            "mig_payment_type": "string",
            "mig_time_live": "timestamp",
            "mig_type": "string",
            "mig_user_id": "int",
            "name": "string",
            "pull_promos": "smallint",
            "quikstor_wsdl": "string",
            "rate_type": "string",
            "reservation_type": "string",
            "sitelink_corp_code": "string",
            "source_id": "int",
            "time_created": "timestamp",
            "time_modified": "timestamp"
        },
        "created": "2022-08-10 19:50:44",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_corporations`\n(\n `account_id`  int , `api_password`  string , `api_username`  string , `cdp_disabled`  smallint , `centershift_channel`  int , `centershift_endpoint`  string , `centershift_inquiry_source_id`  int , `centershift_org_id`  string , `centershift_signature`  string , `corporation_id`  int , `domico_client_id`  string , `domico_web_service_key`  string , `mig_billing_verified`  int , `mig_id`  int , `mig_location_id`  int , `mig_payment_type`  string , `mig_time_live`  timestamp , `mig_type`  string , `mig_user_id`  int , `name`  string , `pull_promos`  smallint , `quikstor_wsdl`  string , `rate_type`  string , `reservation_type`  string , `sitelink_corp_code`  string , `source_id`  int , `time_created`  timestamp , `time_modified`  timestamp \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/corporations/2022-08-10/1660179025'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_corporations`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_corporations"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}