Snowflake Transient Tables Do Not Appear in the DB Code UI

[cjsladek2]

Snowflake Transient Tables Do Not Appear in Dropdown Menu

Reproduction Steps

1. Create a transient table in Snowflake.

CREATE TRANSIENT TABLE my_transient_table (
    id INT,
    user_name VARCHAR(50),
    created_at TIMESTAMP
);

2. Go to the DB Code extension tab in VS Code.
3. Select the appropriate connection, database, and schema.
4. Refresh the connection after creating the table.
5. Observe that the transient table will not appear (regular permanent tables appear normally.).

Expected Behavior

Transient tables should appear alongside tables in the Tables drop-down UI.

Actual Behavior

Transient tables do not appear and are not discoverable in the DB Code UI.

Notes:

• Restarting VS Code and reconnecting does not cause transient tables to appear.
• Transient tables can successfully be created, inserted into, and queried from DB Code. The following queries all work as intended. The only issue is transient tables do not appear as expected in the UI.

CREATE TRANSIENT TABLE my_transient_table (
    id INT,
    user_name VARCHAR(50),
    created_at TIMESTAMP
);

INSERT INTO my_transient_table (id, user_name, created_at)
VALUES (1, 'Alice', CURRENT_TIMESTAMP());

SELECT * FROM my_transient_table;

Environment

• DBCode version: 1.36.1
• VS Code version: 1.129.0 (Universal)
• OS: macOS version 15.6 (Build 24G84)
• Database: Snowflake
• Connection: Direct (username/password)

Error Messages

No error messages appear.

Screenshots

How it looks in Snowflake (DIM_CUSTOMERS and FCT_ORDERS are transient tables):

How it looks in DB Code (transient tables DIM_CUSTOMERS and FCT_ORDERS are missing):

Logs

N/A

Observations

• In Snowflake's INFORMATION_SCHEMA.TABLES, transient tables are classified with a TABLE_TYPE of BASE TABLE, the same table type given to normal tables, and are distinguished only by the IS_TRANSIENT column (which equals 'YES' for transient tables).

INFORMATION_SCHEMA.TABLES:

• When performing a SHOW TABLES; command in Snowflake, the kind column will appear to be TRANSIENT for transient tables, instead of TABLE.
  Example:

• Since DB Code can create, insert into, and query transient tables successfully, but does not list them in the UI, the issue appears to be related to object discovery rather than SQL execution.