TGViewer
There will be no singularity There will be no singularity @nosingularity · 1.96K subscribers
Post #1027 3.14K
SQL-WTF SQL-TIL snowflake edition.

In Snowflake, you can create tables, stages, and functions temporarily.
Temporary objects remain visible in the current session only and disappear after the session ends.

The unusual behavior is that you can create a temporary object with the same name as an already existing object.

So, all existing objects linked with it will be relinked to the "new" temporary object. For e.g. all views dependent on the original table will depend on the temporary table.

More than it!

The permanent table created after the temporary table with the same name stays invisible in the current session too :)
More from @nosingularity
  1. Sep 19, 2026fixupx.com/KaiLentit/status/2100629518784328013/video/1
  2. Sep 18, 2026fixupx.com/iam_zachi/status/2100679300756435135
  3. Aug 30, 2026photo post
  4. Aug 25, 2026fixupx.com/meganreyno/status/2091918430374957416
  5. Aug 3, 2026Вышла новость, что Andy Pavlo приняли на борт Clickhouse Inc. Энди довольно известная фигу…
  6. Jul 23, 2026fixupx.com/unclebobmartin/status/2080257779395154409
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →