Schema Info

Schema Name: sfdl_prod_csv.salesforce_login_histories

created: 2025-01-09 16:11:59
disabled: False
format: raw
id: 3449
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_csv",
    "table": "salesforce_login_histories"
}

type: csv

Schema Versions: 15

Version 1718104

created: 2026-04-17 07:06:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-17/1776427517'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-17/1776427517
id: 1718104
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 162173075
updated: 2026-04-17 07:07:12

Version 1716869

created: 2026-04-16 07:06:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-16/1776341116'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-16/1776341116
id: 1716869
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 162117349
updated: 2026-04-16 07:07:01

Version 1715646

created: 2026-04-15 07:07:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-15/1776254774'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-15/1776254774
id: 1715646
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 162061783
updated: 2026-04-15 07:08:08

Version 1714484

created: 2026-04-14 07:07:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-14/1776168346'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-14/1776168346
id: 1714484
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 162006400
updated: 2026-04-14 07:07:36

Version 1713218

created: 2026-04-13 07:05:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-13/1776081888'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-13/1776081888
id: 1713218
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 161948293
updated: 2026-04-13 07:05:23

Version 1712042

created: 2026-04-12 07:07:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-12/1775995620'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-12/1775995620
id: 1712042
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 161899521
updated: 2026-04-12 07:07:24

Version 1710835

created: 2026-04-11 07:05:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-11/1775909080'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-11/1775909080
id: 1710835
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 161846843
updated: 2026-04-11 07:05:14

Version 1709683

created: 2026-04-10 07:06:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-10/1775822725'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-10/1775822725
id: 1709683
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 161792083
updated: 2026-04-10 07:06:58

Version 1708515

created: 2026-04-09 07:06:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-09/1775736300'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-09/1775736300
id: 1708515
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 161736245
updated: 2026-04-09 07:06:15

Version 1707329

created: 2026-04-08 07:06:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-08/1775649897'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-08/1775649897
id: 1707329
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 161681385
updated: 2026-04-08 07:06:23

Version 1706141

created: 2026-04-07 07:06:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-07/1775563489'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-07/1775563489
id: 1706141
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 161625177
updated: 2026-04-07 07:06:22

Version 1704916

created: 2026-04-06 07:08:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-06/1775477122'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-06/1775477122
id: 1704916
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 161567325
updated: 2026-04-06 07:08:30

Version 1703676

created: 2026-04-05 07:04:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-05/1775390651'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-05/1775390651
id: 1703676
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 161519956
updated: 2026-04-05 07:04:39

Version 1702531

created: 2026-04-04 07:06:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-04/1775304388'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-04/1775304388
id: 1702531
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 161466400
updated: 2026-04-04 07:07:03

Version 1701357

created: 2026-04-03 07:05:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-03/1775217865'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
]

hive_path: s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-03/1775217865
id: 1701357
processed: 1

raw_data:

{
    "ApiType": 18,
    "ApiVersion": 19,
    "Application": 16,
    "AuthMethodReference": 21,
    "AuthenticationServiceId": 7,
    "Browser": 13,
    "CipherSuite": 10,
    "ClientVersion": 17,
    "CountryIso": 20,
    "ForwardedForIp": 23,
    "Id": 0,
    "LoginGeoId": 8,
    "LoginSubType": 22,
    "LoginTime": 2,
    "LoginType": 3,
    "LoginUrl": 5,
    "NetworkId": 6,
    "OptionsIsGet": 11,
    "OptionsIsPost": 12,
    "Platform": 14,
    "SourceIp": 4,
    "Status": 15,
    "TlsProtocol": 9,
    "UserId": 1
}

schema_attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

schema_name_id: 3449
schema_scan_id: 161408564
updated: 2026-04-03 07:05:47

Schema Scans: 15

Last at 2026-04-17 07:06:57

Scan 162173075

duration: 0:00:14.895817

exit_message:

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

id: 162173075

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-17/1776427517",
        "key": "raw/login_histories/2026-04-17/1776427517/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5628395003730814557,
        "service_name": "drive-thru",
        "span_id": 15759473846199587562,
        "trace_id": 5972134475176954102
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-17 07:06:57
success: True
trace_id: 5972134475176954102

Scan 162117349

duration: 0:00:12.367159

exit_message:

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

id: 162117349

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-16/1776341116",
        "key": "raw/login_histories/2026-04-16/1776341116/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8666482659459473645,
        "service_name": "drive-thru",
        "span_id": 14655731534667245887,
        "trace_id": 15254181176071909830
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-16 07:06:48
success: True
trace_id: 15254181176071909830

Scan 162061783

duration: 0:00:14.732844

exit_message:

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

id: 162061783

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-15/1776254774",
        "key": "raw/login_histories/2026-04-15/1776254774/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16930312196748206481,
        "service_name": "drive-thru",
        "span_id": 14880900321607831966,
        "trace_id": 1373855631514010200
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-15 07:07:53
success: True
trace_id: 1373855631514010200

Scan 162006400

duration: 0:00:14.838713

exit_message:

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

id: 162006400

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-14/1776168346",
        "key": "raw/login_histories/2026-04-14/1776168346/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17615720660277676611,
        "service_name": "drive-thru",
        "span_id": 9755751261139216235,
        "trace_id": 10994682476464272898
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-14 07:07:22
success: True
trace_id: 10994682476464272898

Scan 161948293

duration: 0:00:14.812288

exit_message:

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

id: 161948293

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-13/1776081888",
        "key": "raw/login_histories/2026-04-13/1776081888/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14666816344990624137,
        "service_name": "drive-thru",
        "span_id": 9263700830968383678,
        "trace_id": 3847045959832101632
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-13 07:05:09
success: True
trace_id: 3847045959832101632

Scan 161899521

duration: 0:00:12.258446

exit_message:

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

id: 161899521

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-12/1775995620",
        "key": "raw/login_histories/2026-04-12/1775995620/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13041800895565907652,
        "service_name": "drive-thru",
        "span_id": 13193849280643394487,
        "trace_id": 14373091638193892501
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-12 07:07:12
success: True
trace_id: 14373091638193892501

Scan 161846843

duration: 0:00:12.142646

exit_message:

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

id: 161846843

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-11/1775909080",
        "key": "raw/login_histories/2026-04-11/1775909080/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6339696712082592293,
        "service_name": "drive-thru",
        "span_id": 13237550173004350559,
        "trace_id": 9178557071680556220
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-11 07:05:02
success: True
trace_id: 9178557071680556220

Scan 161792083

duration: 0:00:12.388548

exit_message:

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

id: 161792083

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-10/1775822725",
        "key": "raw/login_histories/2026-04-10/1775822725/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8778952457891953861,
        "service_name": "drive-thru",
        "span_id": 3355912369660339895,
        "trace_id": 7445712073243209750
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-10 07:06:45
success: True
trace_id: 7445712073243209750

Scan 161736245

duration: 0:00:12.320844

exit_message:

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

id: 161736245

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-09/1775736300",
        "key": "raw/login_histories/2026-04-09/1775736300/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14371237093682290625,
        "service_name": "drive-thru",
        "span_id": 2241759116913340211,
        "trace_id": 12610723354347710837
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-09 07:06:03
success: True
trace_id: 12610723354347710837

Scan 161681385

duration: 0:00:12.285360

exit_message:

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

id: 161681385

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-08/1775649897",
        "key": "raw/login_histories/2026-04-08/1775649897/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17601587033638121955,
        "service_name": "drive-thru",
        "span_id": 4338627777350332014,
        "trace_id": 14967868896762377561
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-08 07:06:11
success: True
trace_id: 14967868896762377561

Scan 161625177

duration: 0:00:12.274038

exit_message:

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

id: 161625177

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-07/1775563489",
        "key": "raw/login_histories/2026-04-07/1775563489/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5785488354582588588,
        "service_name": "drive-thru",
        "span_id": 14266090250191145805,
        "trace_id": 14903488317625074298
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-07 07:06:10
success: True
trace_id: 14903488317625074298

Scan 161567325

duration: 0:00:14.951817

exit_message:

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

id: 161567325

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-06/1775477122",
        "key": "raw/login_histories/2026-04-06/1775477122/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7610134932956236362,
        "service_name": "drive-thru",
        "span_id": 9682938773390121326,
        "trace_id": 15946298925786461728
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-06 07:08:15
success: True
trace_id: 15946298925786461728

Scan 161519956

duration: 0:00:14.776973

exit_message:

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

id: 161519956

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-05/1775390651",
        "key": "raw/login_histories/2026-04-05/1775390651/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15936724536568870224,
        "service_name": "drive-thru",
        "span_id": 203299828729146437,
        "trace_id": 10477592379541743552
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-05 07:04:25
success: True
trace_id: 10477592379541743552

Scan 161466400

duration: 0:00:14.700614

exit_message:

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

id: 161466400

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-04/1775304388",
        "key": "raw/login_histories/2026-04-04/1775304388/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3074003465326026475,
        "service_name": "drive-thru",
        "span_id": 15524092382682342518,
        "trace_id": 405227639540364186
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-04 07:06:49
success: True
trace_id: 405227639540364186

Scan 161408564

duration: 0:00:14.793736

exit_message:

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

id: 161408564

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-03/1775217865",
        "key": "raw/login_histories/2026-04-03/1775217865/login_histories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_login_histories",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15352011714349595654,
        "service_name": "drive-thru",
        "span_id": 1934102361714178475,
        "trace_id": 2841331690997538434
    }
}

running: False
schema_name_id: 3449
start_time: 2026-04-03 07:05:32
success: True
trace_id: 2841331690997538434

Partitions:

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

Schema:

attributes:

{
    "ApiType": "string",
    "ApiVersion": "string",
    "Application": "string",
    "AuthMethodReference": "string",
    "AuthenticationServiceId": "string",
    "Browser": "string",
    "CipherSuite": "string",
    "ClientVersion": "string",
    "CountryIso": "string",
    "ForwardedForIp": "string",
    "Id": "string",
    "LoginGeoId": "string",
    "LoginSubType": "string",
    "LoginTime": "string",
    "LoginType": "string",
    "LoginUrl": "string",
    "NetworkId": "string",
    "OptionsIsGet": "string",
    "OptionsIsPost": "string",
    "Platform": "string",
    "SourceIp": "string",
    "Status": "string",
    "TlsProtocol": "string",
    "UserId": "string"
}

created: 2026-04-17 07:06:58

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-17/1776427517'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2025-01-09 16:11:59",
        "disabled": false,
        "format": "raw",
        "id": 3449,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_login_histories"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ApiType": "string",
            "ApiVersion": "string",
            "Application": "string",
            "AuthMethodReference": "string",
            "AuthenticationServiceId": "string",
            "Browser": "string",
            "CipherSuite": "string",
            "ClientVersion": "string",
            "CountryIso": "string",
            "ForwardedForIp": "string",
            "Id": "string",
            "LoginGeoId": "string",
            "LoginSubType": "string",
            "LoginTime": "string",
            "LoginType": "string",
            "LoginUrl": "string",
            "NetworkId": "string",
            "OptionsIsGet": "string",
            "OptionsIsPost": "string",
            "Platform": "string",
            "SourceIp": "string",
            "Status": "string",
            "TlsProtocol": "string",
            "UserId": "string"
        },
        "created": "2026-04-17 07:06:58",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_login_histories`\n(\n `Id`  string , `UserId`  string , `LoginTime`  string , `LoginType`  string , `SourceIp`  string , `LoginUrl`  string , `NetworkId`  string , `AuthenticationServiceId`  string , `LoginGeoId`  string , `TlsProtocol`  string , `CipherSuite`  string , `OptionsIsGet`  string , `OptionsIsPost`  string , `Browser`  string , `Platform`  string , `Status`  string , `Application`  string , `ClientVersion`  string , `ApiType`  string , `ApiVersion`  string , `CountryIso`  string , `AuthMethodReference`  string , `LoginSubType`  string , `ForwardedForIp`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-prod/raw/login_histories/2026-04-17/1776427517'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_login_histories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_login_histories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}