Auto create table in BigQuery

[Hipska]

Use Case

With some input plugins the metric names and formats are unknown on beforehand, the number of tags and fields can vary over time. Therefore it would be nice if the outputs.bigquery plugin could handle this in a way similar to the outputs.sql plugin.

Expected behavior

Telegraf creates the required table in BigQuery with all the corresponding metric fields and tags just as the sql

Actual behavior

Tables for metrics need to be created on beforehand in BigQuery.

Additional info

Here is a PoC which adds a new BigQuery field on the fly, proving it should be possible.

[powersj]

Hi,

Are you planning on creating a PR with that PoC? Is this something you are able to test as well?

[Hipska]

If my customer wants this feature, I will try to create a PR for it.