search

frictionlessdata / tableschema-bigquery-py

Generate BigQuery tables, load and extract data, based on JSON Table Schema descriptors.
MIT License
18 stars 1 forks source link

[#10] Slugify field names before sending to BigQuery #11

Closed vitorbaptista closed 8 years ago

vitorbaptista commented 8 years ago

BigQuery has specific requirements for the field names:

[Required] The field name. The name must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_), and must start with a letter or underscore. The maximum length is 128 characters. https://cloud.google.com/bigquery/docs/reference/v2/tables

So, if the field names aren't compatible with these requirements, we have to convert them before sending to BigQuery.