使用Python从Quicksight仪表板提取CSV

pip install boto3 pandas

import boto3
import pandas as pd

session = boto3.Session(
    aws_access_key_id='YOUR_ACCESS_KEY',
    aws_secret_access_key='YOUR_SECRET_KEY',
    region_name='YOUR_REGION'
)

quicksight_client = session.client('quicksight')

response = quicksight_client.describe_dashboard(
    AwsAccountId='YOUR_ACCOUNT_ID',
    DashboardId='YOUR_DASHBOARD_ID'
)

dataset_id = response['Dashboard']['Version']['DataSetArns'][0].split('/')[-1]

response = quicksight_client.get_data_set(
    AwsAccountId='YOUR_ACCOUNT_ID',
    DataSetId=dataset_id
)

data_source_id = response['DataSet']['PhysicalTableMap']['string']['RelationalTable']['DataSourceArn'].split('/')[-1]

response = quicksight_client.get_data_source(
    AwsAccountId='YOUR_ACCOUNT_ID',
    DataSourceId=data_source_id
)

connection_info = response['DataSource']['DataSourceParameters']['AuroraParameters']['SecretArn']

secretsmanager_client = session.client('secretsmanager')
response = secretsmanager_client.get_secret_value(
    SecretId=connection_info
)

connection_string = response['SecretString']

connection = pd.connect(connection_string)
query = 'SELECT * FROM YOUR_TABLE'
df = pd.read_sql(query, connection)

df.to_csv('output.csv', index=False)