title: Error "Invalid job id" when DAG is triggered manually from UI using BigQueryInsertJobOperator
body: <p>I am trying to trigger a stored procedure from composer using &quot;BigQueryInsertJobOperator&quot;. The Dag runs fine when triggered as per schedule but it fails with below error when it is triggered manually from Airflow UI.
  <strong>Invalid jobID&quot;airflow_DQ_create_stored_procedure_2021_11_02T01_36_02.229065_00_00_XXXXXXXXXXXXXXXXXX&quot;. Job IDs must be alphanumeric (plus underscores and dashes) and must be at most 1024 characters long.</strong>
  There are alphanumeric and '_' only in the job id created. It is not 1024 characters long.
  Both Manual triggering and scheduled triggering should be possible. Please help!</p>
  <p><strong>EDIT-1:</strong>
  It works if we configure job id from our end. But, it throws error if BQ automatically generates the job id.</p>
  <p>Below is the code snippet:</p>
  <pre><code>from airflow import models
  from airflow.providers.google.cloud.operators.bigquery import BigQueryInsertJobOperator
  
  yesterday = datetime.datetime.combine(
      datetime.datetime.today() - datetime.timedelta(1),
      datetime.datetime.min.time())
  
  
  default_dag_args = {
      'start_date': yesterday
  }
  
  
  
  with models.DAG(
  'DQ_create',
  schedule_interval ='@daily',
  default_args = default_dag_args
  ) as dag:        
  
      Stored_Procedure = BigQueryInsertJobOperator(
          task_id='stored_procedure',
          configuration={
          &quot;query&quot;: {
                  &quot;query&quot;: &quot;CALL `project.dataset.procedure`() &quot;,
                  &quot;useLegacySql&quot;: False,
              }
  },
  )
  
  Stored_Procedure```
  </code></pre>