embucket-labs
embucket-labs copied to clipboard
Error during fetching table metadata in Superset
This is how it works with Snowflake
https://github.com/user-attachments/assets/2a68fdf0-01df-43aa-b087-d9c4c43190de
This is how it works with Embucket
https://github.com/user-attachments/assets/2a04b944-008f-43d0-b6cf-16b379b24e02
This is the log from Embucket during this error:
{"timestamp":"2025-07-25T14:17:34.053980Z","level":"INFO","fields":{"message":"Creating DedicatedExecutor"},"target":"core_executor::dedicated_executor"}
{"timestamp":"2025-07-25T14:17:34.297081Z","level":"INFO","fields":{"message":"Creating DedicatedExecutor"},"target":"core_executor::dedicated_executor"}
{"timestamp":"2025-07-25T14:17:34.493523Z","level":"ERROR","fields":{"error":"DataFusion error: Schema error: No field named ic.is_identity. Valid fields are ic.table_catalog, ic.table_schema, ic.table_name, ic.column_name, ic.column_type, ic.ordinal_position, ic.column_default, ic.is_nullable, ic.data_type, ic.character_maximum_length, ic.character_octet_length, ic.numeric_precision, ic.numeric_precision_radix, ic.numeric_scale, ic.datetime_precision, ic.interval_type."},"target":"core_executor::query"}
{"timestamp":"2025-07-25T14:17:34.493567Z","level":"ERROR","fields":{"error":"DataFusion error: Schema error: No field named ic.is_identity. Valid fields are ic.table_catalog, ic.table_schema, ic.table_name, ic.column_name, ic.column_type, ic.ordinal_position, ic.column_default, ic.is_nullable, ic.data_type, ic.character_maximum_length, ic.character_octet_length, ic.numeric_precision, ic.numeric_precision_radix, ic.numeric_scale, ic.datetime_precision, ic.interval_type."},"target":"core_executor::query"}
{"timestamp":"2025-07-25T14:17:34.493585Z","level":"ERROR","fields":{"error":"DataFusion error: Schema error: No field named ic.is_identity. Valid fields are ic.table_catalog, ic.table_schema, ic.table_name, ic.column_name, ic.column_type, ic.ordinal_position, ic.column_default, ic.is_nullable, ic.data_type, ic.character_maximum_length, ic.character_octet_length, ic.numeric_precision, ic.numeric_precision_radix, ic.numeric_scale, ic.datetime_precision, ic.interval_type."},"target":"core_executor::query"}
{"timestamp":"2025-07-25T14:17:34.587927Z","level":"ERROR","fields":{"error":"DataFusion error: Schema error: No field named ic.is_identity. Valid fields are ic.table_catalog, ic.table_schema, ic.table_name, ic.column_name, ic.column_type, ic.ordinal_position, ic.column_default, ic.is_nullable, ic.data_type, ic.character_maximum_length, ic.character_octet_length, ic.numeric_precision, ic.numeric_precision_radix, ic.numeric_scale, ic.datetime_precision, ic.interval_type."},"target":"core_executor::service"}
{"timestamp":"2025-07-25T14:17:34.587983Z","level":"ERROR","fields":{"error":"DataFusion error: Schema error: No field named ic.is_identity. Valid fields are ic.table_catalog, ic.table_schema, ic.table_name, ic.column_name, ic.column_type, ic.ordinal_position, ic.column_default, ic.is_nullable, ic.data_type, ic.character_maximum_length, ic.character_octet_length, ic.numeric_precision, ic.numeric_precision_radix, ic.numeric_scale, ic.datetime_precision, ic.interval_type."},"target":"api_snowflake_rest::handlers"}
{"timestamp":"2025-07-25T14:17:34.588257Z","level":"INFO","fields":{"message":"close","time.busy":"225µs","time.idle":"11.4µs"},"target":"api_snowflake_rest::error","span":{"error":"Schema error: No field named ic.is_identity. Valid fields are ic.table_catalog, ic.table_schema, ic.table_name, ic.column_name, ic.column_type, ic.ordinal_position, ic.column_default, ic.is_nullable, ic.data_type, ic.character_maximum_length, ic.character_octet_length, ic.numeric_precision, ic.numeric_precision_radix, ic.numeric_scale, ic.datetime_precision, ic.interval_type.","error_stack_trace":"DataFusion error: Schema error: No field named ic.is_identity. Valid fields are ic.table_catalog, ic.table_schema, ic.table_name, ic.column_name, ic.column_type, ic.ordinal_position, ic.column_default, ic.is_nullable, ic.data_type, ic.character_maximum_length, ic.character_octet_length, ic.numeric_precision, ic.numeric_precision_radix, ic.numeric_scale, ic.datetime_precision, ic.interval_type.\n0: <transparent>\n1: DataFusion error: Schema error: No field named ic.is_identity. Valid fields are ic.table_catalog, ic.table_schema, ic.table_name, ic.column_name, ic.column_type, ic.ordinal_position, ic.column_default, ic.is_nullable, ic.data_type, ic.character_maximum_length, ic.character_octet_length, ic.numeric_precision, ic.numeric_precision_radix, ic.numeric_scale, ic.datetime_precision, ic.interval_type., at crates/core-executor/src/query.rs:1712:14\n2: Collection([Diagnostic(Diagnostic { kind: Error, message: \"column 'is_identity' not found in 'ic'\", span: None, notes: [], helps: [] }, SchemaError(FieldNotFound { field: Column { relation: Some(Bare { table: \"ic\" }), name: \"is_identity\" }, valid_fields: [Column { relation: Some(Bare { table: \"ic\" }), name: \"table_catalog\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"table_schema\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"table_name\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_name\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_type\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"ordinal_position\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_default\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"is_nullable\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"data_type\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"character_maximum_length\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"character_octet_length\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_precision\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_precision_radix\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_scale\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"datetime_precision\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"interval_type\" }] }, Some(\"\"))), Diagnostic(Diagnostic { kind: Error, message: \"column 'comment' not found in 'ic'\", span: None, notes: [], helps: [] }, SchemaError(FieldNotFound { field: Column { relation: Some(Bare { table: \"ic\" }), name: \"comment\" }, valid_fields: [Column { relation: Some(Bare { table: \"ic\" }), name: \"table_catalog\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"table_schema\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"table_name\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_name\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_type\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"ordinal_position\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_default\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"is_nullable\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"data_type\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"character_maximum_length\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"character_octet_length\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_precision\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_precision_radix\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_scale\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"datetime_precision\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"interval_type\" }] }, Some(\"\"))), Diagnostic(Diagnostic { kind: Error, message: \"column 'identity_start' not found in 'ic'\", span: None, notes: [], helps: [] }, SchemaError(FieldNotFound { field: Column { relation: Some(Bare { table: \"ic\" }), name: \"identity_start\" }, valid_fields: [Column { relation: Some(Bare { table: \"ic\" }), name: \"table_catalog\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"table_schema\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"table_name\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_name\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_type\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"ordinal_position\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_default\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"is_nullable\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"data_type\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"character_maximum_length\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"character_octet_length\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_precision\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_precision_radix\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_scale\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"datetime_precision\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"interval_type\" }] }, Some(\"\"))), Diagnostic(Diagnostic { kind: Error, message: \"column 'identity_increment' not found in 'ic'\", span: None, notes: [], helps: [] }, SchemaError(FieldNotFound { field: Column { relation: Some(Bare { table: \"ic\" }), name: \"identity_increment\" }, valid_fields: [Column { relation: Some(Bare { table: \"ic\" }), name: \"table_catalog\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"table_schema\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"table_name\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_name\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_type\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"ordinal_position\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"column_default\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"is_nullable\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"data_type\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"character_maximum_length\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"character_octet_length\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_precision\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_precision_radix\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"numeric_scale\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"datetime_precision\" }, Column { relation: Some(Bare { table: \"ic\" }), name: \"interval_type\" }] }, Some(\"\")))])","status_code":200,"name":"api-snowflake-rest::Error::into_response"},"spans":[]}
{"timestamp":"2025-07-25T14:17:37.012352Z","level":"ERROR","fields":{"message":"","name":"BatchSpanProcessor.ExportError","error":"Operation failed: status: Unavailable, message: \"tcp connect error\", details: [], metadata: MetadataMap { headers: {} }"},"target":"opentelemetry_sdk"}
{"timestamp":"2025-07-25T14:17:38.217171Z","level":"ERROR","fields":{"message":"Starting to delete expired for: 2025-07-25 14:17:38.217166117 +00:00:00"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.217215Z","level":"ERROR","fields":{"message":"Deleting expired: 6a692d14-1f7f-4bbb-9527-687118d387ca"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.217858Z","level":"ERROR","fields":{"message":"Deleting expired: 026cba29-7f9c-4f35-9da8-42adb267179a"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.219057Z","level":"ERROR","fields":{"message":"Deleting expired: c3d1a9cb-97cc-4626-a01f-22759900b46f"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.221403Z","level":"ERROR","fields":{"message":"Deleting expired: 58c88de5-7a15-43fe-9763-47df3ab413ba"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.222308Z","level":"ERROR","fields":{"message":"Deleting expired: 9c3756cb-29d8-42d2-ad33-0f6f728296b8"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.222766Z","level":"ERROR","fields":{"message":"Deleting expired: a9b91107-05a7-4033-b497-16b55eb945d7"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.223539Z","level":"ERROR","fields":{"message":"Deleting expired: 91b59cd5-2b52-45fe-bf9d-65e050cf93e7"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.223982Z","level":"ERROR","fields":{"message":"Deleting expired: 92b42c96-8e9e-47be-b4b3-ab2f288d7ac1"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.224465Z","level":"ERROR","fields":{"message":"Deleting expired: 0e21eb4f-7063-4ad3-9179-92bb47029574"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.224839Z","level":"ERROR","fields":{"message":"Deleting expired: 843456f1-134f-428d-bc20-0be3ca72ca59"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.225222Z","level":"ERROR","fields":{"message":"Deleting expired: 7df23115-0787-47f1-b7b4-3145d97ae5a7"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.226067Z","level":"ERROR","fields":{"message":"Deleting expired: 32436830-60fd-4d1d-a7d7-c4264871f32c"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.226487Z","level":"ERROR","fields":{"message":"Deleting expired: 2767fafb-a5b8-42a6-b2f8-36a568cc2cd7"},"target":"api_sessions::session"}
{"timestamp":"2025-07-25T14:17:38.226878Z","level":"ERROR","fields":{"message":"Deleting expired: 62eba6f3-a7d5-49a4-8e66-17540a1f8a68"},"target":"api_sessions::session"}