red-pizza-28006
09/04/2022, 8:10 PM[2022-09-04, 01:37:48 UTC] {{cursor.py:710}} INFO - query: [SELECT -- access_history.query_id, -- only for debugging purposes access_history...]
[2022-09-04, 01:44:37 UTC] {{cursor.py:734}} INFO - query execution done
[2022-09-04, 01:44:40 UTC] {{stateful_ingestion_base.py:93}} WARNING - usage => Failed to parse usage line {'query_start_time': datetime.datetime(2022, 9, 4, 1, 30, 6, tzinfo=datetime.timezone.utc), 'query_text': "select TABLE_NAME, TIMEDIFF('hour', LAST_ALTERED, CURRENT_TIMESTAMP()) AS T\nfrom SUMUP_DWH_PROD.INFORMATION_SCHEMA.TABLES\nwhere 1=1\nAND TABLE_SCHEMA = 'SRC_PLUGGER'\nHAVING T > 6", 'query_type': 'SELECT', 'rows_inserted': 0, 'rows_updated': 0, 'rows_deleted': 0, 'base_objects_accessed': [], 'direct_objects_accessed': [{'columns': [{'columnName': 'TABLE_NAME'}, {'columnName': 'TABLE_SCHEMA'}, {'columnName': 'LAST_ALTERED'}], 'objectDomain': 'View', 'objectName': 'INFORMATION_SCHEMA.TABLES'}], 'user_name': 'ADWH_DATA_CATALOG', 'first_name': None, 'last_name': None, 'display_name': 'DATA_CATALOG', 'email': '<mailto:DATA.CATALOG@sumup.com|DATA.CATALOG@sumup.com>', 'role_name': 'ACCOUNT_MONITOR_USAGE'}, 4 validation errors for SnowflakeJoinedAccessEvent
direct_objects_accessed -> 0 -> columns -> 0
__init__() missing 1 required positional argument: 'columnId' (type=type_error)
direct_objects_accessed -> 0 -> columns -> 1
__init__() missing 1 required positional argument: 'columnId' (type=type_error)
direct_objects_accessed -> 0 -> columns -> 2
__init__() missing 1 required positional argument: 'columnId' (type=type_error)
direct_objects_accessed -> 0 -> objectId
field required (type=value_error.missing)hundreds-photographer-13496
09/07/2022, 12:44 PMred-pizza-28006
09/08/2022, 3:18 PMred-pizza-28006
09/08/2022, 3:18 PM