Skip to content

Instantly share code, notes, and snippets.

@brunoluz
Created September 2, 2023 14:06
Show Gist options
  • Save brunoluz/3e11f60e9329acb28510aec0329fea50 to your computer and use it in GitHub Desktop.
Save brunoluz/3e11f60e9329acb28510aec0329fea50 to your computer and use it in GitHub Desktop.
Obter data de criação de uma tabela glue via Boto3 e athena client
import boto3
# Configure a sessão AWS (substitua com suas próprias credenciais e região)
session = boto3.Session(
aws_access_key_id='[aws access key]',
aws_secret_access_key='[aws secret key]',
region_name='[aws region]'
)
# Crie um cliente Athena
athena_client = session.client('athena')
# Nome do banco de dados e tabela que você deseja consultar
database_name = 'db_teste'
table_name = 'tb_teste'
aws_data_catalog = 'AwsDataCatalog'
table_metadata = athena_client.get_table_metadata(CatalogName=aws_data_catalog, DatabaseName=database_name, TableName=table_name)
create_time = table_metadata['TableMetadata']['CreateTime'].strftime('%d/%m/%Y')
print(f"database: {database_name}, table: {table_name}, create time: {create_time}")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment