By using AWS re:Post, you agree to the Terms of Use
/strange tables names in stv_tbl_perm/

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?

asked 4 months ago8 views
1 Answers
0

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

answered 3 months ago
EXPERT
reviewed a month 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