title: Loading from AVRO to BigQuery - specify decimal type in the target table
body: <p>I'm using  Google's Python SDK (<a href="https://googleapis.dev/python/bigquery/latest/index.html" rel="nofollow noreferrer">https://googleapis.dev/python/bigquery/latest/index.html</a>) to load AVRO files to BigQuery. Since there is a <code>BigNumeric</code> column in the data I need to specify the <code>--decimal_target_types=BIGNUMERIC</code> flag. Is there a way to do so in a <code>LoadJobConfig</code> object? I haven't been successful so far:</p>
  <pre><code>import os
  from google.cloud import bigquery
  
  os.environ['GOOGLE_APPLICATION_CREDENTIALS'] = './importer_google_credentials.json'
  
  BUCKET_NAME = 'unique-bucket-name'
  FILE_NAME = 'small-data-*.avro'
  
  source_uri = 'gs://{}/{}'.format(BUCKET_NAME, FILE_NAME)
  table_uri = &quot;unique-table-name&quot;
  
  client = bigquery.Client()
  
  job_config = bigquery.LoadJobConfig()
  job_config.use_avro_logical_types = True
  job_config.source_format = bigquery.SourceFormat.AVRO
  job_config.autodetect = True
  job_config.decimal_target_types = &quot;BIGNUMERIC&quot; #throws an AttributeError: Property decimal_target_types is unknown for &lt;class 'google.cloud.bigquery.job.load.LoadJobConfig'&gt;.
  
  load_job = client.load_table_from_uri(
      source_uri, table_uri, job_config=job_config
  )
  load_job.result()  # Waits for the job to complete.
  
  destination_table = client.get_table(table_uri)
  print(&quot;Loaded {} rows.&quot;.format(destination_table.num_rows))
  </code></pre>