admin管理员组

文章数量:1208155

In BigQuery Studio, I can create and select from temporary tables with a qualified name in the form of _SESSION.<my_table_name> just fine, but the same doesn't work from within Dataform pipelines for some reason.

Does anybody know why _SESSION doesn't exist for Dataform's … BigQuery sessions?

In BigQuery Studio, I can create and select from temporary tables with a qualified name in the form of _SESSION.<my_table_name> just fine, but the same doesn't work from within Dataform pipelines for some reason.

Does anybody know why _SESSION doesn't exist for Dataform's … BigQuery sessions?

Share Improve this question asked Jan 20 at 11:24 BigSmokeBigSmoke 4335 silver badges15 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 0

As per the documentation, the _SESSION dataset is not supported in the DataForm.

Tables that you create in Dataform based on the declared data sources or other tables in your SQL workflow. Dataform supports the following table types: table, incremental table, view, and materialized view.

You can try creating the temporary tables with different or unique names instead of using the _session dataset for your requirements.

However, you can file a Feature Request on the issue tracker, if you are interested in the implementation of this feature.

本文标签: