For Streaming Inserts we found in the quotas section of the existing account that a default limit is already present but we are not able to access it in the free tier. As per documentation it is mentioned that "Streaming Inserts" would be accessible after enabling billing. Although, we have enabled the billing but API is still throwing the same error when we try inserting data for a table through POST request. Could you please help us with this?
Below is the request and response.
API Request URL : POST https://bigquery.googleapis.com/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables
Request Body:
{
"skipInvalidRows": true,
"ignoreUnknownValues": true,
"rows": [
{
"f": [
{
"v": "{id:340882000000123224728}"
},
{
"v": "[{id:34088200034000020810,value:Vat - 0.0 %}]"
},
{
"v": "true"
},
{
"v": "3408820000wef00405380"
}
]
}
]
}
Response Body:
{
"error": {
"code": 403,
"message": "Access Denied: BigQuery BigQuery: Streaming insert is not allowed in the free tier",
"errors": [
{
"message": "Access Denied: BigQuery BigQuery: Streaming insert is not allowed in the free tier",
"domain": "global",
"reason": "accessDenied"
}
],
"status": "PERMISSION_DENIED"
}
}