Error when using --update_at because column has string schema

[ayyoubmaulana]

Is your feature request related to a problem? Please describe. I use data diff to diffing between BigQuery and MySQL, i want to use --update_column flag but my updated_at column in MySQL has string schema so the command throw error like this

Describe the solution you'd like make feature to convert or cast updated_at column from text to date or timestamp

[erezsh]

Can you please include a few sample values from your updated_at column?

[ayyoubmaulana]

this is sample of updated_at column that has string schema

[ayyoubmaul]

any update for this issue ?

[erezsh]

Sorry, no update yet.

[ayyoubmaulana]

@erezsh How to save data-diff output to json ?

[erezsh]

Use --json

[ayyoubmaulana]

@erezsh where is the output will save ?

[ayyoubmaulana]

can i use this command --json '/home/user/dir/output.json' ? @erezsh

[erezsh]

You can do --json > /home/user/dir/output.json

[github-actions[bot]]

This issue has been marked as stale because it has been open for 60 days with no activity. If you would like the issue to remain open, please comment on the issue and it will be added to the triage queue. Otherwise, it will be closed in 7 days.

[github-actions[bot]]

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment and it will be reopened for triage.