Object of type 'datetime' is not JSON serializable Failed.

[fazulk]

Describe the bug

Running a basic query that retreives a row(s) from big query.

These rows contain nested objects which contain a datefield:

select * from db

example row:

"id": "dog", 
"my_object": {
      "domain": "geocities.com",    
      "update_date": "2017-06-02 14:00:00 UTC",     
}

Steps To Reproduce

run select * from db on a table where the row contains a object which contains a date field.

Expected behavior

the row gets retrieved normally.

Screenshots and log output

System information

Which database are you using dbt with?

• postgres
• redshift
• bigquery
• snowflake
• other (specify: ____________)

The output of dbt --version:

DBT Web interface

The operating system you're using:
Win 10

The output of python --version:

Additional context

This same query executes correctly inside Big Query

[beckjake]

Thanks for the bug report @fazulk! I'm pretty sure this is a dupe of #2336 (different type, but otherwise the same problem) and is fixed by #2348 - I can't reproduce it locally with the current dev/octavius-catto.

That means this should be resolved in dbt 0.17.0.

[fazulk]

perfect, thanks!