Pular para o conteúdo
Kitbay
SkillOficial

connecting-to-data-source

Apache-2.0Atualizado em 11 de nov. de 20263.464Estrelas no GitHub

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.

O que a skill ensina

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.

O que faz

  • 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