List true tables only in Athena
I'd like to have a single query which lists all tables in a athena database excluding views.
which returns tables as well as views. I don't want to call the latter followed by a
SHOW VIEWS and then separate those in my code but have that same behavior in one single call.
How can i achieve this?
SHOW TABLES, how about using the information_schema table?
SELECT * FROM information_schema.tables WHERE table_schema = 'database'
If you want to pull views separately, query the
Hi, thanks for your response. That doesn't work.
The view in my database is listed in
information_schema.viewsis empty. How is that possible at all?
Athena views can't include Athena table partitionsasked 5 days ago
Amazon Athena query outputting all columns in the csv as VARCHARsAccepted Answerasked 2 years ago
Shouldn't the AWSReadOnlyAccess permission group allow access to query Athena tablesasked 6 days ago
In-place query of S3 data without provisioning DB or creating tablesasked 4 months ago
Can I use the ID of my saved query to start query execution in Athena SDK?asked a month ago
Unable to read Hive Acid tables in Athena using Athena Hive data connectorasked 25 days ago
INVALID_INPUT in Athena Queryasked 5 months ago
Using Athena to query AWS Lake Formation databaseasked 2 months ago
Invalid S3 request when creating Iceberg tables in Athenaasked 2 months ago
List true tables only in Athenaasked 21 days ago