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?

posta 2 anni fa309 visualizzazioni
1 Risposta
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
ESPERTO
con risposta 2 anni fa
AWS
ESPERTO
verificato 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande