2 Answers
- Newest
- Most votes
- Most comments
0
Hi Milind,
Thank you for your answer, I'm still not clear on how to identify which tables are local or external since this info does not seem to be present in the suggested table. Can you advise me on this?
answered a year ago
0
You can use PG_TABLE_DEF
for listing all tables and its columns by schema. And use STL_QUERYTEXT
to get query text for SQL commands. Building such string parsing functionality can be challenging so one option is to consider monitoring tools from the AWS Marketplace.
Edit: Kindly refer to SVV_EXTERNAL_TABLES
for external tables in Redshift.
answered a year ago
Relevant content
- Accepted Answerasked 4 years ago
- Accepted Answerasked 2 months ago
- Accepted Answerasked a day ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated 2 years ago
Please use the comment button to respond to answers instead of creating a new answer.