[Feature] Submit bigframe syntax in python models

[ChenyuLInx]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt-bigquery functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Currently our python model is mainly around spark job.

https://cloud.google.com/python/docs/reference/bigframes/latest
Big frame is a way to read and write data from/to bigquery in the python runtime.
We can add a configuration to the model and support this by changing the template code dbt genarate.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response

[ChenyuLInx]

Related work from @velascoluis
velascoluis@c99830a

[amychen1776]

@ChenyuLInx Curious if you're interested in tackling this work?

[amychen1776]

closing this out for now due to current conversations happening with the BQ team