databend Feature: temp table

Feature: temp table

Open balajipro opened this issue 1 year ago • 3 comments

Adding support for snowflake TEMP Table

We would like to know how to create TEMP table in databend similar to snowflake ?

create or replace TRANSIENT table MOCK_1.STUDENT AS SELECT CLAUSE FROM SOURCE_TABLE

Untitled Diagram drawio (1)

Jul 29 '24 09:07 balajipro

Jul 29 '24 11:07 balajipro

The Databend does not currently support Temp Tables.

The tranisent table just a orginal table without time travel.

Jul 30 '24 01:07 wubx

This feature is prioritized in our development plan. cc @dantengsky

Aug 03 '24 01:08 BohuTANG

@BohuTANG Could you please let me know when this feature would be released?

Thanks!

Dec 06 '24 14:12 Shanmugavel-J

I think it works now, see the document: https://docs.databend.com/sql/sql-commands/ddl/table/ddl-create-temp-table

Dec 06 '24 20:12 BohuTANG

@BohuTANG Thanks may i know in which last version (nightly tag) the feature did complete so that we can upgrade to it and keep a note as well?

Dec 07 '24 05:12 Shanmugavel-J

@Shanmugavel-J Introduced or updated: v1.2.666, but to create temporary tables using BendSQL, ensure you are using the latest version of BendSQL.

Dec 07 '24 05:12 BohuTANG

Done https://docs.databend.com/sql/sql-commands/ddl/table/ddl-create-temp-table

Dec 09 '24 08:12 BohuTANG