Yes, the BigQuery destination connector can write to a non-partitioned table. The process involves setting up the BigQuery destination connector and then using it to write data to your BigQuery table. However, the specific steps or code to write to a non-partitioned table are not explicitly mentioned in the provided knowledge sources. For detailed instructions, you can refer to the [Airbyte documentation](
https://docs.airbyte.com/integrations/destinations/bigquery). Please note that if you encounter issues with the BigQuery destination connector, such as not applying non-breaking changes on the destination table, it's recommended to use the Destination Bigquery Dv2 instead, as the original connector is outdated and will not receive further updates ([source](
https://github.com/airbytehq/airbyte/issues/31970)). Also, if you're dealing with partitioned tables and encounter issues, it's worth noting that the Source Bigquery is a community connector and it isn’t in the current roadmap for improvements ([source](
https://github.com/airbytehq/airbyte/issues/37025)).