dataform Provide support for creating temp tables ( `CREATE TEMP TABLE` ) in big query using Dataform

Provide support for creating temp tables ( CREATE TEMP TABLE ) in big query using Dataform. Dataform as of now don't have any provision in config to create temporary tables.

Oct 29 '22 12:10 Rstar1998

Can you describe the use case?

Temporary tables only persist within the context of a single script, so I'm not sure how this would be useful.

Oct 31 '22 09:10 BenBirt

@BenBirt In My usecase I create a temp table and using that temp table I insert and update records in other table.

Oct 31 '22 16:10 Rstar1998

@Rstar1998 could this potentially be expressed as an incremental table?

https://docs.dataform.co/guides/datasets/incremental

Nov 01 '22 09:11 BenBirt

I've run into requests for temporary tables several times recently, and every one of them has been better solved by using incremental tables.

Please re-open this issue with more information, if you've got examples where this isn't the case!

Apr 02 '24 14:04 Ekrekr