1. 首先，需要在AWS Quicksight中创建数据集并连接到要使用的数据库。以下是一个示例代码（本例使用PostgreSQL数据库）：

{
    "credentials": {
        "accessKeyId": "your_access_key_id",
        "secretAccessKey": "your_secret_access_key"
    },
    "region": "us-east-1",
    "database": "your_database_name",
    "host": "your_database_host",
    "port": "your_database_port",
    "ssl": true
}

2. 然后，可以在Quicksight中使用SQL查询语言通过数据集提取所需数据。以下是一个示例代码：

SELECT 
    product_name, 
    SUM(sales_amount) AS total_sales 
FROM 
    sales_data 
WHERE 
    date BETWEEN '2020-01-01' AND '2020-12-31' 
GROUP BY 
    product_name

3. 接下来，可以将提取的数据插入到相应的图表中。以下是一个示例代码：

{
    "type": "column",
    "columns": [
        "product_name",
        "total_sales"
    ],
    "data": {
        "extract": {
            "source": "sales_data",
            "query": "SELECT ..."
        }
    },
    "visual": {
        "colorPalette": "blue",
        "legend": {
            "position": "right"
        },
        "title": {
            "text": "Total Sales by Product"
        },
        "xAxis": {
            "title": "Product Name"
        },
        "yAxis": {
            "title": "Total Sales"
        }
    }
}

4. 最后，将图表添加到Quicksight仪表板中以查看结果。