How to create AWS QuickSight DataSource with AWS CLI

How to create AWS QuickSight DataSource with AWS CLI

AWS CLI, QuickSight By Dec 21, 2022 No Comments

Here are the AWS CLI commands to create a QuickSight data source:

1- First, create a JSON file with the input parameters for the create-data-source command. For example, if you want to create a Redshift data source, the JSON file might look like this:

{
  "DataSourceId": "my-data-source-id",
  "Name": "MyDataSource",
  "Type": "REDSHIFT",
  "DataSourceParameters": {
    "RedshiftClusterId": "my-redshift-cluster-id",
    "Database": "mydatabase",
    "ClusterUsername": "myusername",
    "ClusterPassword": "mypassword"
  },
  "Credentials": {
    "CredentialPair": {
      "Username": "my-credential-username",
      "Password": "my-credential-password"
    }
  },
  "Permissions": [
    {
      "Principal": {
        "Federated": "arn:aws:iam::1234567890:federated-user/myuser"
      },
      "Actions": [
        "quicksight:DescribeDataSource",
        "quicksight:DescribeDataSourcePermissions",
        "quicksight:PassDataSource"
      ]
    }
  ],
  "VpcConnectionProperties": {
    "VpcConnectionArn": "arn:aws:quicksight:us-east-1:1234567890:vpc-connection/my-vpc-connection"
  }
}

2- Save the JSON file as a variable, such as $data_source_params.

3- Run the create-data-source command, passing in the $data_source_params variable as the input:

aws quicksight create-data-source --aws-account-id 1234567890 --namespace default --parameters "$data_source_params"

This will create a QuickSight data source with the specified parameters. The create-data-source command returns the ID of the newly created data source. You can use this ID to reference the data source in other QuickSight operations.

Note: The create-data-source command requires you to specify the AWS account ID and the namespace where the data source will be created. Make sure to replace the placeholder values in the example command with the actual values for your account and namespace.

Author

I'm Abhay Singh, an Architect with 9 Years of It experience. AWS Certified Solutions Architect.

No Comments

Leave a comment

Your email address will not be published. Required fields are marked *