follow up `prefect-gcp` issue using the `bigquery_...
# prefect-communityb
Bob Colner
05/10/2022, 4:14 PMfollow up
prefect-gcpbigquery_insert_streamTimestampTypeError: Object of type Timestamp is not JSON serializableBob Colner
05/10/2022, 4:16 PMnot a prefect issue -but wondering if there is a good work-around
Bob Colner
05/10/2022, 4:17 PMI guess I just need to pass the
TimestampBob Colner
05/10/2022, 4:20 PMthat worked 😉
a
Andrew Huang
05/10/2022, 4:45 PMis it similar to the one below with the dataset column as Timestamp type?
Copy code
```python
from prefect import flow
from prefect_gcp import GcpCredentials
from prefect_gcp.bigquery import bigquery_insert_stream
from google.cloud.bigquery import SchemaField
@flow
def example_bigquery_insert_stream_flow():
gcp_credentials = GcpCredentials(project="project")
records = [
{"timestamp": "2022-02-03 10:00", "text": "abc", "bool": True},
]
result = bigquery_insert_stream(
dataset="integrations",
table="test_table",
records=records,
gcp_credentials=gcp_credentials
)
return resultb
Bob Colner
05/10/2022, 5:00 PMyes, my BQ schema had a Timestamp col, and I passed a isoformated timestamp string to
biquery_insert_stream5 Views