René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"dbt integration: Add validation for timestamp field data type","articleBody":"## Context\nPR #5827 added dbt integration that requires a timestamp field for point-in-time correctness.\n\n## Problem\nThe code validates that the timestamp field exists in the model columns but doesn't validate that it's actually a timestamp type. This could lead to runtime errors or incorrect behavior.\n\n## Current Behavior\n```python\n# In dbt_import.py:183-189\nif timestamp_field not in column_names:\n    click.echo(\n        f\"{Fore.YELLOW}Warning: Model '{model.name}' missing timestamp \"\n        f\"field '{timestamp_field}'. Skipping.{Style.RESET_ALL}\"\n    )\n    continue\n```\n\nNo type checking is performed.\n\n## Proposed Solution\nAdd validation that the timestamp field is one of the timestamp types:\n- TIMESTAMP\n- TIMESTAMP_NTZ / TIMESTAMP_LTZ / TIMESTAMP_TZ\n- DATETIME\n- DATE\n\nWarn users if the field exists but has an incompatible type.\n\n## Example\n```python\ntimestamp_col = next((c for c in model.columns if c.name == timestamp_field), None)\nif timestamp_col:\n    normalized_type = timestamp_col.data_type.upper()\n    valid_ts_types = ['TIMESTAMP', 'TIMESTAMP_NTZ', 'TIMESTAMP_LTZ', 'TIMESTAMP_TZ', 'DATETIME', 'DATE']\n    if not any(t in normalized_type for t in valid_ts_types):\n        click.echo(f\"{Fore.YELLOW}Warning: Timestamp field '{timestamp_field}' has type '{timestamp_col.data_type}' which may not be suitable{Style.RESET_ALL}\")\n```\n\n## Related\n- PR #5827","author":{"url":"https://github.com/YassinNouh21","@type":"Person","name":"YassinNouh21"},"datePublished":"2026-01-16T20:12:05.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/5871/feast/issues/5871"}