Great Expectations does not currently provide a configuration option to control the expiration of the temporary table it creates in BigQuery.
You can update the table after it is created, as described in BigQuery documentation: https://cloud.google.com/bigquery/docs/managing-tables#updating_a_tables_expiration_time