Data warehousing with AWS QuickSight

Question

Accepted Answer

AWS QuickSight is a managed service by Amazon for Business Intelligence needs. While Pulumi provides comprehensive IaC (infrastructure as code) capability, creating Amazon QuickSight resources such as data sets and analysis directly using Pulumi is, unfortunately, not currently supported. One of the reasons is that QuickSight is focused more on the application layer rather than infrastructure setup.

But don't worry! You can configure the underlying infrastructure for Quicksight using Pulumi. For example, you can setup an Amazon RedShift cluster as a data warehouse which can then be connected to QuickSight for satisfying your business intelligence needs.

Here is a simple Pulumi program that creates an Amazon Redshift cluster:

```python
import pulumi
from pulumi_aws import redshift

my_vpc_security_group = pulumi_aws.ec2.SecurityGroup("myVPCSecurityGroup",
    ingress=[
        {
            "cidr_blocks" : ["0.0.0.0/0"],
            "protocol" : "tcp",
            "fromPort" : 5439,
            "toPort" : 5439,
        }
])

my_cluster = redshift.Cluster("myCluster",
    cluster_type="single-node",
    database_name="myDatabase",
    master_username="myUsername",
    master_password="myPassword",
    node_type="dc2.large",
    cluster_identifier="myCluster",
    vpc_security_group_ids=[my_vpc_security_group.id],
    publicly_accessible=True
)

pulumi.export('cluster_identifier', my_cluster.cluster_identifier)
pulumi.export("host", my_cluster.endpoint)
```

Please note that this code is for illustrative purposes and may require modifications based on your specific requirements such as networking (VPC, security group setup), cluster configurations (single-node or multi-node), etc.

You would then proceed to connect this RedShift cluster as a data source in QuickSight through the QuickSight console. Please consult the AWS [QuickSight user guide](https://docs.aws.amazon.com/quicksight/latest/user/create-a-data-set-amazon-redshift.html) to connect Amazon RedShift as data source.

This Pulumi code sets up only the infrastructure part of the pipeline. For application-level setups like creating visualizations and analyses, you would use the AWS QuickSight's console or API.

You can refer to the [Pulumi Redshift Documentation](https://www.pulumi.com/registry/packages/aws/api-docs/redshift/) for more details on how to provision Redshift clusters using Pulumi.