strange tables names in stv_tbl_perm
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?
those are user temporary tables and NOT created by Redshift. system created table during query processing should show up in STV_TBL_TRANS
Relevant questions
How can I track down RedShift throwing errors when aggregating on an otherwise functioning query involving CTEs and UNIONS?
asked 9 days agoHow do I filter query results using the WHERE keyword with Redshift python connector?
Accepted Answerasked 2 months agoHow do I do single search query?
asked 5 months agostrange tables names in stv_tbl_perm
asked 4 months agoINVALID_INPUT in Athena Query
asked 3 months agoI cannot use current_date + interval in Athena boto3 query in Lambda
Accepted Answerasked 3 months agoHow can I use API to get the tel number of customers from AWS Connect
Accepted Answerasked 2 years agoImporting Datasets into AWS Glue DataBrew from PostgreSQL tables with Case Sensitive names
asked 4 months agoCSV crawler tables name
asked 4 months agowhere does this vpc endpoint coming from
asked 4 months ago