title: Avro file not inserting rows into BigQuery
body: <p>I'm trying to insert data from an avro file into BQ but I've ran into an issue where the script runs but the rows added into BQ are all null. The Avro files I have all have correct data in them but for some reason they aren't passing into BQ.</p>
  <p>Here is my code:</p>
  <pre><code>def load_from_gcs(source_uris, destination_table):
      client = bigquery.Client(
          project=GCP_PROJECT,
          credentials=service_account.Credentials.from_service_account_file(
              GCP_CREDENTIALS_PATH
          )
      )
  
      load_config = bigquery.LoadJobConfig(
          # autodetect=True,
          create_disposition='CREATE_IF_NEEDED',
          source_format='AVRO',
          write_disposition='WRITE_APPEND',
          schema = [
              bigquery.SchemaField(&quot;childId&quot;,&quot;INTEGER&quot;,&quot;NULLABLE&quot;),
              bigquery.SchemaField(&quot;userIdTrace&quot;,&quot;INTEGER&quot;,&quot;NULLABLE&quot;),
              bigquery.SchemaField(&quot;amount&quot;,&quot;NUMERIC&quot;,&quot;NULLABLE&quot;),
              bigquery.SchemaField(&quot;day&quot;,&quot;INTEGER&quot;,&quot;NULLABLE&quot;),
              bigquery.SchemaField(&quot;recurrence&quot;,&quot;STRING&quot;,&quot;NULLABLE&quot;),
              bigquery.SchemaField(&quot;lastPayDate&quot;,&quot;DATETIME&quot;,&quot;NULLABLE&quot;),
              bigquery.SchemaField(&quot;currentPayDate&quot;,&quot;DATETIME&quot;,&quot;NULLABLE&quot;),
              bigquery.SchemaField(&quot;nextPayDate&quot;,&quot;DATETIME&quot;,&quot;NULLABLE&quot;),
              bigquery.SchemaField(&quot;status&quot;,&quot;STRING&quot;,&quot;NULLABLE&quot;),
              bigquery.SchemaField(&quot;created&quot;,&quot;DATETIME&quot;,&quot;NULLABLE&quot;),
              bigquery.SchemaField(&quot;modified&quot;,&quot;TIMESTAMP&quot;,&quot;NULLABLE&quot;)
          ]
      )
  
      load_job = client.load_table_from_uri(
          source_uris=source_uris,
          destination=destination_table,
          job_config=load_config
      )
  
      load_job.result()
      destination_table = client.get_table(destination_table)
      print(&quot;Loaded {} rows.&quot;.format(destination_table.num_rows))
  
  source_uri = [DEV_AVRO_FILEPATH]
  table = BQ_TABLE
  load_from_gcs(source_uri,table)
  </code></pre>