Skip to content
Kitbay

querying-data-lake

Apache-2.0Updated on Nov 11, 20263,464GitHub stars

This aws-data-analytics skill runs and manages Amazon Athena SQL queries over the default catalog and federated catalogs such as Glue, S3 Tables and Redshift.

What the skill teaches

This aws-data-analytics skill runs and manages Amazon Athena SQL queries over the default catalog and federated catalogs such as Glue, S3 Tables and Redshift. It checks dependencies, picks the workgroup, resolves which table the user means, reads its schema, builds the query, classifies it before running, and presents results with recovery steps when something fails. It can also report workgroup status and profile a table. Finding assets, auditing the catalog and importing data are handled by sibling skills in the plugin.

Capabilities

  • Run Athena SQL queries
  • Query Glue, S3 Tables and Redshift catalogs
  • Profile a table
  • Check Athena workgroup status