Data orchestration using AWS QuickSight

Question

Accepted Answer

To accomplish data orchestration with AWS QuickSight using Pulumi, there are numerous resources involved. However, Pulumi has no direct support for AWS QuickSight as of the current updates.

Here's an alternative approach:

Build infrastructure around AWS S3 and AWS Glue, which are used for data storage and ETL jobs respectively. Then, you will be able to utilize QuickSight on the AWS console to create analyses and reports from that data.

A Pulumi program to create an AWS S3 bucket and Glue Catalog Database might look like this:

```typescript
import * as pulumi from "@pulumi/pulumi";
import * as aws from "@pulumi/aws";

// Create an AWS S3 bucket
const exampleBucket = new aws.s3.Bucket("exampleBucket", {});

// Create an AWS Glue Catalog Database
const exampleDatabase = new aws.glue.CatalogDatabase("exampleDatabase", {
  name: "example_db",
});

// Export the name of the bucket
export const bucketName = exampleBucket.id;

// Export the name of the Glue Catalog Database
export const databaseName = exampleDatabase.name;
```

With this Pulumi program, you'll have a new S3 bucket and Glue Catalog Database set up for your data and ETL jobs. To orchestrate data, you'd use AWS Glue to run ETL jobs, pulling from other data sources and transforming the data as necessary. After that, you can manually set up QuickSight on the AWS console to use this database.