inspec-gcp icon indicating copy to clipboard operation
inspec-gcp copied to clipboard

Bigquery table schema validation

Open random-coder-111 opened this issue 3 years ago • 0 comments

A way required to check the name, type and mode of the fields in a Bigquery table.

Detailed Description : I require a way to validate the fields in a bigquery table. I already tried using its('schema.fields.name') {should include 'Event_Name'} inside the google_bigquery_table module, but its giving me an error - undefined method - when I tried to run inspec.

Context: I am trying to create a unit testing framework to check the schema of bigquery tables after it is deployed in test region. One of the test cases is checking if the column names are matching with what we have given in the Terraform code. Please let me know how to access the schema components.

random-coder-111 avatar May 16 '21 14:05 random-coder-111