Skip to content
Kitbay

connecting-to-data-source

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

A skill from AWS's aws-data-analytics plugin that creates and repairs AWS Glue connections to outside data sources: JDBC databases such as Oracle, SQL Server, PostgreSQL and MySQL, Amazon RDS, Amazon Redshift, Snowflake and BigQuery.

What the skill teaches

A skill from AWS's aws-data-analytics plugin that creates and repairs AWS Glue connections to outside data sources: JDBC databases such as Oracle, SQL Server, PostgreSQL and MySQL, Amazon RDS, Amazon Redshift, Snowflake and BigQuery. It collects hints from the user, looks for existing connections and candidate RDS or Redshift instances, stores credentials in Secrets Manager or uses IAM database authentication, configures VPC networking, creates the connection and tests it first with Glue and then at the database engine, troubleshooting if a test fails. Moving data, creating tables, queries and SaaS sources belong to other skills.

Capabilities

  • Create AWS Glue connections to JDBC databases, Snowflake and BigQuery
  • Register connection credentials in Secrets Manager
  • Configure VPC networking for a connection
  • Test and troubleshoot Glue connections