By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

strange tables names in stv_tbl_perm

0

Hello, I ran this query

select name from stv_tbl_perm where temp = 1 and db_id=101618

And I got the following results :

271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@4872747@9932208@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@4870525@9932568@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29321685@9570081@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29323365@9570716@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29324913@9571277@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@26377403@8951653@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29323903@9571016@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@25415007@8951653@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29326447@9571976@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29309803@9877604@

These table names are not familiar to me, what do they mean? They are temp table created by users?, they are temp tables created by redshift? this format number:text@number@number@ means something?

Topics
DatabaseAnalytics
Tags
PostgreSQLAmazon Redshift
Language
English
diegoflg
asked 3 years ago399 views
1 Answer
0

those are user temporary tables and NOT created by Redshift. system created table during query processing should show up in STV_TBL_TRANS

profile pictureAWS
EXPERT
MilindOke
answered 3 years ago
AWS
EXPERT
Fabrizio@AWS
reviewed 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content