Schema Info

Schema Name: sfdl_dev_rds.sparefoot_account_modifiers

created: 2022-06-03 21:29:44
disabled: False
format: raw
id: 1810
is_partitioned: False
is_schema_datatyped: False

name:

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

type: rds

Schema Versions: 15

Version 4689872

created: 2022-08-10 19:51:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-08-10/1660179050'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-08-10/1660179050
id: 4689872
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1810
schema_scan_id: 5964986
updated: 2022-08-10 19:51:25

Version 4689312

created: 2022-06-07 17:21:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-07/1654640439'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-07/1654640439
id: 4689312
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1810
schema_scan_id: 5931219
updated: 2022-06-07 17:21:13

Version 4689310

created: 2022-06-07 17:04:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-07/1654639423'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-07/1654639423
id: 4689310
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1810
schema_scan_id: 5931215
updated: 2022-06-07 17:04:32

Version 4689309

created: 2022-06-07 17:00:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-07/1654639191'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-07/1654639191
id: 4689309
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1810
schema_scan_id: 5931214
updated: 2022-06-07 17:00:36

Version 4689308

created: 2022-06-07 16:51:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-07/1654638672'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-07/1654638672
id: 4689308
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1810
schema_scan_id: 5931177
updated: 2022-06-07 16:51:37

Version 4689307

created: 2022-06-07 16:45:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-07/1654638315'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-07/1654638315
id: 4689307
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1810
schema_scan_id: 5931120
updated: 2022-06-07 16:45:55

Version 4689306

created: 2022-06-07 16:43:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-07/1654638219'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-07/1654638219
id: 4689306
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1810
schema_scan_id: 5931109
updated: 2022-06-07 16:43:59

Version 4689305

created: 2022-06-07 16:37:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-07/1654637787'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-07/1654637787
id: 4689305
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1810
schema_scan_id: 5931079
updated: 2022-06-07 16:38:05

Version 4689303

created: 2022-06-07 16:10:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-07/1654636196'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-07/1654636196
id: 4689303
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1810
schema_scan_id: 5931072
updated: 2022-06-07 16:10:24

Version 4689293

created: 2022-06-07 12:24:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-07/1654622641'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-07/1654622641
id: 4689293
processed: 1

raw_data:

{
    "account_id": "int32",
    "active": "int16",
    "created_at": "timestamp[ns]",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp[ns]"
}

schema_attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

schema_name_id: 1810
schema_scan_id: 5930710
updated: 2022-06-07 12:24:23

Version 4689279

created: 2022-06-07 10:30:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  bigint , `active`  bigint , `created_at`  string , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-07/1654615810'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-07/1654615810
id: 4689279
processed: 1

raw_data:

{
    "account_id": "int64",
    "active": "int64",
    "created_at": "string",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "string"
}

schema_attributes:

{
    "account_id": "bigint",
    "active": "bigint",
    "created_at": "string",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "string"
}

schema_name_id: 1810
schema_scan_id: 5930603
updated: 2022-06-07 10:30:40

Version 4689269

created: 2022-06-06 17:56:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  bigint , `active`  bigint , `created_at`  string , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-06/1654556167'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-06/1654556167
id: 4689269
processed: 1

raw_data:

{
    "account_id": "int64",
    "active": "int64",
    "created_at": "string",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "string"
}

schema_attributes:

{
    "account_id": "bigint",
    "active": "bigint",
    "created_at": "string",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "string"
}

schema_name_id: 1810
schema_scan_id: 5930350
updated: 2022-06-06 17:56:26

Version 4689268

created: 2022-06-06 17:56:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  bigint , `active`  bigint , `created_at`  string , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-06/1654556137'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-06/1654556137
id: 4689268
processed: 1

raw_data:

{
    "account_id": "int64",
    "active": "int64",
    "created_at": "string",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "string"
}

schema_attributes:

{
    "account_id": "bigint",
    "active": "bigint",
    "created_at": "string",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "string"
}

schema_name_id: 1810
schema_scan_id: 5930349
updated: 2022-06-06 17:56:12

Version 4689267

created: 2022-06-06 17:25:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  bigint , `active`  bigint , `created_at`  string , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-06/1654554292'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-06/1654554292
id: 4689267
processed: 1

raw_data:

{
    "account_id": "int64",
    "active": "int64",
    "created_at": "string",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "string"
}

schema_attributes:

{
    "account_id": "bigint",
    "active": "bigint",
    "created_at": "string",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "string"
}

schema_name_id: 1810
schema_scan_id: 5930342
updated: 2022-06-06 17:25:14

Version 4689266

created: 2022-06-06 14:19:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  bigint , `active`  bigint , `created_at`  string , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-06-06/1654543147'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/account_modifiers/2022-06-06/1654543147
id: 4689266
processed: 1

raw_data:

{
    "account_id": "int64",
    "active": "int64",
    "created_at": "string",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "string"
}

schema_attributes:

{
    "account_id": "bigint",
    "active": "bigint",
    "created_at": "string",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "string"
}

schema_name_id: 1810
schema_scan_id: 5930155
updated: 2022-06-06 14:19:30

Schema Scans: 15

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

Scan 5964986

duration: 0:00:29.849579

exit_message:

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

id: 5964986

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/account_modifiers/2022-08-10/1660179050",
        "key": "raw/account_modifiers/2022-08-10/1660179050/account_modifiers.parquet.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 8537835872147772068,
        "service_name": "sparefoot",
        "span_id": 5221746625093703492,
        "trace_id": 8537835872147772068
    }
}

running: False
schema_name_id: 1810
start_time: 2022-08-10 19:50:58
success: True
trace_id: 8537835872147772068

Scan 5931219

duration: 0:00:14.259954

exit_message:

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

id: 5931219

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/account_modifiers/2022-06-07/1654640439",
        "key": "raw/account_modifiers/2022-06-07/1654640439/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 5994088406643734905,
        "service_name": "sparefoot",
        "span_id": 5468372512162621778,
        "trace_id": 5994088406643734905
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-07 17:21:01
success: True
trace_id: 5994088406643734905

Scan 5931215

duration: 0:00:19.469986

exit_message:

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

id: 5931215

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/account_modifiers/2022-06-07/1654639423",
        "key": "raw/account_modifiers/2022-06-07/1654639423/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3913790667152742903,
        "service_name": "sparefoot",
        "span_id": 168078008926585125,
        "trace_id": 3913790667152742903
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-07 17:04:15
success: True
trace_id: 3913790667152742903

Scan 5931214

duration: 0:00:14.205677

exit_message:

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

id: 5931214

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/account_modifiers/2022-06-07/1654639191",
        "key": "raw/account_modifiers/2022-06-07/1654639191/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3913790667152742903,
        "service_name": "sparefoot",
        "span_id": 649796125304501264,
        "trace_id": 3913790667152742903
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-07 17:00:24
success: True
trace_id: 3913790667152742903

Scan 5931177

duration: 0:00:19.530087

exit_message:

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

id: 5931177

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/account_modifiers/2022-06-07/1654638672",
        "key": "raw/account_modifiers/2022-06-07/1654638672/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1536178184388835320,
        "service_name": "sparefoot",
        "span_id": 18295592788640132337,
        "trace_id": 1536178184388835320
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-07 16:51:20
success: True
trace_id: 1536178184388835320

Scan 5931120

duration: 0:00:29.827282

exit_message:

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

id: 5931120

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/account_modifiers/2022-06-07/1654638315",
        "key": "raw/account_modifiers/2022-06-07/1654638315/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 4233447948537957604,
        "service_name": "sparefoot",
        "span_id": 7233910229269746822,
        "trace_id": 4233447948537957604
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-07 16:45:28
success: True
trace_id: 4233447948537957604

Scan 5931109

duration: 0:00:14.197388

exit_message:

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

id: 5931109

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/account_modifiers/2022-06-07/1654638219",
        "key": "raw/account_modifiers/2022-06-07/1654638219/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16959667148371881771,
        "service_name": "sparefoot",
        "span_id": 12459856835947607142,
        "trace_id": 16959667148371881771
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-07 16:43:48
success: True
trace_id: 16959667148371881771

Scan 5931079

duration: 0:01:32.815509

exit_message:

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

id: 5931079

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/account_modifiers/2022-06-07/1654637787",
        "key": "raw/account_modifiers/2022-06-07/1654637787/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 675228263004452124,
        "service_name": "sparefoot",
        "span_id": 3291838411855512580,
        "trace_id": 675228263004452124
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-07 16:36:35
success: True
trace_id: 675228263004452124

Scan 5931072

duration: 0:00:14.166644

exit_message:

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

id: 5931072

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/account_modifiers/2022-06-07/1654636196",
        "key": "raw/account_modifiers/2022-06-07/1654636196/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 9436989909177478331,
        "service_name": "sparefoot",
        "span_id": 13414089321621613889,
        "trace_id": 9436989909177478331
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-07 16:10:13
success: True
trace_id: 9436989909177478331

Scan 5930710

duration: 0:00:14.289525

exit_message:

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

id: 5930710

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/account_modifiers/2022-06-07/1654622641",
        "key": "raw/account_modifiers/2022-06-07/1654622641/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16763257629809614944,
        "service_name": "sparefoot",
        "span_id": 5808248351640895829,
        "trace_id": 16763257629809614944
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-07 12:24:11
success: True
trace_id: 16763257629809614944

Scan 5930603

duration: 0:00:19.515299

exit_message:

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

id: 5930603

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/account_modifiers/2022-06-07/1654615810",
        "key": "raw/account_modifiers/2022-06-07/1654615810/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 16763257629809614944,
        "service_name": "sparefoot",
        "span_id": 3400152263869784770,
        "trace_id": 16763257629809614944
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-07 10:30:23
success: True
trace_id: 16763257629809614944

Scan 5930350

duration: 0:00:14.385755

exit_message:

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

id: 5930350

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/account_modifiers/2022-06-06/1654556167",
        "key": "raw/account_modifiers/2022-06-06/1654556167/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14351753977314188705,
        "service_name": "sparefoot",
        "span_id": 15318626623492214989,
        "trace_id": 14351753977314188705
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-06 17:56:14
success: True
trace_id: 14351753977314188705

Scan 5930349

duration: 0:00:14.264115

exit_message:

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

id: 5930349

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/account_modifiers/2022-06-06/1654556137",
        "key": "raw/account_modifiers/2022-06-06/1654556137/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14351753977314188705,
        "service_name": "sparefoot",
        "span_id": 15821249739857343543,
        "trace_id": 14351753977314188705
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-06 17:56:00
success: True
trace_id: 14351753977314188705

Scan 5930342

duration: 0:00:14.348665

exit_message:

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

id: 5930342

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/account_modifiers/2022-06-06/1654554292",
        "key": "raw/account_modifiers/2022-06-06/1654554292/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14351753977314188705,
        "service_name": "sparefoot",
        "span_id": 14581526472280007914,
        "trace_id": 14351753977314188705
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-06 17:25:02
success: True
trace_id: 14351753977314188705

Scan 5930155

duration: 0:00:14.491762

exit_message:

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

id: 5930155

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/account_modifiers/2022-06-06/1654543147",
        "key": "raw/account_modifiers/2022-06-06/1654543147/account_modifiers_8.parquet"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_account_modifiers",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 14351753977314188705,
        "service_name": "sparefoot",
        "span_id": 11587687437904804241,
        "trace_id": 14351753977314188705
    }
}

running: False
schema_name_id: 1810
start_time: 2022-06-06 14:19:18
success: True
trace_id: 14351753977314188705

Partitions:

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

Schema:

attributes:

{
    "account_id": "int",
    "active": "smallint",
    "created_at": "timestamp",
    "modifier_name": "string",
    "modifier_value": "double",
    "updated_at": "timestamp"
}

created: 2022-08-10 19:51:14

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-08-10/1660179050'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
}

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 21:29:44",
        "disabled": false,
        "format": "raw",
        "id": 1810,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_rds",
            "table": "sparefoot_account_modifiers"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "account_id": "int",
            "active": "smallint",
            "created_at": "timestamp",
            "modifier_name": "string",
            "modifier_value": "double",
            "updated_at": "timestamp"
        },
        "created": "2022-08-10 19:51:14",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_account_modifiers`\n(\n `account_id`  int , `active`  smallint , `created_at`  timestamp , `modifier_name`  string , `modifier_value`  double , `updated_at`  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/account_modifiers/2022-08-10/1660179050'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_account_modifiers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_account_modifiers"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}