Constantin Lungudatawise.dev·Feb 16, 2024Watch out when using SAFE_CAST in BigQueryHere's an interesting situation I've seen with BigQuery. Say a source system provides JSON events with timestamps at microsecond grain (6 decimals, so something like 2024-01-01 14:00:00.123456). This is cast using SAFE_CAST into a proper TIMESTAMP. A...36 readsPractical BigQuerybigqueryAdd a thoughtful commentNo comments yetBe the first to start the conversation.