hi... one question I just realize if I update date in my postgres DB doesnt uptade the data in bigquery,

You date column is the cursor field that you used for sync data?

id

yes the cursor field (generally are date types) https://docs.airbyte.com/connector-development/cdk-python/incremental-stream#cursor-fields some cases you can use id, but need to be incremental column type