2019/11/20 - Amazon QuickSight - 49 new api methods
Changes Amazon QuickSight now supports programmatic creation and management of data sources, data sets, dashboards and templates with new APIs. Templates hold dashboard metadata, and can be used to create copies connected to the same or different dataset as required. Also included in this release are APIs for SPICE ingestions, fine-grained access control over AWS resources using AWS Identity and Access Management (IAM) policies, as well AWS tagging. APIs are supported for both Standard and Enterprise Edition, with edition-specific support for specific functionality.
Describes a template's metadata.
CLI syntax:
aws quicksight describe-template --aws-account-id 111122223333 --template-id reports_test_template
aws quicksight describe-template --aws-account-id 111122223333 --template-id reports_test_template --version-number-2
aws quicksight describe-template --aws-account-id 111122223333 --template-id reports_test_template --alias-name '\$LATEST'
Users can explicitly describe the latest version of the dashboard by passing $LATEST to the alias-name parameter. $LATEST is an internally supported alias, which points to the latest version of the dashboard.
See also: AWS API Documentation
Request Syntax
client.describe_template(
AwsAccountId='string',
TemplateId='string',
VersionNumber=123,
AliasName='string'
)
string
[REQUIRED]
AWS account ID that contains the template you are describing.
string
[REQUIRED]
An ID for the template.
integer
This is an optional field, when a version number is provided the corresponding version is describe, if it's not provided the latest version of the template is described.
string
This is an optional field, when an alias name is provided, the version referenced by the alias is described. Refer to CreateTemplateAlias to create a template alias. $PUBLISHED is not supported for template.
dict
Response Syntax
{
'Template': {
'Arn': 'string',
'Name': 'string',
'Version': {
'CreatedTime': datetime(2015, 1, 1),
'Errors': [
{
'Type': 'DATA_SET_NOT_FOUND'|'INTERNAL_FAILURE',
'Message': 'string'
},
],
'VersionNumber': 123,
'Status': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'DataSetConfigurations': [
{
'Placeholder': 'string',
'DataSetSchema': {
'ColumnSchemaList': [
{
'Name': 'string',
'DataType': 'string',
'GeographicRole': 'string'
},
]
},
'ColumnGroupSchemaList': [
{
'Name': 'string',
'ColumnGroupColumnSchemaList': [
{
'Name': 'string'
},
]
},
]
},
],
'Description': 'string',
'SourceEntityArn': 'string'
},
'TemplateId': 'string',
'LastUpdatedTime': datetime(2015, 1, 1),
'CreatedTime': datetime(2015, 1, 1)
},
'Status': 123
}
Response Structure
(dict) --
Template (dict) --
The template structure of the object you want to describe.
Arn (string) --
The ARN of the template.
Name (string) --
The display name of the template.
Version (dict) --
A structure describing the versions of the template.
CreatedTime (datetime) --
The time this was created.
Errors (list) --
Errors associated with the template.
(dict) --
List of errors that occurred when the template version creation failed.
Type (string) --
Type of error.
Message (string) --
Description of the error type.
VersionNumber (integer) --
The version number of the template.
Status (string) --
The http status of the request.
DataSetConfigurations (list) --
Schema of the dataset identified by the placeholder. The idea is that any dashboard created from the template should be bound to new datasets matching the same schema described through this API. .
(dict) --
Dataset configuration.
Placeholder (string) --
Placeholder.
DataSetSchema (dict) --
Dataset schema.
ColumnSchemaList (list) --
A structure containing the list of column schemas.
(dict) --
The column schema.
Name (string) --
The name of the column schema.
DataType (string) --
The data type of the column schema.
GeographicRole (string) --
The geographic role of the column schema.
ColumnGroupSchemaList (list) --
A structure containing the list of column group schemas.
(dict) --
The column group schema.
Name (string) --
The name of the column group schema.
ColumnGroupColumnSchemaList (list) --
A structure containing the list of column group column schemas.
(dict) --
A structure describing the name, datatype, and geographic role of the columns.
Name (string) --
The name of the column group's column schema.
Description (string) --
The description of the template.
SourceEntityArn (string) --
The ARN of the analysis or template which was used to create this template.
TemplateId (string) --
The ID for the template. This is unique per region per AWS account.
LastUpdatedTime (datetime) --
Time when this was last updated.
CreatedTime (datetime) --
Time when this was created.
Status (integer) --
The http status of the request.
Describes read and write permissions on a template.
CLI syntax:
aws quicksight describe-template-permissions —aws-account-id 735340738645 —template-id reports_test_template
See also: AWS API Documentation
Request Syntax
client.describe_template_permissions(
AwsAccountId='string',
TemplateId='string'
)
string
[REQUIRED]
AWS account ID that contains the template you are describing.
string
[REQUIRED]
The ID for the template.
dict
Response Syntax
{
'TemplateId': 'string',
'TemplateArn': 'string',
'Permissions': [
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
TemplateId (string) --
The ID for the template.
TemplateArn (string) --
The ARN of the template.
Permissions (list) --
A list of resource permissions to be set on the template.
(dict) --
Permission for the resource.
Principal (string) --
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) --
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Describes read and write permissions on a dashboard.
CLI syntax:
aws quicksight describe-dashboard-permissions --aws-account-id 735340738645 —dashboard-id reports_test_bob_report
See also: AWS API Documentation
Request Syntax
client.describe_dashboard_permissions(
AwsAccountId='string',
DashboardId='string'
)
string
[REQUIRED]
AWS account ID that contains the dashboard you are describing permissions of.
string
[REQUIRED]
The ID for the dashboard, also added to IAM policy.
dict
Response Syntax
{
'DashboardId': 'string',
'DashboardArn': 'string',
'Permissions': [
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
DashboardId (string) --
The ID for the dashboard.
DashboardArn (string) --
The ARN of the dashboard.
Permissions (list) --
A structure that contains the permissions of the dashboard.
(dict) --
Permission for the resource.
Principal (string) --
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) --
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Creates a template from an existing QuickSight analysis or template. The resulting template can be used to create a dashboard.
A template is an entity in QuickSight which encapsulates the metadata required to create an analysis that can be used to create dashboard. It adds a layer of abstraction by use placeholders to replace the dataset associated with the analysis. You can use templates to create dashboards by replacing dataset placeholders with datasets which follow the same schema that was used to create the source analysis and template.
To create a template from an existing analysis, use the analysis's ARN, aws-account-id , template-id , source-entity , and data-set-references .
CLI syntax to create a template:
aws quicksight create-template —cli-input-json file://create-template.json
CLI syntax to create a template from another template in the same AWS account:
aws quicksight create-template --aws-account-id 111122223333 --template-id reports_test_template --data-set-references DataSetPlaceholder=reports,DataSetArn=arn:aws:quicksight:us-west-2:111122223333:dataset/0dfc789c-81f6-4f4f-b9ac-7db2453eefc8 DataSetPlaceholder=Elblogs,DataSetArn=arn:aws:quicksight:us-west-2:111122223333:dataset/f60da323-af68-45db-9016-08e0d1d7ded5 --source-entity SourceAnalysis='{Arn=arn:aws:quicksight:us-west-2:111122223333:analysis/7fb74527-c36d-4be8-8139-ac1be4c97365}'
To create template from another account’s template, you need to grant cross account resource permission for DescribeTemplate the account that contains the template.
You can use a file to pass JSON to the function if you prefer.
See also: AWS API Documentation
Request Syntax
client.create_template(
AwsAccountId='string',
TemplateId='string',
Name='string',
Permissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
SourceEntity={
'SourceAnalysis': {
'Arn': 'string',
'DataSetReferences': [
{
'DataSetPlaceholder': 'string',
'DataSetArn': 'string'
},
]
},
'SourceTemplate': {
'Arn': 'string'
}
},
Tags=[
{
'Key': 'string',
'Value': 'string'
},
],
VersionDescription='string'
)
string
[REQUIRED]
The ID for the AWS account that the group is in. Currently, you use the ID for the AWS account that contains your Amazon QuickSight account.
string
[REQUIRED]
An ID for the template you want to create. This is unique per AWS region per AWS account.
string
A display name for the template.
list
A list of resource permissions to be set on the template. The shorthand syntax should look similar to this: Shorthand Syntax: Principal=string,Actions=string,string ...
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
dict
[REQUIRED]
The ARN of the source entity from which this template is being created. Templates can be currently created from an analysis or another template. If the ARN is for an analysis, you must include its dataset references.
SourceAnalysis (dict) --
The source analysis, if it is based on an analysis.
Arn (string) -- [REQUIRED]
The Amazon Resource name (ARN) of the resource.
DataSetReferences (list) -- [REQUIRED]
A structure containing information about the dataset references used as placeholders in the template.
(dict) --
Dataset reference.
DataSetPlaceholder (string) -- [REQUIRED]
Dataset placeholder.
DataSetArn (string) -- [REQUIRED]
Dataset ARN.
SourceTemplate (dict) --
The source template, if it is based on an template.
Arn (string) -- [REQUIRED]
The Amazon Resource name (ARN) of the resource.
list
Contains a map of the key-value pairs for the resource tag or tags assigned to the resource.
(dict) --
The keys of the key-value pairs for the resource tag or tags assigned to the resource.
Key (string) -- [REQUIRED]
Tag key.
Value (string) -- [REQUIRED]
Tag value.
string
A description of the current template version being created. This API created the first version of the template. Every time UpdateTemplate is called a new version is created. Each version of the template maintains a description of the version in the VersionDescription field.
dict
Response Syntax
{
'Arn': 'string',
'VersionArn': 'string',
'TemplateId': 'string',
'CreationStatus': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
Arn (string) --
The Amazon Resource Name (ARN) for the template.
VersionArn (string) --
The Amazon Resource Name (ARN) for the template, including the version information of the first version.
TemplateId (string) --
The ID of the template.
CreationStatus (string) --
The template creation status.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Lists data sources in current AWS region that belong to this AWS account.
The permissions resource is: arn:aws:quicksight:region:aws-account-id:datasource/*
CLI syntax: aws quicksight list-data-sources --aws-account-id=111122223333
See also: AWS API Documentation
Request Syntax
client.list_data_sources(
AwsAccountId='string',
NextToken='string',
MaxResults=123
)
string
[REQUIRED]
The AWS account ID.
string
The token for the next set of results, or null if there are no more results.
integer
The maximum number of results to be returned per request.
dict
Response Syntax
{
'DataSources': [
{
'Arn': 'string',
'DataSourceId': 'string',
'Name': 'string',
'Type': 'ADOBE_ANALYTICS'|'AMAZON_ELASTICSEARCH'|'ATHENA'|'AURORA'|'AURORA_POSTGRESQL'|'AWS_IOT_ANALYTICS'|'GITHUB'|'JIRA'|'MARIADB'|'MYSQL'|'POSTGRESQL'|'PRESTO'|'REDSHIFT'|'S3'|'SALESFORCE'|'SERVICENOW'|'SNOWFLAKE'|'SPARK'|'SQLSERVER'|'TERADATA'|'TWITTER',
'Status': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'CreatedTime': datetime(2015, 1, 1),
'LastUpdatedTime': datetime(2015, 1, 1),
'DataSourceParameters': {
'AmazonElasticsearchParameters': {
'Domain': 'string'
},
'AthenaParameters': {
'WorkGroup': 'string'
},
'AuroraParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'AuroraPostgreSqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'AwsIotAnalyticsParameters': {
'DataSetName': 'string'
},
'JiraParameters': {
'SiteBaseUrl': 'string'
},
'MariaDbParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'MySqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'PostgreSqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'PrestoParameters': {
'Host': 'string',
'Port': 123,
'Catalog': 'string'
},
'RdsParameters': {
'InstanceId': 'string',
'Database': 'string'
},
'RedshiftParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string',
'ClusterId': 'string'
},
'S3Parameters': {
'ManifestFileLocation': {
'Bucket': 'string',
'Key': 'string'
}
},
'ServiceNowParameters': {
'SiteBaseUrl': 'string'
},
'SnowflakeParameters': {
'Host': 'string',
'Database': 'string',
'Warehouse': 'string'
},
'SparkParameters': {
'Host': 'string',
'Port': 123
},
'SqlServerParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'TeradataParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'TwitterParameters': {
'Query': 'string',
'MaxRows': 123
}
},
'VpcConnectionProperties': {
'VpcConnectionArn': 'string'
},
'SslProperties': {
'DisableSsl': True|False
},
'ErrorInfo': {
'Type': 'TIMEOUT'|'ENGINE_VERSION_NOT_SUPPORTED'|'UNKNOWN_HOST'|'GENERIC_SQL_FAILURE'|'CONFLICT'|'UNKNOWN',
'Message': 'string'
}
},
],
'NextToken': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
DataSources (list) --
A list of data sources.
(dict) --
The structure of a data source.
Arn (string) --
The Amazon Resource name (ARN) of the data source.
DataSourceId (string) --
The ID of the data source. This is unique per AWS Region per AWS account.
Name (string) --
A display name for the data source.
Type (string) --
The type of the data source. This indicates which database engine the data source connects to.
Status (string) --
The http status of the request.
CreatedTime (datetime) --
The time this was created.
LastUpdatedTime (datetime) --
The last time this was updated.
DataSourceParameters (dict) --
The parameters QuickSight uses to connect to your underlying source. This is a variant type structure. At most one of the attributes should be non-null for this structure to be valid.
AmazonElasticsearchParameters (dict) --
Amazon Elasticsearch parameters.
Domain (string) --
The Amazon Elasticsearch domain.
AthenaParameters (dict) --
Athena parameters.
WorkGroup (string) --
The workgroup that Athena uses.
AuroraParameters (dict) --
Aurora MySQL parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
AuroraPostgreSqlParameters (dict) --
Aurora PostgreSQL parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
AwsIotAnalyticsParameters (dict) --
AWS IoT Analytics parameters.
DataSetName (string) --
Dataset name.
JiraParameters (dict) --
Jira parameters.
SiteBaseUrl (string) --
The base URL of the Jira site.
MariaDbParameters (dict) --
MariaDB parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
MySqlParameters (dict) --
MySQL parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
PostgreSqlParameters (dict) --
PostgreSQL parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
PrestoParameters (dict) --
Presto parameters.
Host (string) --
Host.
Port (integer) --
Port.
Catalog (string) --
Catalog.
RdsParameters (dict) --
RDS parameters.
InstanceId (string) --
Instance ID.
Database (string) --
Database.
RedshiftParameters (dict) --
Redshift parameters.
Host (string) --
Host. This can be blank if the ClusterId is provided.
Port (integer) --
Port. This can be blank if the ClusterId is provided.
Database (string) --
Database.
ClusterId (string) --
Cluster ID. This can be blank if the Host and Port are provided.
S3Parameters (dict) --
S3 parameters.
ManifestFileLocation (dict) --
Location of the Amazon S3 manifest file. This is NULL if the manifest file was uploaded in the console.
Bucket (string) --
Amazon S3 bucket.
Key (string) --
Amazon S3 key that identifies an object.
ServiceNowParameters (dict) --
ServiceNow parameters.
SiteBaseUrl (string) --
URL of the base site.
SnowflakeParameters (dict) --
Snowflake parameters.
Host (string) --
Host.
Database (string) --
Database.
Warehouse (string) --
Warehouse.
SparkParameters (dict) --
Spark parameters.
Host (string) --
Host.
Port (integer) --
Port.
SqlServerParameters (dict) --
SQL Server parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
TeradataParameters (dict) --
Teradata parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
TwitterParameters (dict) --
Twitter parameters.
Query (string) --
Twitter query string.
MaxRows (integer) --
Maximum number of rows to query Twitter.
VpcConnectionProperties (dict) --
The VPC connection information. You need to use this parameter only when you want QuickSight to use a VPC connection when connecting to your underlying source.
VpcConnectionArn (string) --
VPC connection ARN.
SslProperties (dict) --
SSL properties that apply when QuickSight connects to your underlying source.
DisableSsl (boolean) --
A boolean flag to control whether SSL should be disabled.
ErrorInfo (dict) --
Error information from the last update or the creation of the data source.
Type (string) --
Error type.
Message (string) --
Error message.
NextToken (string) --
The token for the next set of results, or null if there are no more results.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Removes a tag or tags from a resource.
CLI syntax:
aws quicksight untag-resource --resource-arn arn:aws:quicksight:us-east-1:111111111111:dataset/dataset1 --tag-keys K1 K2 --region us-east-1
See also: AWS API Documentation
Request Syntax
client.untag_resource(
ResourceArn='string',
TagKeys=[
'string',
]
)
string
[REQUIRED]
The ARN of the resource you to untag.
list
[REQUIRED]
The keys of the key-value pairs for the resource tag or tags assigned to the resource.
(string) --
dict
Response Syntax
{
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Deletes a dataset.
CLI syntax:
aws quicksight delete-data-set \
--aws-account-id=111111111111 \
--data-set-id=unique-data-set-id
See also: AWS API Documentation
Request Syntax
client.delete_data_set(
AwsAccountId='string',
DataSetId='string'
)
string
[REQUIRED]
The AWS Account ID.
string
[REQUIRED]
The ID for the dataset you want to create. This is unique per region per AWS account.
dict
Response Syntax
{
'Arn': 'string',
'DataSetId': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
Arn (string) --
The ARN of the dataset.
DataSetId (string) --
The ID for the dataset you want to create. This is unique per region per AWS account.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Lists all the assignments and the ARNs for the associated IAM policies assigned to the specified user and the group or groups that the user belongs to.
CLI syntax:
aws quicksight list-iam-policy-assignments-for-user --aws-account-id=111122223333 --user-name=user5 --namespace=default --max-result=6 --region=us-east-1
See also: AWS API Documentation
Request Syntax
client.list_iam_policy_assignments_for_user(
AwsAccountId='string',
UserName='string',
NextToken='string',
MaxResults=123,
Namespace='string'
)
string
[REQUIRED]
The AWS account ID that contains the assignment.
string
[REQUIRED]
The name of the user.
string
The token for the next set of results, or null if there are no more results.
integer
The maximum number of results to be returned per request.
string
[REQUIRED]
The namespace of the assignment.
dict
Response Syntax
{
'ActiveAssignments': [
{
'AssignmentName': 'string',
'PolicyArn': 'string'
},
],
'RequestId': 'string',
'NextToken': 'string',
'Status': 123
}
Response Structure
(dict) --
ActiveAssignments (list) --
Active assignments for this user.
(dict) --
The active IAM policy assignment.
AssignmentName (string) --
A name for the IAM policy assignment.
PolicyArn (string) --
The ARN of the resource.
RequestId (string) --
The AWS request ID for this operation.
NextToken (string) --
The token for the next set of results, or null if there are no more results.
Status (integer) --
The http status of the request.
Lists dashboards in the AWS account.
CLI syntax:
aws quicksight list-dashboards --aws-account-id 111122223333 --max-results 5 —next-token 'next-10'
See also: AWS API Documentation
Request Syntax
client.list_dashboards(
AwsAccountId='string',
NextToken='string',
MaxResults=123
)
string
[REQUIRED]
AWS account ID that contains the dashboards you are listing.
string
The token for the next set of results, or null if there are no more results.
integer
The maximum number of results to be returned per request.
dict
Response Syntax
{
'DashboardSummaryList': [
{
'Arn': 'string',
'DashboardId': 'string',
'Name': 'string',
'CreatedTime': datetime(2015, 1, 1),
'LastUpdatedTime': datetime(2015, 1, 1),
'PublishedVersionNumber': 123,
'LastPublishedTime': datetime(2015, 1, 1)
},
],
'NextToken': 'string',
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
DashboardSummaryList (list) --
A structure that contains all of the dashboards shared with the user. Provides basic information about the dashboards.
(dict) --
Dashboard summary.
Arn (string) --
The Amazon Resource name (ARN) of the resource.
DashboardId (string) --
Dashboard ID.
Name (string) --
A display name for the dataset.
CreatedTime (datetime) --
The time this was created.
LastUpdatedTime (datetime) --
The last time this was updated.
PublishedVersionNumber (integer) --
Published version number.
LastPublishedTime (datetime) --
The last time this was published.
NextToken (string) --
The token for the next set of results, or null if there are no more results.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Creates a template alias for a template.
CLI syntax:
aws quicksight create-template-alias --aws-account-id 111122223333 --template-id 'reports_test_template' --alias-name PROD —version-number 1
See also: AWS API Documentation
Request Syntax
client.create_template_alias(
AwsAccountId='string',
TemplateId='string',
AliasName='string',
TemplateVersionNumber=123
)
string
[REQUIRED]
AWS account ID that contains the template you are aliasing.
string
[REQUIRED]
An ID for the template.
string
[REQUIRED]
The name you want to give the template's alias. Alias names can't begin with a $ , which is reserved by QuickSight. Alias names that start with ‘$’ sign are QuickSight reserved naming and can't be deleted.
integer
[REQUIRED]
The version number of the template.
dict
Response Syntax
{
'TemplateAlias': {
'AliasName': 'string',
'Arn': 'string',
'TemplateVersionNumber': 123
},
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
TemplateAlias (dict) --
Information on the template alias.
AliasName (string) --
The display name of the template alias.
Arn (string) --
The ARN of the template alias.
TemplateVersionNumber (integer) --
The version number of the template alias.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Describes a dataset.
CLI syntax:
aws quicksight describe-data-set \
--aws-account-id=111111111111 \
--data-set-id=unique-data-set-id
See also: AWS API Documentation
Request Syntax
client.describe_data_set(
AwsAccountId='string',
DataSetId='string'
)
string
[REQUIRED]
The AWS Account ID.
string
[REQUIRED]
The ID for the dataset you want to create. This is unique per region per AWS account.
dict
Response Syntax
{
'DataSet': {
'Arn': 'string',
'DataSetId': 'string',
'Name': 'string',
'CreatedTime': datetime(2015, 1, 1),
'LastUpdatedTime': datetime(2015, 1, 1),
'PhysicalTableMap': {
'string': {
'RelationalTable': {
'DataSourceArn': 'string',
'Schema': 'string',
'Name': 'string',
'InputColumns': [
{
'Name': 'string',
'Type': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME'|'BIT'|'BOOLEAN'|'JSON'
},
]
},
'CustomSql': {
'DataSourceArn': 'string',
'Name': 'string',
'SqlQuery': 'string',
'Columns': [
{
'Name': 'string',
'Type': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME'|'BIT'|'BOOLEAN'|'JSON'
},
]
},
'S3Source': {
'DataSourceArn': 'string',
'UploadSettings': {
'Format': 'CSV'|'TSV'|'CLF'|'ELF'|'XLSX'|'JSON',
'StartFromRow': 123,
'ContainsHeader': True|False,
'TextQualifier': 'DOUBLE_QUOTE'|'SINGLE_QUOTE',
'Delimiter': 'string'
},
'InputColumns': [
{
'Name': 'string',
'Type': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME'|'BIT'|'BOOLEAN'|'JSON'
},
]
}
}
},
'LogicalTableMap': {
'string': {
'Alias': 'string',
'DataTransforms': [
{
'ProjectOperation': {
'ProjectedColumns': [
'string',
]
},
'FilterOperation': {
'ConditionExpression': 'string'
},
'CreateColumnsOperation': {
'Columns': [
{
'ColumnName': 'string',
'ColumnId': 'string',
'Expression': 'string'
},
]
},
'RenameColumnOperation': {
'ColumnName': 'string',
'NewColumnName': 'string'
},
'CastColumnTypeOperation': {
'ColumnName': 'string',
'NewColumnType': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME',
'Format': 'string'
},
'TagColumnOperation': {
'ColumnName': 'string',
'Tags': [
{
'ColumnGeographicRole': 'COUNTRY'|'STATE'|'COUNTY'|'CITY'|'POSTCODE'|'LONGITUDE'|'LATITUDE'
},
]
}
},
],
'Source': {
'JoinInstruction': {
'LeftOperand': 'string',
'RightOperand': 'string',
'Type': 'INNER'|'OUTER'|'LEFT'|'RIGHT',
'OnClause': 'string'
},
'PhysicalTableId': 'string'
}
}
},
'OutputColumns': [
{
'Name': 'string',
'Type': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME'
},
],
'ImportMode': 'SPICE'|'DIRECT_QUERY',
'ConsumedSpiceCapacityInBytes': 123,
'ColumnGroups': [
{
'GeoSpatialColumnGroup': {
'Name': 'string',
'CountryCode': 'US',
'Columns': [
'string',
]
}
},
],
'RowLevelPermissionDataSet': {
'Arn': 'string',
'PermissionPolicy': 'GRANT_ACCESS'|'DENY_ACCESS'
}
},
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
DataSet (dict) --
Information on the dataset.
Arn (string) --
The Amazon Resource name (ARN) of the resource.
DataSetId (string) --
The ID of the dataset.
Name (string) --
A display name for the dataset.
CreatedTime (datetime) --
The time this was created.
LastUpdatedTime (datetime) --
The last time this was updated.
PhysicalTableMap (dict) --
Declares the physical tables that are available in the underlying data sources.
(string) --
(dict) --
A view of a data source. Contains information on the shape of the data in the underlying source. This is a variant type structure. No more than one of the attributes can be non-null for this structure to be valid.
RelationalTable (dict) --
A physical table type for relational data sources.
DataSourceArn (string) --
Data source ARN.
Schema (string) --
The schema name. Applies to certain relational database engines.
Name (string) --
Name of the relational table.
InputColumns (list) --
The column schema of the table.
(dict) --
Metadata on a column that is used as the input of a transform operation.
Name (string) --
The name of this column in the underlying data source.
Type (string) --
The data type of the column.
CustomSql (dict) --
A physical table type built from the results of the custom SQL query.
DataSourceArn (string) --
The ARN of the data source.
Name (string) --
A display name for the SQL query result.
SqlQuery (string) --
The SQL query.
Columns (list) --
The column schema from the SQL query result set.
(dict) --
Metadata on a column that is used as the input of a transform operation.
Name (string) --
The name of this column in the underlying data source.
Type (string) --
The data type of the column.
S3Source (dict) --
A physical table type for as S3 data source.
DataSourceArn (string) --
Data source ARN.
UploadSettings (dict) --
Information on the S3 source file(s) format.
Format (string) --
File format.
StartFromRow (integer) --
A row number to start reading data from.
ContainsHeader (boolean) --
Whether or not the file(s) has a header row.
TextQualifier (string) --
Text qualifier.
Delimiter (string) --
The delimiter between values in the file.
InputColumns (list) --
A physical table type for as S3 data source.
(dict) --
Metadata on a column that is used as the input of a transform operation.
Name (string) --
The name of this column in the underlying data source.
Type (string) --
The data type of the column.
LogicalTableMap (dict) --
Configures the combination and transformation of the data from the physical tables.
(string) --
(dict) --
A unit that joins and data transformations operate on. A logical table has a source, which can be either a physical table or result of a join. When it points to a physical table, a logical table acts as a mutable copy of that table through transform operations.
Alias (string) --
A display name for the logical table.
DataTransforms (list) --
Transform operations that act on this logical table.
(dict) --
A data transformation on a logical table. This is a variant type structure. No more than one of the attributes should be non-null for this structure to be valid.
ProjectOperation (dict) --
An operation that projects columns. Operations that come after a projection can only refer to projected columns.
ProjectedColumns (list) --
Projected columns.
(string) --
FilterOperation (dict) --
An operation that filters rows based on some condition.
ConditionExpression (string) --
An expression that must evaluate to a boolean value. Rows for which the expression is evaluated to true are kept in the dataset.
CreateColumnsOperation (dict) --
An operation that creates calculated columns. Columns created in one such operation form a lexical closure.
Columns (list) --
Calculated columns to create.
(dict) --
A calculated column for a dataset.
ColumnName (string) --
Column name.
ColumnId (string) --
A unique ID to identify a calculated column. During dataset update, if the column ID of a calculated column matches that of an existing calculated column, QuickSight preserves the existing calculated column.
Expression (string) --
An expression that defines the calculated column.
RenameColumnOperation (dict) --
An operation that renames a column.
ColumnName (string) --
Name of the column to be renamed.
NewColumnName (string) --
New name for the column.
CastColumnTypeOperation (dict) --
A transform operation that casts a column to a different type.
ColumnName (string) --
Column name.
NewColumnType (string) --
New column data type.
Format (string) --
When casting a column from string to datetime type, you can supply a QuickSight supported format string to denote the source data format.
TagColumnOperation (dict) --
An operation that tags a column with additional information.
ColumnName (string) --
The column that this operation acts on.
Tags (list) --
The dataset column tag, currently only used for geospatial type tagging. .
Note
This is not tags for the AWS tagging feature. .
(dict) --
A tag for a column in a TagColumnOperation. This is a variant type structure. No more than one of the attributes should be non-null for this structure to be valid.
ColumnGeographicRole (string) --
A geospatial role for a column.
Source (dict) --
Source of this logical table.
JoinInstruction (dict) --
Specifies the result of a join of two logical tables.
LeftOperand (string) --
Left operand.
RightOperand (string) --
Right operand.
Type (string) --
Type.
OnClause (string) --
On Clause.
PhysicalTableId (string) --
Physical table ID.
OutputColumns (list) --
The list of columns after all transforms. These columns are available in templates, analyses, and dashboards.
(dict) --
Output column.
Name (string) --
A display name for the dataset.
Type (string) --
Type.
ImportMode (string) --
Indicates whether or not you want to import the data into SPICE.
ConsumedSpiceCapacityInBytes (integer) --
The amount of SPICE capacity used by this dataset. This is 0 if the dataset isn't imported into SPICE.
ColumnGroups (list) --
Groupings of columns that work together in certain QuickSight features. Currently only geospatial hierarchy is supported.
(dict) --
Groupings of columns that work together in certain QuickSight features. This is a variant type structure. No more than one of the attributes should be non-null for this structure to be valid.
GeoSpatialColumnGroup (dict) --
Geospatial column group that denotes a hierarchy.
Name (string) --
A display name for the hierarchy.
CountryCode (string) --
Country code.
Columns (list) --
Columns in this hierarchy.
(string) --
RowLevelPermissionDataSet (dict) --
Row-level security configuration on the dataset.
Arn (string) --
The Amazon Resource name (ARN) of the permission dataset.
PermissionPolicy (string) --
Permission policy.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Updates read and write permissions on a dashboard.
CLI syntax:
aws quicksight update-dashboard-permissions —cli-input-json file://update-permission.json
A sample update-permissions.json for granting read only permissions:
{ "AwsAccountId": "111122223333", "DashboardId": "reports_test_report", "GrantPermissions": [ { "Principal": "arn:aws:quicksight:us-east-1:111122223333:user/default/user2", "Actions": [ "quicksight:DescribeDashboard", "quicksight:ListDashboardVersions", "quicksight:DescribeDashboardVersion", "quicksight:QueryDashboard" ] } ] }
A sample update-permissions.json for granting read and write permissions:
{ "AwsAccountId": "111122223333", "DashboardId": "reports_test_report", "GrantPermissions": [ { "Principal": "arn:aws:quicksight:us-east-1:111122223333:user/default/user2", "Actions": [ "quicksight:DescribeDashboard", "quicksight:ListDashboardVersions", "quicksight:DescribeDashboardVersion", "quicksight:QueryDashboard", "quicksight:DescribeDashboardPermissions", "quicksight:UpdateDashboardPermissions", "quicksight:DeleteDashboardVersion", "quicksight:DeleteDashboard", "quicksight:UpdateDashboard", "quicksight:UpdateDashboardPublishedVersion", ] } ] }
A sample update-permissions.json for revoking write permissions:
{ "AwsAccountId": "111122223333", "DashboardId": "reports_test_report", "RevokePermissions": [ { "Principal": "arn:aws:quicksight:us-east-1:111122223333:user/default/user2", "Actions": [ "quicksight:DescribeDashboardPermissions", "quicksight:UpdateDashboardPermissions", "quicksight:DeleteDashboardVersion", "quicksight:DeleteDashboard", "quicksight:UpdateDashboard", "quicksight:UpdateDashboardPublishedVersion", ] } ] }
A sample update-permissions.json for revoking read and write permissions:
{ "AwsAccountId": "111122223333", "DashboardId": "reports_test_report", "RevokePermissions": [ { "Principal": "arn:aws:quicksight:us-east-1:111122223333:user/default/user2", "Actions": [ "quicksight:DescribeDashboard", "quicksight:ListDashboardVersions", "quicksight:DescribeDashboardVersion", "quicksight:QueryDashboard", "quicksight:DescribeDashboardPermissions", "quicksight:UpdateDashboardPermissions", "quicksight:DeleteDashboardVersion", "quicksight:DeleteDashboard", "quicksight:UpdateDashboard", "quicksight:UpdateDashboardPublishedVersion", ] } ] }
To obtain the principal name of a QuickSight user or group, you can use describe-group or describe-user. For example:
aws quicksight describe-user --aws-account-id 111122223333 --namespace default --user-name user2 --region us-east-1 { "User": { "Arn": "arn:aws:quicksight:us-east-1:111122223333:user/default/user2", "Active": true, "Email": "user2@example.com", "Role": "ADMIN", "UserName": "user2", "PrincipalId": "federated/iam/abcd2abcdabcdeabc5ab5" }, "RequestId": "8f74bb31-6291-448a-a71c-a765a44bae31", "Status": 200 }
See also: AWS API Documentation
Request Syntax
client.update_dashboard_permissions(
AwsAccountId='string',
DashboardId='string',
GrantPermissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
RevokePermissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
]
)
string
[REQUIRED]
AWS account ID that contains the dashboard you are updating.
string
[REQUIRED]
The ID for the dashboard.
list
The permissions that you want to grant on this resource.
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
list
The permissions that you want to revoke from this resource.
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
dict
Response Syntax
{
'DashboardArn': 'string',
'DashboardId': 'string',
'Permissions': [
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
DashboardArn (string) --
The ARN of the dashboard.
DashboardId (string) --
The ID for the dashboard.
Permissions (list) --
Information about the permissions on the dashboard.
(dict) --
Permission for the resource.
Principal (string) --
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) --
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Deletes a template.
CLI syntax:
aws quicksight delete-template --aws-account-id 111122223333 —-template-id reports_test_template --version-number 2
aws quicksight delete-template —aws-account-id 111122223333 —template-id reports_test_template —alias-name STAGING
aws quicksight delete-template —aws-account-id 111122223333 —template-id reports_test_template —alias-name ‘\$LATEST’
aws quicksight delete-template --aws-account-id 111122223333 —-template-id reports_test_template
If version number which is an optional field is not passed the template (including all the versions) is deleted by the API, if version number is provided, the specific template version is deleted by the API.
Users can explicitly describe the latest version of the template by passing $LATEST to the alias-name parameter. $LATEST is an internally supported alias, which points to the latest version of the template.
See also: AWS API Documentation
Request Syntax
client.delete_template(
AwsAccountId='string',
TemplateId='string',
VersionNumber=123
)
string
[REQUIRED]
AWS account ID that contains the template you are deleting.
string
[REQUIRED]
An ID for the template you want to delete.
integer
The version number
dict
Response Syntax
{
'RequestId': 'string',
'Arn': 'string',
'TemplateId': 'string',
'Status': 123
}
Response Structure
(dict) --
RequestId (string) --
The AWS request ID for this operation.
Arn (string) --
The ARN of the resource.
TemplateId (string) --
An ID for the template.
Status (integer) --
The http status of the request.
Lists all the versions of the dashboards in the Quicksight subscription.
CLI syntax:
aws quicksight list-template-versions —aws-account-id 111122223333 —template-id reports-test-template
See also: AWS API Documentation
Request Syntax
client.list_dashboard_versions(
AwsAccountId='string',
DashboardId='string',
NextToken='string',
MaxResults=123
)
string
[REQUIRED]
AWS account ID that contains the dashboard you are listing.
string
[REQUIRED]
The ID for the dashboard.
string
The token for the next set of results, or null if there are no more results.
integer
The maximum number of results to be returned per request.
dict
Response Syntax
{
'DashboardVersionSummaryList': [
{
'Arn': 'string',
'CreatedTime': datetime(2015, 1, 1),
'VersionNumber': 123,
'Status': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'SourceEntityArn': 'string',
'Description': 'string'
},
],
'NextToken': 'string',
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
DashboardVersionSummaryList (list) --
A structure that contains information about each version of the dashboard.
(dict) --
Dashboard version summary.
Arn (string) --
The Amazon Resource name (ARN) of the resource.
CreatedTime (datetime) --
The time this was created.
VersionNumber (integer) --
Version number.
Status (string) --
The http status of the request.
SourceEntityArn (string) --
Source entity ARN.
Description (string) --
Description.
NextToken (string) --
The token for the next set of results, or null if there are no more results.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Describes the template aliases of a template.
CLI syntax:
aws quicksight describe-template-alias --aws-account-id 111122223333 --template-id 'reports_test_template' --alias-name 'STAGING'
See also: AWS API Documentation
Request Syntax
client.describe_template_alias(
AwsAccountId='string',
TemplateId='string',
AliasName='string'
)
string
[REQUIRED]
AWS account ID that contains the template alias you are describing.
string
[REQUIRED]
An ID for the template.
string
[REQUIRED]
The alias name. $PUBLISHED is not supported for template.
dict
Response Syntax
{
'TemplateAlias': {
'AliasName': 'string',
'Arn': 'string',
'TemplateVersionNumber': 123
},
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
TemplateAlias (dict) --
Information about the template alias.
AliasName (string) --
The display name of the template alias.
Arn (string) --
The ARN of the template alias.
TemplateVersionNumber (integer) --
The version number of the template alias.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Describes a SPICE ingestion.
See also: AWS API Documentation
Request Syntax
client.describe_ingestion(
AwsAccountId='string',
DataSetId='string',
IngestionId='string'
)
string
[REQUIRED]
The AWS account ID.
string
[REQUIRED]
The ID of the dataset used in the ingestion.
string
[REQUIRED]
An ID for the ingestion.
dict
Response Syntax
{
'Ingestion': {
'Arn': 'string',
'IngestionId': 'string',
'IngestionStatus': 'INITIALIZED'|'QUEUED'|'RUNNING'|'FAILED'|'COMPLETED'|'CANCELLED',
'ErrorInfo': {
'Type': 'FAILURE_TO_ASSUME_ROLE'|'INGESTION_SUPERSEDED'|'INGESTION_CANCELED'|'DATA_SET_DELETED'|'DATA_SET_NOT_SPICE'|'S3_UPLOADED_FILE_DELETED'|'S3_MANIFEST_ERROR'|'DATA_TOLERANCE_EXCEPTION'|'SPICE_TABLE_NOT_FOUND'|'DATA_SET_SIZE_LIMIT_EXCEEDED'|'ROW_SIZE_LIMIT_EXCEEDED'|'ACCOUNT_CAPACITY_LIMIT_EXCEEDED'|'CUSTOMER_ERROR'|'DATA_SOURCE_NOT_FOUND'|'IAM_ROLE_NOT_AVAILABLE'|'CONNECTION_FAILURE'|'SQL_TABLE_NOT_FOUND'|'PERMISSION_DENIED'|'SSL_CERTIFICATE_VALIDATION_FAILURE'|'OAUTH_TOKEN_FAILURE'|'SOURCE_API_LIMIT_EXCEEDED_FAILURE'|'PASSWORD_AUTHENTICATION_FAILURE'|'SQL_SCHEMA_MISMATCH_ERROR'|'INVALID_DATE_FORMAT'|'INVALID_DATAPREP_SYNTAX'|'SOURCE_RESOURCE_LIMIT_EXCEEDED'|'SQL_INVALID_PARAMETER_VALUE'|'QUERY_TIMEOUT'|'SQL_NUMERIC_OVERFLOW'|'UNRESOLVABLE_HOST'|'UNROUTABLE_HOST'|'SQL_EXCEPTION'|'S3_FILE_INACCESSIBLE'|'IOT_FILE_NOT_FOUND'|'IOT_DATA_SET_FILE_EMPTY'|'INVALID_DATA_SOURCE_CONFIG'|'DATA_SOURCE_AUTH_FAILED'|'DATA_SOURCE_CONNECTION_FAILED'|'FAILURE_TO_PROCESS_JSON_FILE'|'INTERNAL_SERVICE_ERROR',
'Message': 'string'
},
'RowInfo': {
'RowsIngested': 123,
'RowsDropped': 123
},
'QueueInfo': {
'WaitingOnIngestion': 'string',
'QueuedIngestion': 'string'
},
'CreatedTime': datetime(2015, 1, 1),
'IngestionTimeInSeconds': 123,
'IngestionSizeInBytes': 123,
'RequestSource': 'MANUAL'|'SCHEDULED',
'RequestType': 'INITIAL_INGESTION'|'EDIT'|'INCREMENTAL_REFRESH'|'FULL_REFRESH'
},
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
Ingestion (dict) --
Information about the ingestion.
Arn (string) --
The Amazon Resource name (ARN) of the resource.
IngestionId (string) --
Ingestion ID.
IngestionStatus (string) --
Ingestion status.
ErrorInfo (dict) --
Error information for this ingestion.
Type (string) --
Error type.
Message (string) --
Error essage.
RowInfo (dict) --
Information on rows during a data set SPICE ingestion.
RowsIngested (integer) --
The number of rows that were ingested.
RowsDropped (integer) --
The number of rows that were not ingested.
QueueInfo (dict) --
Information on queued dataset SPICE ingestion.
WaitingOnIngestion (string) --
The ID of the queued ingestion.
QueuedIngestion (string) --
The ID of the ongoing ingestion. The queued ingestion is waiting for the ongoing ingestion to complete.
CreatedTime (datetime) --
The time this ingestion started.
IngestionTimeInSeconds (integer) --
The time this ingestion took, measured in seconds.
IngestionSizeInBytes (integer) --
Size of the data ingested in bytes.
RequestSource (string) --
Event source for this ingestion.
RequestType (string) --
Type of this ingestion.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Describes a data source.
The permissions resource is arn:aws:quicksight:region:aws-account-id:datasource/data-source-id
See also: AWS API Documentation
Request Syntax
client.describe_data_source(
AwsAccountId='string',
DataSourceId='string'
)
string
[REQUIRED]
The AWS account ID.
string
[REQUIRED]
The ID of the data source. This is unique per AWS Region per AWS account.
dict
Response Syntax
{
'DataSource': {
'Arn': 'string',
'DataSourceId': 'string',
'Name': 'string',
'Type': 'ADOBE_ANALYTICS'|'AMAZON_ELASTICSEARCH'|'ATHENA'|'AURORA'|'AURORA_POSTGRESQL'|'AWS_IOT_ANALYTICS'|'GITHUB'|'JIRA'|'MARIADB'|'MYSQL'|'POSTGRESQL'|'PRESTO'|'REDSHIFT'|'S3'|'SALESFORCE'|'SERVICENOW'|'SNOWFLAKE'|'SPARK'|'SQLSERVER'|'TERADATA'|'TWITTER',
'Status': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'CreatedTime': datetime(2015, 1, 1),
'LastUpdatedTime': datetime(2015, 1, 1),
'DataSourceParameters': {
'AmazonElasticsearchParameters': {
'Domain': 'string'
},
'AthenaParameters': {
'WorkGroup': 'string'
},
'AuroraParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'AuroraPostgreSqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'AwsIotAnalyticsParameters': {
'DataSetName': 'string'
},
'JiraParameters': {
'SiteBaseUrl': 'string'
},
'MariaDbParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'MySqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'PostgreSqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'PrestoParameters': {
'Host': 'string',
'Port': 123,
'Catalog': 'string'
},
'RdsParameters': {
'InstanceId': 'string',
'Database': 'string'
},
'RedshiftParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string',
'ClusterId': 'string'
},
'S3Parameters': {
'ManifestFileLocation': {
'Bucket': 'string',
'Key': 'string'
}
},
'ServiceNowParameters': {
'SiteBaseUrl': 'string'
},
'SnowflakeParameters': {
'Host': 'string',
'Database': 'string',
'Warehouse': 'string'
},
'SparkParameters': {
'Host': 'string',
'Port': 123
},
'SqlServerParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'TeradataParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'TwitterParameters': {
'Query': 'string',
'MaxRows': 123
}
},
'VpcConnectionProperties': {
'VpcConnectionArn': 'string'
},
'SslProperties': {
'DisableSsl': True|False
},
'ErrorInfo': {
'Type': 'TIMEOUT'|'ENGINE_VERSION_NOT_SUPPORTED'|'UNKNOWN_HOST'|'GENERIC_SQL_FAILURE'|'CONFLICT'|'UNKNOWN',
'Message': 'string'
}
},
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
DataSource (dict) --
The information on the data source.
Arn (string) --
The Amazon Resource name (ARN) of the data source.
DataSourceId (string) --
The ID of the data source. This is unique per AWS Region per AWS account.
Name (string) --
A display name for the data source.
Type (string) --
The type of the data source. This indicates which database engine the data source connects to.
Status (string) --
The http status of the request.
CreatedTime (datetime) --
The time this was created.
LastUpdatedTime (datetime) --
The last time this was updated.
DataSourceParameters (dict) --
The parameters QuickSight uses to connect to your underlying source. This is a variant type structure. At most one of the attributes should be non-null for this structure to be valid.
AmazonElasticsearchParameters (dict) --
Amazon Elasticsearch parameters.
Domain (string) --
The Amazon Elasticsearch domain.
AthenaParameters (dict) --
Athena parameters.
WorkGroup (string) --
The workgroup that Athena uses.
AuroraParameters (dict) --
Aurora MySQL parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
AuroraPostgreSqlParameters (dict) --
Aurora PostgreSQL parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
AwsIotAnalyticsParameters (dict) --
AWS IoT Analytics parameters.
DataSetName (string) --
Dataset name.
JiraParameters (dict) --
Jira parameters.
SiteBaseUrl (string) --
The base URL of the Jira site.
MariaDbParameters (dict) --
MariaDB parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
MySqlParameters (dict) --
MySQL parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
PostgreSqlParameters (dict) --
PostgreSQL parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
PrestoParameters (dict) --
Presto parameters.
Host (string) --
Host.
Port (integer) --
Port.
Catalog (string) --
Catalog.
RdsParameters (dict) --
RDS parameters.
InstanceId (string) --
Instance ID.
Database (string) --
Database.
RedshiftParameters (dict) --
Redshift parameters.
Host (string) --
Host. This can be blank if the ClusterId is provided.
Port (integer) --
Port. This can be blank if the ClusterId is provided.
Database (string) --
Database.
ClusterId (string) --
Cluster ID. This can be blank if the Host and Port are provided.
S3Parameters (dict) --
S3 parameters.
ManifestFileLocation (dict) --
Location of the Amazon S3 manifest file. This is NULL if the manifest file was uploaded in the console.
Bucket (string) --
Amazon S3 bucket.
Key (string) --
Amazon S3 key that identifies an object.
ServiceNowParameters (dict) --
ServiceNow parameters.
SiteBaseUrl (string) --
URL of the base site.
SnowflakeParameters (dict) --
Snowflake parameters.
Host (string) --
Host.
Database (string) --
Database.
Warehouse (string) --
Warehouse.
SparkParameters (dict) --
Spark parameters.
Host (string) --
Host.
Port (integer) --
Port.
SqlServerParameters (dict) --
SQL Server parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
TeradataParameters (dict) --
Teradata parameters.
Host (string) --
Host.
Port (integer) --
Port.
Database (string) --
Database.
TwitterParameters (dict) --
Twitter parameters.
Query (string) --
Twitter query string.
MaxRows (integer) --
Maximum number of rows to query Twitter.
VpcConnectionProperties (dict) --
The VPC connection information. You need to use this parameter only when you want QuickSight to use a VPC connection when connecting to your underlying source.
VpcConnectionArn (string) --
VPC connection ARN.
SslProperties (dict) --
SSL properties that apply when QuickSight connects to your underlying source.
DisableSsl (boolean) --
A boolean flag to control whether SSL should be disabled.
ErrorInfo (dict) --
Error information from the last update or the creation of the data source.
Type (string) --
Error type.
Message (string) --
Error message.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Lists all the aliases of a template.
CLI syntax:
aws quicksight list-template-aliases --aws-account-id 111122223333 —template-id 'reports_test_template'
See also: AWS API Documentation
Request Syntax
client.list_template_aliases(
AwsAccountId='string',
TemplateId='string',
NextToken='string',
MaxResults=123
)
string
[REQUIRED]
AWS account ID that contains the template aliases you are listing.
string
[REQUIRED]
The ID for the template.
string
The token for the next set of results, or null if there are no more results.
integer
The maximum number of results to be returned per request.
dict
Response Syntax
{
'TemplateAliasList': [
{
'AliasName': 'string',
'Arn': 'string',
'TemplateVersionNumber': 123
},
],
'Status': 123,
'RequestId': 'string',
'NextToken': 'string'
}
Response Structure
(dict) --
TemplateAliasList (list) --
A structure containing the list of template aliases.
(dict) --
The template alias.
AliasName (string) --
The display name of the template alias.
Arn (string) --
The ARN of the template alias.
TemplateVersionNumber (integer) --
The version number of the template alias.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
NextToken (string) --
The token for the next set of results, or null if there are no more results.
Deletes the data source permanently. This action breaks all the datasets that reference the deleted data source.
CLI syntax:
aws quicksight delete-data-source \
--aws-account-id=111122223333 \
--data-source-id=unique-data-source-id
See also: AWS API Documentation
Request Syntax
client.delete_data_source(
AwsAccountId='string',
DataSourceId='string'
)
string
[REQUIRED]
The AWS account ID.
string
[REQUIRED]
The ID of the data source. This is unique per AWS Region per AWS account.
dict
Response Syntax
{
'Arn': 'string',
'DataSourceId': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
Arn (string) --
The ARN of the data source you deleted.
DataSourceId (string) --
The ID of the data source. This is unique per AWS Region per AWS account.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Lists all the versions of the templates in the Quicksight account.
CLI syntax:
aws quicksight list-template-versions --aws-account-id 111122223333 --aws-account-id 196359894473 --template-id reports-test-template
See also: AWS API Documentation
Request Syntax
client.list_template_versions(
AwsAccountId='string',
TemplateId='string',
NextToken='string',
MaxResults=123
)
string
[REQUIRED]
AWS account ID that contains the templates you are listing.
string
[REQUIRED]
The ID for the template.
string
The token for the next set of results, or null if there are no more results.
integer
The maximum number of results to be returned per request.
dict
Response Syntax
{
'TemplateVersionSummaryList': [
{
'Arn': 'string',
'VersionNumber': 123,
'CreatedTime': datetime(2015, 1, 1),
'Status': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'Description': 'string'
},
],
'NextToken': 'string',
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
TemplateVersionSummaryList (list) --
A structure containing a list of all the versions of the specified template.
(dict) --
The template version.
Arn (string) --
The ARN of the template version.
VersionNumber (integer) --
The version number of the template version.
CreatedTime (datetime) --
The time this was created.
Status (string) --
The status of the template version.
Description (string) --
The desription of the template version.
NextToken (string) --
The token for the next set of results, or null if there are no more results.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Updates the permissions on a dataset.
The permissions resource is arn:aws:quicksight:region:aws-account-id:dataset/data-set-id
CLI syntax:
aws quicksight update-data-set-permissions \
--aws-account-id=111122223333 \
--data-set-id=unique-data-set-id \
--grant-permissions='[{"Principal":"arn:aws:quicksight:us-east-1:111122223333:user/default/user1","Actions":["quicksight:DescribeDataSet","quicksight:DescribeDataSetPermissions","quicksight:PassDataSet","quicksight:ListIngestions","quicksight:DescribeIngestion"]}]' \
--revoke-permissions='[{"Principal":"arn:aws:quicksight:us-east-1:111122223333:user/default/user2","Actions":["quicksight:UpdateDataSet","quicksight:DeleteDataSet","quicksight:UpdateDataSetPermissions","quicksight:CreateIngestion","quicksight:CancelIngestion"]}]'
See also: AWS API Documentation
Request Syntax
client.update_data_set_permissions(
AwsAccountId='string',
DataSetId='string',
GrantPermissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
RevokePermissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
]
)
string
[REQUIRED]
The AWS Account ID.
string
[REQUIRED]
The ID for the dataset you want to create. This is unique per region per AWS account.
list
The resource permissions that you want to grant to the dataset.
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
list
The resource permissions that you want to revoke from the dataset.
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
dict
Response Syntax
{
'DataSetArn': 'string',
'DataSetId': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
DataSetArn (string) --
The ARN of the dataset.
DataSetId (string) --
The ID for the dataset you want to create. This is unique per region per AWS account.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Updates a data source.
The permissions resource is arn:aws:quicksight:region:aws-account-id:datasource/data-source-id
CLI syntax:
aws quicksight update-data-source \
--aws-account-id=111122223333 \
--data-source-id=unique-data-source-id \
--name='My Data Source' \
--data-source-parameters='{"PostgreSqlParameters":{"Host":"my-db-host.example.com","Port":1234,"Database":"my-db"}}' \
--credentials='{"CredentialPair":{"Username":"username","Password":"password"}}
See also: AWS API Documentation
Request Syntax
client.update_data_source(
AwsAccountId='string',
DataSourceId='string',
Name='string',
DataSourceParameters={
'AmazonElasticsearchParameters': {
'Domain': 'string'
},
'AthenaParameters': {
'WorkGroup': 'string'
},
'AuroraParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'AuroraPostgreSqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'AwsIotAnalyticsParameters': {
'DataSetName': 'string'
},
'JiraParameters': {
'SiteBaseUrl': 'string'
},
'MariaDbParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'MySqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'PostgreSqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'PrestoParameters': {
'Host': 'string',
'Port': 123,
'Catalog': 'string'
},
'RdsParameters': {
'InstanceId': 'string',
'Database': 'string'
},
'RedshiftParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string',
'ClusterId': 'string'
},
'S3Parameters': {
'ManifestFileLocation': {
'Bucket': 'string',
'Key': 'string'
}
},
'ServiceNowParameters': {
'SiteBaseUrl': 'string'
},
'SnowflakeParameters': {
'Host': 'string',
'Database': 'string',
'Warehouse': 'string'
},
'SparkParameters': {
'Host': 'string',
'Port': 123
},
'SqlServerParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'TeradataParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'TwitterParameters': {
'Query': 'string',
'MaxRows': 123
}
},
Credentials={
'CredentialPair': {
'Username': 'string',
'Password': 'string'
}
},
VpcConnectionProperties={
'VpcConnectionArn': 'string'
},
SslProperties={
'DisableSsl': True|False
}
)
string
[REQUIRED]
The AWS account ID.
string
[REQUIRED]
The ID of the data source. This is unique per AWS Region per AWS account.
string
[REQUIRED]
A display name for the data source.
dict
The parameters QuickSight uses to connect to your underlying source.
AmazonElasticsearchParameters (dict) --
Amazon Elasticsearch parameters.
Domain (string) -- [REQUIRED]
The Amazon Elasticsearch domain.
AthenaParameters (dict) --
Athena parameters.
WorkGroup (string) --
The workgroup that Athena uses.
AuroraParameters (dict) --
Aurora MySQL parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
AuroraPostgreSqlParameters (dict) --
Aurora PostgreSQL parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
AwsIotAnalyticsParameters (dict) --
AWS IoT Analytics parameters.
DataSetName (string) -- [REQUIRED]
Dataset name.
JiraParameters (dict) --
Jira parameters.
SiteBaseUrl (string) -- [REQUIRED]
The base URL of the Jira site.
MariaDbParameters (dict) --
MariaDB parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
MySqlParameters (dict) --
MySQL parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
PostgreSqlParameters (dict) --
PostgreSQL parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
PrestoParameters (dict) --
Presto parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Catalog (string) -- [REQUIRED]
Catalog.
RdsParameters (dict) --
RDS parameters.
InstanceId (string) -- [REQUIRED]
Instance ID.
Database (string) -- [REQUIRED]
Database.
RedshiftParameters (dict) --
Redshift parameters.
Host (string) --
Host. This can be blank if the ClusterId is provided.
Port (integer) --
Port. This can be blank if the ClusterId is provided.
Database (string) -- [REQUIRED]
Database.
ClusterId (string) --
Cluster ID. This can be blank if the Host and Port are provided.
S3Parameters (dict) --
S3 parameters.
ManifestFileLocation (dict) -- [REQUIRED]
Location of the Amazon S3 manifest file. This is NULL if the manifest file was uploaded in the console.
Bucket (string) -- [REQUIRED]
Amazon S3 bucket.
Key (string) -- [REQUIRED]
Amazon S3 key that identifies an object.
ServiceNowParameters (dict) --
ServiceNow parameters.
SiteBaseUrl (string) -- [REQUIRED]
URL of the base site.
SnowflakeParameters (dict) --
Snowflake parameters.
Host (string) -- [REQUIRED]
Host.
Database (string) -- [REQUIRED]
Database.
Warehouse (string) -- [REQUIRED]
Warehouse.
SparkParameters (dict) --
Spark parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
SqlServerParameters (dict) --
SQL Server parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
TeradataParameters (dict) --
Teradata parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
TwitterParameters (dict) --
Twitter parameters.
Query (string) -- [REQUIRED]
Twitter query string.
MaxRows (integer) -- [REQUIRED]
Maximum number of rows to query Twitter.
dict
The credentials QuickSight uses to connect to your underlying source. Currently only username/password based credentials are supported.
CredentialPair (dict) --
Credential pair.
Username (string) -- [REQUIRED]
Username.
Password (string) -- [REQUIRED]
Password.
dict
You need to use this parameter only when you want QuickSight to use a VPC connection when connecting to your underlying source.
VpcConnectionArn (string) -- [REQUIRED]
VPC connection ARN.
dict
SSL properties that apply when QuickSight connects to your underlying source.
DisableSsl (boolean) --
A boolean flag to control whether SSL should be disabled.
dict
Response Syntax
{
'Arn': 'string',
'DataSourceId': 'string',
'UpdateStatus': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
Arn (string) --
The ARN of the data source.
DataSourceId (string) --
The ID of the data source. This is unique per AWS Region per AWS account.
UpdateStatus (string) --
The update status of the data source's last update.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Creates and starts a new SPICE ingestion on a dataset
Any ingestions operating on tagged datasets inherit the same tags automatically for use in access-control. For an example, see How do I create an IAM policy to control access to Amazon EC2 resources using tags?. Tags will be visible on the tagged dataset, but not on the ingestion resource.
See also: AWS API Documentation
Request Syntax
client.create_ingestion(
DataSetId='string',
IngestionId='string',
AwsAccountId='string'
)
string
[REQUIRED]
The ID of the dataset used in the ingestion.
string
[REQUIRED]
An ID for the ingestion.
string
[REQUIRED]
The AWS account ID.
dict
Response Syntax
{
'Arn': 'string',
'IngestionId': 'string',
'IngestionStatus': 'INITIALIZED'|'QUEUED'|'RUNNING'|'FAILED'|'COMPLETED'|'CANCELLED',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
Arn (string) --
The Amazon Resource Name (ARN) for the data ingestion.
IngestionId (string) --
An ID for the ingestion.
IngestionStatus (string) --
The ingestion status.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Cancels an on-going ingestion of data into SPICE.
See also: AWS API Documentation
Request Syntax
client.cancel_ingestion(
AwsAccountId='string',
DataSetId='string',
IngestionId='string'
)
string
[REQUIRED]
The AWS account ID.
string
[REQUIRED]
The ID of the dataset used in the ingestion.
string
[REQUIRED]
An ID for the ingestion.
dict
Response Syntax
{
'Arn': 'string',
'IngestionId': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
Arn (string) --
The Amazon Resource Name (ARN) for the data ingestion.
IngestionId (string) --
An ID for the ingestion.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Lists assignments in current QuickSight account.
CLI syntax:
aws quicksight list-iam-policy-assignments --aws-account-id=111122223333 --max-result=5 --assignment-status=ENABLED --namespace=default --region=us-east-1 --next-token=3
See also: AWS API Documentation
Request Syntax
client.list_iam_policy_assignments(
AwsAccountId='string',
AssignmentStatus='ENABLED'|'DRAFT'|'DISABLED',
Namespace='string',
NextToken='string',
MaxResults=123
)
string
[REQUIRED]
The AWS account ID that contains this IAM policy assignment.
string
The status of the assignment.
string
[REQUIRED]
The namespace for this assignment.
string
The token for the next set of results, or null if there are no more results.
integer
The maximum number of results to be returned per request.
dict
Response Syntax
{
'IAMPolicyAssignments': [
{
'AssignmentName': 'string',
'AssignmentStatus': 'ENABLED'|'DRAFT'|'DISABLED'
},
],
'NextToken': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
IAMPolicyAssignments (list) --
Information describing the IAM policy assignments.
(dict) --
IAM policy assignment Summary.
AssignmentName (string) --
Assignment name.
AssignmentStatus (string) --
Assignment status.
NextToken (string) --
The token for the next set of results, or null if there are no more results.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Updates the published version of a dashboard.
CLI syntax:
aws quicksight update-dashboard-published-version --aws-account-id 111122223333 --dashboard-id dashboard-w1 ---version-number 2
See also: AWS API Documentation
Request Syntax
client.update_dashboard_published_version(
AwsAccountId='string',
DashboardId='string',
VersionNumber=123
)
string
[REQUIRED]
AWS account ID that contains the dashboard you are updating.
string
[REQUIRED]
The ID for the dashboard.
integer
[REQUIRED]
The version number of the dashboard.
dict
Response Syntax
{
'DashboardId': 'string',
'DashboardArn': 'string',
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
DashboardId (string) --
The ID for the dashboard.
DashboardArn (string) --
The ARN of the dashboard.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Updates a template from an existing QuickSight analysis.
CLI syntax:
aws quicksight update-template --aws-account-id 111122223333 --template-id reports_test_template --data-set-references DataSetPlaceholder=reports,DataSetArn=arn:aws:quicksight:us-west-2:111122223333:dataset/c684a204-d134-4c53-a63c-451f72c60c28 DataSetPlaceholder=Elblogs,DataSetArn=arn:aws:quicksight:us-west-2:111122223333:dataset/15840b7d-b542-4491-937b-602416b367b3 —source-entity SourceAnalysis=’{Arn=arn:aws:quicksight:us-west-2:111122223333:analysis/c5731fe9-4708-4598-8f6d-cf2a70875b6d}
You can also pass in a json file: aws quicksight update-template —cli-input-json file://create-template.json
See also: AWS API Documentation
Request Syntax
client.update_template(
AwsAccountId='string',
TemplateId='string',
SourceEntity={
'SourceAnalysis': {
'Arn': 'string',
'DataSetReferences': [
{
'DataSetPlaceholder': 'string',
'DataSetArn': 'string'
},
]
},
'SourceTemplate': {
'Arn': 'string'
}
},
VersionDescription='string',
Name='string'
)
string
[REQUIRED]
AWS account ID that contains the template you are updating.
string
[REQUIRED]
The ID for the template.
dict
[REQUIRED]
The source QuickSight entity from which this template is being created. Templates can be currently created from an Analysis or another template.
SourceAnalysis (dict) --
The source analysis, if it is based on an analysis.
Arn (string) -- [REQUIRED]
The Amazon Resource name (ARN) of the resource.
DataSetReferences (list) -- [REQUIRED]
A structure containing information about the dataset references used as placeholders in the template.
(dict) --
Dataset reference.
DataSetPlaceholder (string) -- [REQUIRED]
Dataset placeholder.
DataSetArn (string) -- [REQUIRED]
Dataset ARN.
SourceTemplate (dict) --
The source template, if it is based on an template.
Arn (string) -- [REQUIRED]
The Amazon Resource name (ARN) of the resource.
string
A description of the current template version being created. This API created the first version of the template. Every time UpdateTemplate is called a new version is created. Each version of the template maintains a description of the version in the VersionDescription field.
string
The name for the template.
dict
Response Syntax
{
'TemplateId': 'string',
'Arn': 'string',
'VersionArn': 'string',
'CreationStatus': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
TemplateId (string) --
The ID for the template.
Arn (string) --
The Amazon Resource Name (ARN) for the template.
VersionArn (string) --
The Amazon Resource Name (ARN) for the template, including the version information of the first version.
CreationStatus (string) --
The creation status of the template.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Describes the permissions on a dataset.
The permissions resource is arn:aws:quicksight:region:aws-account-id:dataset/data-set-id
CLI syntax:
aws quicksight describe-data-set-permissions \
--aws-account-id=111122223333 \
--data-set-id=unique-data-set-id \
See also: AWS API Documentation
Request Syntax
client.describe_data_set_permissions(
AwsAccountId='string',
DataSetId='string'
)
string
[REQUIRED]
The AWS Account ID.
string
[REQUIRED]
The ID for the dataset you want to create. This is unique per region per AWS account.
dict
Response Syntax
{
'DataSetArn': 'string',
'DataSetId': 'string',
'Permissions': [
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
DataSetArn (string) --
The ARN of the dataset.
DataSetId (string) --
The ID for the dataset you want to create. This is unique per region per AWS account.
Permissions (list) --
A list of resource permissions on the dataset.
(dict) --
Permission for the resource.
Principal (string) --
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) --
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Updates the template alias of a template.
CLI syntax:
aws quicksight update-template-alias --aws-account-id 111122223333 --template-id 'reports_test_template' --alias-name STAGING —template-version-number 2
See also: AWS API Documentation
Request Syntax
client.update_template_alias(
AwsAccountId='string',
TemplateId='string',
AliasName='string',
TemplateVersionNumber=123
)
string
[REQUIRED]
AWS account ID that contains the template aliases you are updating.
string
[REQUIRED]
The ID for the template.
string
[REQUIRED]
The alias name.
integer
[REQUIRED]
The version number of the template.
dict
Response Syntax
{
'TemplateAlias': {
'AliasName': 'string',
'Arn': 'string',
'TemplateVersionNumber': 123
},
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
TemplateAlias (dict) --
The template alias.
AliasName (string) --
The display name of the template alias.
Arn (string) --
The ARN of the template alias.
TemplateVersionNumber (integer) --
The version number of the template alias.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Creates an assignment with one specified IAM policy ARN and will assigned to specified groups or users of QuickSight. Users and groups need to be in the same namespace.
CLI syntax:
aws quicksight create-iam-policy-assignment --aws-account-id=111122223333 --assignment-name=helpAssignment --policy-arn=arn:aws:iam::aws:policy/AdministratorAccess --identities="user=user5,engineer123,group=QS-Admin" --namespace=default --region=us-west-2
See also: AWS API Documentation
Request Syntax
client.create_iam_policy_assignment(
AwsAccountId='string',
AssignmentName='string',
AssignmentStatus='ENABLED'|'DRAFT'|'DISABLED',
PolicyArn='string',
Identities={
'string': [
'string',
]
},
Namespace='string'
)
string
[REQUIRED]
The AWS Account ID where you want to assign QuickSight users or groups to an IAM policy.
string
[REQUIRED]
The name of the assignment. It must be unique within an AWS account.
string
[REQUIRED]
The status of an assignment:
ENABLED - Anything specified in this assignment is used while creating the data source.
DISABLED - This assignment isn't used while creating the data source.
DRAFT - Assignment is an unfinished draft and isn't used while creating the data source.
string
An IAM policy ARN that you want to apply to the QuickSight users and groups specified in this assignment.
dict
QuickSight users and/or groups that you want to assign the policy to.
(string) --
(list) --
(string) --
string
[REQUIRED]
The namespace that contains the assignment.
dict
Response Syntax
{
'AssignmentName': 'string',
'AssignmentId': 'string',
'AssignmentStatus': 'ENABLED'|'DRAFT'|'DISABLED',
'PolicyArn': 'string',
'Identities': {
'string': [
'string',
]
},
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
AssignmentName (string) --
The name of the assignment. Must be unique within an AWS account.
AssignmentId (string) --
An ID for the assignment.
AssignmentStatus (string) --
The status of an assignment:
ENABLED - Anything specified in this assignment is used while creating the data source.
DISABLED - This assignment isn't used while creating the data source.
DRAFT - Assignment is an unfinished draft and isn't used while creating the data source.
PolicyArn (string) --
An IAM policy ARN that is applied to the QuickSight users and groups specified in this assignment.
Identities (dict) --
QuickSight users and/or groups that are assigned to the IAM policy.
(string) --
(list) --
(string) --
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Deletes a dashboard.
CLI syntax:
aws quicksight delete-dashboard --aws-account-id 111122223333 —dashboard-id 123123123
aws quicksight delete-dashboard --aws-account-id 111122223333 —dashboard-id 123123123 —version-number 3
See also: AWS API Documentation
Request Syntax
client.delete_dashboard(
AwsAccountId='string',
DashboardId='string',
VersionNumber=123
)
string
[REQUIRED]
AWS account ID that contains the dashboard you are deleting.
string
[REQUIRED]
The ID for the dashboard.
integer
The version number of the dashboard. If version number property is provided, only the specified version of the dashboard is deleted.
dict
Response Syntax
{
'Status': 123,
'Arn': 'string',
'DashboardId': 'string',
'RequestId': 'string'
}
Response Structure
(dict) --
Status (integer) --
The http status of the request.
Arn (string) --
The ARN of the resource.
DashboardId (string) --
The ID of the dashboard.
RequestId (string) --
The AWS request ID for this operation.
Lists all of the datasets belonging to this account in an AWS region.
The permissions resource is arn:aws:quicksight:region:aws-account-id:dataset/*
CLI syntax: aws quicksight list-data-sets --aws-account-id=111111111111
See also: AWS API Documentation
Request Syntax
client.list_data_sets(
AwsAccountId='string',
NextToken='string',
MaxResults=123
)
string
[REQUIRED]
The AWS Account ID.
string
The token for the next set of results, or null if there are no more results.
integer
The maximum number of results to be returned per request.
dict
Response Syntax
{
'DataSetSummaries': [
{
'Arn': 'string',
'DataSetId': 'string',
'Name': 'string',
'CreatedTime': datetime(2015, 1, 1),
'LastUpdatedTime': datetime(2015, 1, 1),
'ImportMode': 'SPICE'|'DIRECT_QUERY',
'RowLevelPermissionDataSet': {
'Arn': 'string',
'PermissionPolicy': 'GRANT_ACCESS'|'DENY_ACCESS'
}
},
],
'NextToken': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
DataSetSummaries (list) --
The list of dataset summaries.
(dict) --
Dataset summary.
Arn (string) --
The Amazon Resource name (ARN) of the dataset.
DataSetId (string) --
The ID of the dataset.
Name (string) --
A display name for the dataset.
CreatedTime (datetime) --
The time this was created.
LastUpdatedTime (datetime) --
The last time this was updated.
ImportMode (string) --
Indicates whether or not you want to import the data into SPICE.
RowLevelPermissionDataSet (dict) --
Row-level security configuration on the dataset.
Arn (string) --
The Amazon Resource name (ARN) of the permission dataset.
PermissionPolicy (string) --
Permission policy.
NextToken (string) --
The token for the next set of results, or null if there are no more results.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Provides a summary for a dashboard.
CLI syntax:
aws quicksight describe-dashboard --aws-account-id 111122223333 —dashboard-id reports_test_report -version-number 2
aws quicksight describe-dashboard --aws-account-id 111122223333 —dashboard-id reports_test_report -alias-name ‘$PUBLISHED’
See also: AWS API Documentation
Request Syntax
client.describe_dashboard(
AwsAccountId='string',
DashboardId='string',
VersionNumber=123,
AliasName='string'
)
string
[REQUIRED]
AWS account ID that contains the dashboard you are describing.
string
[REQUIRED]
The ID for the dashboard.
integer
The version number for the dashboard. If version number isn’t passed the latest published dashboard version is described.
string
The alias name.
dict
Response Syntax
{
'Dashboard': {
'DashboardId': 'string',
'Arn': 'string',
'Name': 'string',
'Version': {
'CreatedTime': datetime(2015, 1, 1),
'Errors': [
{
'Type': 'DATA_SET_NOT_FOUND'|'INTERNAL_FAILURE'|'PARAMETER_VALUE_INCOMPATIBLE'|'PARAMETER_TYPE_INVALID'|'PARAMETER_NOT_FOUND'|'COLUMN_TYPE_MISMATCH'|'COLUMN_GEOGRAPHIC_ROLE_MISMATCH'|'COLUMN_REPLACEMENT_MISSING',
'Message': 'string'
},
],
'VersionNumber': 123,
'Status': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'Arn': 'string',
'SourceEntityArn': 'string',
'Description': 'string'
},
'CreatedTime': datetime(2015, 1, 1),
'LastPublishedTime': datetime(2015, 1, 1),
'LastUpdatedTime': datetime(2015, 1, 1)
},
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
Dashboard (dict) --
Information about the dashboard.
DashboardId (string) --
Dashboard ID.
Arn (string) --
The Amazon Resource name (ARN) of the resource.
Name (string) --
A display name for the dataset.
Version (dict) --
Version.
CreatedTime (datetime) --
The time this was created.
Errors (list) --
Errors.
(dict) --
Dashboard error.
Type (string) --
Type.
Message (string) --
Message.
VersionNumber (integer) --
Version number.
Status (string) --
The http status of the request.
Arn (string) --
The Amazon Resource name (ARN) of the resource.
SourceEntityArn (string) --
Source entity ARN.
Description (string) --
Description.
CreatedTime (datetime) --
The time this was created.
LastPublishedTime (datetime) --
The last time this was published.
LastUpdatedTime (datetime) --
The last time this was updated.
Status (integer) --
The http status of this request.
RequestId (string) --
The AWS request ID for this operation.
Lists all the templates in the QuickSight account.
CLI syntax:
aws quicksight list-templates --aws-account-id 111122223333 --max-results 1 —next-token AYADeJuxwOypAndSoOn
See also: AWS API Documentation
Request Syntax
client.list_templates(
AwsAccountId='string',
NextToken='string',
MaxResults=123
)
string
[REQUIRED]
AWS account ID that contains the templates you are listing.
string
The token for the next set of results, or null if there are no more results.
integer
The maximum number of results to be returned per request.
dict
Response Syntax
{
'TemplateSummaryList': [
{
'Arn': 'string',
'TemplateId': 'string',
'Name': 'string',
'LatestVersionNumber': 123,
'CreatedTime': datetime(2015, 1, 1),
'LastUpdatedTime': datetime(2015, 1, 1)
},
],
'NextToken': 'string',
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
TemplateSummaryList (list) --
A structure containing information about the templates in the list.
(dict) --
The template summary.
Arn (string) --
A summary of a template.
TemplateId (string) --
The ID of the template. This is unique per region per AWS account.
Name (string) --
A display name for the template.
LatestVersionNumber (integer) --
A structure containing a list of version numbers for the template summary.
CreatedTime (datetime) --
The last time this was created.
LastUpdatedTime (datetime) --
The last time this was updated.
NextToken (string) --
The token for the next set of results, or null if there are no more results.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Updates a dashboard in the AWS account.
CLI syntax:
aws quicksight update-dashboard --aws-account-id 111122223333 --dashboard-id 123123123 --dashboard-name "test-update102" --source-entity SourceTemplate={Arn=arn:aws:quicksight:us-west-2:111122223333:template/sales-report-template2} --data-set-references DataSetPlaceholder=SalesDataSet,DataSetArn=arn:aws:quicksight:us-west-2:111122223333:dataset/0e251aef-9ebf-46e1-b852-eb4fa33c1d3a
aws quicksight update-dashboard --cli-input-json file://update-dashboard.json
See also: AWS API Documentation
Request Syntax
client.update_dashboard(
AwsAccountId='string',
DashboardId='string',
Name='string',
SourceEntity={
'SourceTemplate': {
'DataSetReferences': [
{
'DataSetPlaceholder': 'string',
'DataSetArn': 'string'
},
],
'Arn': 'string'
}
},
Parameters={
'StringParameters': [
{
'Name': 'string',
'Values': [
'string',
]
},
],
'IntegerParameters': [
{
'Name': 'string',
'Values': [
123,
]
},
],
'DecimalParameters': [
{
'Name': 'string',
'Values': [
123.0,
]
},
],
'DateTimeParameters': [
{
'Name': 'string',
'Values': [
datetime(2015, 1, 1),
]
},
]
},
VersionDescription='string',
DashboardPublishOptions={
'AdHocFilteringOption': {
'AvailabilityStatus': 'ENABLED'|'DISABLED'
},
'ExportToCSVOption': {
'AvailabilityStatus': 'ENABLED'|'DISABLED'
},
'SheetControlsOption': {
'VisibilityState': 'EXPANDED'|'COLLAPSED'
}
}
)
string
[REQUIRED]
AWS account ID that contains the dashboard you are updating.
string
[REQUIRED]
The ID for the dashboard.
string
[REQUIRED]
The display name of the dashboard.
dict
[REQUIRED]
The template or analysis from which the dashboard is created. The SouceTemplate entity accepts the Arn of the template and also references to replacement datasets for the placeholders set when creating the template. The replacement datasets need to follow the same schema as the datasets for which placeholders were created when creating the template.
SourceTemplate (dict) --
Source template.
DataSetReferences (list) -- [REQUIRED]
Dataset references.
(dict) --
Dataset reference.
DataSetPlaceholder (string) -- [REQUIRED]
Dataset placeholder.
DataSetArn (string) -- [REQUIRED]
Dataset ARN.
Arn (string) -- [REQUIRED]
The Amazon Resource name (ARN) of the resource.
dict
A structure that contains the parameters of the dashboard.
StringParameters (list) --
String parameters.
(dict) --
String parameter.
Name (string) -- [REQUIRED]
A display name for the dataset.
Values (list) -- [REQUIRED]
Values.
(string) --
IntegerParameters (list) --
Integer parameters.
(dict) --
Integer parameter.
Name (string) -- [REQUIRED]
A display name for the dataset.
Values (list) -- [REQUIRED]
Values.
(integer) --
DecimalParameters (list) --
Decimal parameters.
(dict) --
Decimal parameter.
Name (string) -- [REQUIRED]
A display name for the dataset.
Values (list) -- [REQUIRED]
Values.
(float) --
DateTimeParameters (list) --
DateTime parameters.
(dict) --
Date time parameter.
Name (string) -- [REQUIRED]
A display name for the dataset.
Values (list) -- [REQUIRED]
Values.
(datetime) --
string
A description for the first version of the dashboard being created.
dict
Publishing options when creating a dashboard.
AvailabilityStatus for AdHocFilteringOption - This can be either ENABLED or DISABLED . When This is set to set to DISABLED , QuickSight disables the left filter pane on the published dashboard, which can be used for AdHoc filtering. Enabled by default.
AvailabilityStatus for ExportToCSVOption - This can be either ENABLED or DISABLED . The visual option to export data to CSV is disabled when this is set to DISABLED . Enabled by default.
VisibilityState for SheetControlsOption - This can be either COLLAPSED or EXPANDED . The sheet controls pane is collapsed by default when set to true. Collapsed by default.
AdHocFilteringOption (dict) --
Ad hoc filtering option.
AvailabilityStatus (string) --
Availability status.
ExportToCSVOption (dict) --
Export to CSV option.
AvailabilityStatus (string) --
Availability status.
SheetControlsOption (dict) --
Sheet controls option.
VisibilityState (string) --
Visibility state.
dict
Response Syntax
{
'Arn': 'string',
'VersionArn': 'string',
'DashboardId': 'string',
'CreationStatus': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
Arn (string) --
The ARN of the resource.
VersionArn (string) --
The ARN of the dashboard, including the version number.
DashboardId (string) --
The ID for the dashboard.
CreationStatus (string) --
The creation status of the request.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Updates a dataset.
CLI syntax:
aws quicksight update-data-set \
--aws-account-id=111122223333 \
--data-set-id=unique-data-set-id \
--name='My dataset' \
--import-mode=SPICE \
--physical-table-map='{
"physical-table-id": {
"RelationalTable": {
"DataSourceArn": "arn:aws:quicksight:us-west-2:111111111111:datasource/data-source-id",
"Name": "table1",
"InputColumns": [
{
"Name": "column1",
"Type": "STRING"
}
]
}
}'
See also: AWS API Documentation
Request Syntax
client.update_data_set(
AwsAccountId='string',
DataSetId='string',
Name='string',
PhysicalTableMap={
'string': {
'RelationalTable': {
'DataSourceArn': 'string',
'Schema': 'string',
'Name': 'string',
'InputColumns': [
{
'Name': 'string',
'Type': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME'|'BIT'|'BOOLEAN'|'JSON'
},
]
},
'CustomSql': {
'DataSourceArn': 'string',
'Name': 'string',
'SqlQuery': 'string',
'Columns': [
{
'Name': 'string',
'Type': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME'|'BIT'|'BOOLEAN'|'JSON'
},
]
},
'S3Source': {
'DataSourceArn': 'string',
'UploadSettings': {
'Format': 'CSV'|'TSV'|'CLF'|'ELF'|'XLSX'|'JSON',
'StartFromRow': 123,
'ContainsHeader': True|False,
'TextQualifier': 'DOUBLE_QUOTE'|'SINGLE_QUOTE',
'Delimiter': 'string'
},
'InputColumns': [
{
'Name': 'string',
'Type': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME'|'BIT'|'BOOLEAN'|'JSON'
},
]
}
}
},
LogicalTableMap={
'string': {
'Alias': 'string',
'DataTransforms': [
{
'ProjectOperation': {
'ProjectedColumns': [
'string',
]
},
'FilterOperation': {
'ConditionExpression': 'string'
},
'CreateColumnsOperation': {
'Columns': [
{
'ColumnName': 'string',
'ColumnId': 'string',
'Expression': 'string'
},
]
},
'RenameColumnOperation': {
'ColumnName': 'string',
'NewColumnName': 'string'
},
'CastColumnTypeOperation': {
'ColumnName': 'string',
'NewColumnType': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME',
'Format': 'string'
},
'TagColumnOperation': {
'ColumnName': 'string',
'Tags': [
{
'ColumnGeographicRole': 'COUNTRY'|'STATE'|'COUNTY'|'CITY'|'POSTCODE'|'LONGITUDE'|'LATITUDE'
},
]
}
},
],
'Source': {
'JoinInstruction': {
'LeftOperand': 'string',
'RightOperand': 'string',
'Type': 'INNER'|'OUTER'|'LEFT'|'RIGHT',
'OnClause': 'string'
},
'PhysicalTableId': 'string'
}
}
},
ImportMode='SPICE'|'DIRECT_QUERY',
ColumnGroups=[
{
'GeoSpatialColumnGroup': {
'Name': 'string',
'CountryCode': 'US',
'Columns': [
'string',
]
}
},
],
RowLevelPermissionDataSet={
'Arn': 'string',
'PermissionPolicy': 'GRANT_ACCESS'|'DENY_ACCESS'
}
)
string
[REQUIRED]
The AWS Account ID.
string
[REQUIRED]
The ID for the dataset you want to create. This is unique per region per AWS account.
string
[REQUIRED]
The display name for the dataset.
dict
[REQUIRED]
Declares the physical tables that are available in the underlying data sources.
(string) --
(dict) --
A view of a data source. Contains information on the shape of the data in the underlying source. This is a variant type structure. No more than one of the attributes can be non-null for this structure to be valid.
RelationalTable (dict) --
A physical table type for relational data sources.
DataSourceArn (string) -- [REQUIRED]
Data source ARN.
Schema (string) --
The schema name. Applies to certain relational database engines.
Name (string) -- [REQUIRED]
Name of the relational table.
InputColumns (list) -- [REQUIRED]
The column schema of the table.
(dict) --
Metadata on a column that is used as the input of a transform operation.
Name (string) -- [REQUIRED]
The name of this column in the underlying data source.
Type (string) -- [REQUIRED]
The data type of the column.
CustomSql (dict) --
A physical table type built from the results of the custom SQL query.
DataSourceArn (string) -- [REQUIRED]
The ARN of the data source.
Name (string) -- [REQUIRED]
A display name for the SQL query result.
SqlQuery (string) -- [REQUIRED]
The SQL query.
Columns (list) --
The column schema from the SQL query result set.
(dict) --
Metadata on a column that is used as the input of a transform operation.
Name (string) -- [REQUIRED]
The name of this column in the underlying data source.
Type (string) -- [REQUIRED]
The data type of the column.
S3Source (dict) --
A physical table type for as S3 data source.
DataSourceArn (string) -- [REQUIRED]
Data source ARN.
UploadSettings (dict) --
Information on the S3 source file(s) format.
Format (string) --
File format.
StartFromRow (integer) --
A row number to start reading data from.
ContainsHeader (boolean) --
Whether or not the file(s) has a header row.
TextQualifier (string) --
Text qualifier.
Delimiter (string) --
The delimiter between values in the file.
InputColumns (list) -- [REQUIRED]
A physical table type for as S3 data source.
(dict) --
Metadata on a column that is used as the input of a transform operation.
Name (string) -- [REQUIRED]
The name of this column in the underlying data source.
Type (string) -- [REQUIRED]
The data type of the column.
dict
Configures the combination and transformation of the data from the physical tables.
(string) --
(dict) --
A unit that joins and data transformations operate on. A logical table has a source, which can be either a physical table or result of a join. When it points to a physical table, a logical table acts as a mutable copy of that table through transform operations.
Alias (string) -- [REQUIRED]
A display name for the logical table.
DataTransforms (list) --
Transform operations that act on this logical table.
(dict) --
A data transformation on a logical table. This is a variant type structure. No more than one of the attributes should be non-null for this structure to be valid.
ProjectOperation (dict) --
An operation that projects columns. Operations that come after a projection can only refer to projected columns.
ProjectedColumns (list) -- [REQUIRED]
Projected columns.
(string) --
FilterOperation (dict) --
An operation that filters rows based on some condition.
ConditionExpression (string) -- [REQUIRED]
An expression that must evaluate to a boolean value. Rows for which the expression is evaluated to true are kept in the dataset.
CreateColumnsOperation (dict) --
An operation that creates calculated columns. Columns created in one such operation form a lexical closure.
Columns (list) -- [REQUIRED]
Calculated columns to create.
(dict) --
A calculated column for a dataset.
ColumnName (string) -- [REQUIRED]
Column name.
ColumnId (string) -- [REQUIRED]
A unique ID to identify a calculated column. During dataset update, if the column ID of a calculated column matches that of an existing calculated column, QuickSight preserves the existing calculated column.
Expression (string) -- [REQUIRED]
An expression that defines the calculated column.
RenameColumnOperation (dict) --
An operation that renames a column.
ColumnName (string) -- [REQUIRED]
Name of the column to be renamed.
NewColumnName (string) -- [REQUIRED]
New name for the column.
CastColumnTypeOperation (dict) --
A transform operation that casts a column to a different type.
ColumnName (string) -- [REQUIRED]
Column name.
NewColumnType (string) -- [REQUIRED]
New column data type.
Format (string) --
When casting a column from string to datetime type, you can supply a QuickSight supported format string to denote the source data format.
TagColumnOperation (dict) --
An operation that tags a column with additional information.
ColumnName (string) -- [REQUIRED]
The column that this operation acts on.
Tags (list) -- [REQUIRED]
The dataset column tag, currently only used for geospatial type tagging. .
Note
This is not tags for the AWS tagging feature. .
(dict) --
A tag for a column in a TagColumnOperation. This is a variant type structure. No more than one of the attributes should be non-null for this structure to be valid.
ColumnGeographicRole (string) --
A geospatial role for a column.
Source (dict) -- [REQUIRED]
Source of this logical table.
JoinInstruction (dict) --
Specifies the result of a join of two logical tables.
LeftOperand (string) -- [REQUIRED]
Left operand.
RightOperand (string) -- [REQUIRED]
Right operand.
Type (string) -- [REQUIRED]
Type.
OnClause (string) -- [REQUIRED]
On Clause.
PhysicalTableId (string) --
Physical table ID.
string
[REQUIRED]
Indicates whether or not you want to import the data into SPICE.
list
Groupings of columns that work together in certain QuickSight features. Currently only geospatial hierarchy is supported.
(dict) --
Groupings of columns that work together in certain QuickSight features. This is a variant type structure. No more than one of the attributes should be non-null for this structure to be valid.
GeoSpatialColumnGroup (dict) --
Geospatial column group that denotes a hierarchy.
Name (string) -- [REQUIRED]
A display name for the hierarchy.
CountryCode (string) -- [REQUIRED]
Country code.
Columns (list) -- [REQUIRED]
Columns in this hierarchy.
(string) --
dict
Row-level security configuration on the data you want to create.
Arn (string) -- [REQUIRED]
The Amazon Resource name (ARN) of the permission dataset.
PermissionPolicy (string) -- [REQUIRED]
Permission policy.
dict
Response Syntax
{
'Arn': 'string',
'DataSetId': 'string',
'IngestionArn': 'string',
'IngestionId': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
Arn (string) --
The ARN of the dataset.
DataSetId (string) --
The ID for the dataset you want to create. This is unique per region per AWS account.
IngestionArn (string) --
The Amazon Resource Name (ARN) for the ingestion, which is triggered as a result of dataset creation if the import mode is SPICE
IngestionId (string) --
The ID of the ingestion, which is triggered as a result of dataset creation if the import mode is SPICE
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Creates a data source.
The permissions resource is arn:aws:quicksight:region:aws-account-id:datasource/data-source-id
CLI syntax:
aws quicksight create-data-source \
--aws-account-id=111122223333 \
--data-source-id=unique-data-source-id \
--name='My Data Source' \
--type=POSTGRESQL \
--data-source-parameters='{ "PostgreSqlParameters": {
"Host": "my-db-host.example.com",
"Port": 1234,
"Database": "my-db" } }' \
--credentials='{ "CredentialPair": {
"Username": "username",
"Password": "password" } }'
See also: AWS API Documentation
Request Syntax
client.create_data_source(
AwsAccountId='string',
DataSourceId='string',
Name='string',
Type='ADOBE_ANALYTICS'|'AMAZON_ELASTICSEARCH'|'ATHENA'|'AURORA'|'AURORA_POSTGRESQL'|'AWS_IOT_ANALYTICS'|'GITHUB'|'JIRA'|'MARIADB'|'MYSQL'|'POSTGRESQL'|'PRESTO'|'REDSHIFT'|'S3'|'SALESFORCE'|'SERVICENOW'|'SNOWFLAKE'|'SPARK'|'SQLSERVER'|'TERADATA'|'TWITTER',
DataSourceParameters={
'AmazonElasticsearchParameters': {
'Domain': 'string'
},
'AthenaParameters': {
'WorkGroup': 'string'
},
'AuroraParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'AuroraPostgreSqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'AwsIotAnalyticsParameters': {
'DataSetName': 'string'
},
'JiraParameters': {
'SiteBaseUrl': 'string'
},
'MariaDbParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'MySqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'PostgreSqlParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'PrestoParameters': {
'Host': 'string',
'Port': 123,
'Catalog': 'string'
},
'RdsParameters': {
'InstanceId': 'string',
'Database': 'string'
},
'RedshiftParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string',
'ClusterId': 'string'
},
'S3Parameters': {
'ManifestFileLocation': {
'Bucket': 'string',
'Key': 'string'
}
},
'ServiceNowParameters': {
'SiteBaseUrl': 'string'
},
'SnowflakeParameters': {
'Host': 'string',
'Database': 'string',
'Warehouse': 'string'
},
'SparkParameters': {
'Host': 'string',
'Port': 123
},
'SqlServerParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'TeradataParameters': {
'Host': 'string',
'Port': 123,
'Database': 'string'
},
'TwitterParameters': {
'Query': 'string',
'MaxRows': 123
}
},
Credentials={
'CredentialPair': {
'Username': 'string',
'Password': 'string'
}
},
Permissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
VpcConnectionProperties={
'VpcConnectionArn': 'string'
},
SslProperties={
'DisableSsl': True|False
},
Tags=[
{
'Key': 'string',
'Value': 'string'
},
]
)
string
[REQUIRED]
The AWS account ID.
string
[REQUIRED]
An ID for the data source. This is unique per AWS Region per AWS account.
string
[REQUIRED]
A display name for the data source.
string
[REQUIRED]
The type of the data source. Currently the supported types for this operation are: ATHENA, AURORA, AURORA_POSTGRESQL, MARIADB, MYSQL, POSTGRESQL, PRESTO, REDSHIFT, S3, SNOWFLAKE, SPARK, SQLSERVER, TERADATA . Use ListDataSources to return a list of all data sources.
dict
The parameters QuickSight uses to connect to your underlying source.
AmazonElasticsearchParameters (dict) --
Amazon Elasticsearch parameters.
Domain (string) -- [REQUIRED]
The Amazon Elasticsearch domain.
AthenaParameters (dict) --
Athena parameters.
WorkGroup (string) --
The workgroup that Athena uses.
AuroraParameters (dict) --
Aurora MySQL parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
AuroraPostgreSqlParameters (dict) --
Aurora PostgreSQL parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
AwsIotAnalyticsParameters (dict) --
AWS IoT Analytics parameters.
DataSetName (string) -- [REQUIRED]
Dataset name.
JiraParameters (dict) --
Jira parameters.
SiteBaseUrl (string) -- [REQUIRED]
The base URL of the Jira site.
MariaDbParameters (dict) --
MariaDB parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
MySqlParameters (dict) --
MySQL parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
PostgreSqlParameters (dict) --
PostgreSQL parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
PrestoParameters (dict) --
Presto parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Catalog (string) -- [REQUIRED]
Catalog.
RdsParameters (dict) --
RDS parameters.
InstanceId (string) -- [REQUIRED]
Instance ID.
Database (string) -- [REQUIRED]
Database.
RedshiftParameters (dict) --
Redshift parameters.
Host (string) --
Host. This can be blank if the ClusterId is provided.
Port (integer) --
Port. This can be blank if the ClusterId is provided.
Database (string) -- [REQUIRED]
Database.
ClusterId (string) --
Cluster ID. This can be blank if the Host and Port are provided.
S3Parameters (dict) --
S3 parameters.
ManifestFileLocation (dict) -- [REQUIRED]
Location of the Amazon S3 manifest file. This is NULL if the manifest file was uploaded in the console.
Bucket (string) -- [REQUIRED]
Amazon S3 bucket.
Key (string) -- [REQUIRED]
Amazon S3 key that identifies an object.
ServiceNowParameters (dict) --
ServiceNow parameters.
SiteBaseUrl (string) -- [REQUIRED]
URL of the base site.
SnowflakeParameters (dict) --
Snowflake parameters.
Host (string) -- [REQUIRED]
Host.
Database (string) -- [REQUIRED]
Database.
Warehouse (string) -- [REQUIRED]
Warehouse.
SparkParameters (dict) --
Spark parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
SqlServerParameters (dict) --
SQL Server parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
TeradataParameters (dict) --
Teradata parameters.
Host (string) -- [REQUIRED]
Host.
Port (integer) -- [REQUIRED]
Port.
Database (string) -- [REQUIRED]
Database.
TwitterParameters (dict) --
Twitter parameters.
Query (string) -- [REQUIRED]
Twitter query string.
MaxRows (integer) -- [REQUIRED]
Maximum number of rows to query Twitter.
dict
The credentials QuickSight uses to connect to your underlying source. Currently only username/password based credentials are supported.
CredentialPair (dict) --
Credential pair.
Username (string) -- [REQUIRED]
Username.
Password (string) -- [REQUIRED]
Password.
list
A list of resource permissions on the data source.
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
dict
You need to use this parameter only when you want QuickSight to use a VPC connection when connecting to your underlying source.
VpcConnectionArn (string) -- [REQUIRED]
VPC connection ARN.
dict
SSL properties that apply when QuickSight connects to your underlying source.
DisableSsl (boolean) --
A boolean flag to control whether SSL should be disabled.
list
Contains a map of the key-value pairs for the resource tag or tags assigned to the data source.
(dict) --
The keys of the key-value pairs for the resource tag or tags assigned to the resource.
Key (string) -- [REQUIRED]
Tag key.
Value (string) -- [REQUIRED]
Tag value.
dict
Response Syntax
{
'Arn': 'string',
'DataSourceId': 'string',
'CreationStatus': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
Arn (string) --
The ARN of the data source.
DataSourceId (string) --
The ID of the data source. This is unique per AWS Region per AWS account.
CreationStatus (string) --
The status of creating the data source.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Lists the history of SPICE ingestions for a dataset.
See also: AWS API Documentation
Request Syntax
client.list_ingestions(
DataSetId='string',
NextToken='string',
AwsAccountId='string',
MaxResults=123
)
string
[REQUIRED]
The ID of the dataset used in the ingestion.
string
The token for the next set of results, or null if there are no more results.
string
[REQUIRED]
The AWS account ID.
integer
The maximum number of results to be returned per request.
dict
Response Syntax
{
'Ingestions': [
{
'Arn': 'string',
'IngestionId': 'string',
'IngestionStatus': 'INITIALIZED'|'QUEUED'|'RUNNING'|'FAILED'|'COMPLETED'|'CANCELLED',
'ErrorInfo': {
'Type': 'FAILURE_TO_ASSUME_ROLE'|'INGESTION_SUPERSEDED'|'INGESTION_CANCELED'|'DATA_SET_DELETED'|'DATA_SET_NOT_SPICE'|'S3_UPLOADED_FILE_DELETED'|'S3_MANIFEST_ERROR'|'DATA_TOLERANCE_EXCEPTION'|'SPICE_TABLE_NOT_FOUND'|'DATA_SET_SIZE_LIMIT_EXCEEDED'|'ROW_SIZE_LIMIT_EXCEEDED'|'ACCOUNT_CAPACITY_LIMIT_EXCEEDED'|'CUSTOMER_ERROR'|'DATA_SOURCE_NOT_FOUND'|'IAM_ROLE_NOT_AVAILABLE'|'CONNECTION_FAILURE'|'SQL_TABLE_NOT_FOUND'|'PERMISSION_DENIED'|'SSL_CERTIFICATE_VALIDATION_FAILURE'|'OAUTH_TOKEN_FAILURE'|'SOURCE_API_LIMIT_EXCEEDED_FAILURE'|'PASSWORD_AUTHENTICATION_FAILURE'|'SQL_SCHEMA_MISMATCH_ERROR'|'INVALID_DATE_FORMAT'|'INVALID_DATAPREP_SYNTAX'|'SOURCE_RESOURCE_LIMIT_EXCEEDED'|'SQL_INVALID_PARAMETER_VALUE'|'QUERY_TIMEOUT'|'SQL_NUMERIC_OVERFLOW'|'UNRESOLVABLE_HOST'|'UNROUTABLE_HOST'|'SQL_EXCEPTION'|'S3_FILE_INACCESSIBLE'|'IOT_FILE_NOT_FOUND'|'IOT_DATA_SET_FILE_EMPTY'|'INVALID_DATA_SOURCE_CONFIG'|'DATA_SOURCE_AUTH_FAILED'|'DATA_SOURCE_CONNECTION_FAILED'|'FAILURE_TO_PROCESS_JSON_FILE'|'INTERNAL_SERVICE_ERROR',
'Message': 'string'
},
'RowInfo': {
'RowsIngested': 123,
'RowsDropped': 123
},
'QueueInfo': {
'WaitingOnIngestion': 'string',
'QueuedIngestion': 'string'
},
'CreatedTime': datetime(2015, 1, 1),
'IngestionTimeInSeconds': 123,
'IngestionSizeInBytes': 123,
'RequestSource': 'MANUAL'|'SCHEDULED',
'RequestType': 'INITIAL_INGESTION'|'EDIT'|'INCREMENTAL_REFRESH'|'FULL_REFRESH'
},
],
'NextToken': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
Ingestions (list) --
A list of the ingestions.
(dict) --
Information on the SPICE ingestion for a dataset.
Arn (string) --
The Amazon Resource name (ARN) of the resource.
IngestionId (string) --
Ingestion ID.
IngestionStatus (string) --
Ingestion status.
ErrorInfo (dict) --
Error information for this ingestion.
Type (string) --
Error type.
Message (string) --
Error essage.
RowInfo (dict) --
Information on rows during a data set SPICE ingestion.
RowsIngested (integer) --
The number of rows that were ingested.
RowsDropped (integer) --
The number of rows that were not ingested.
QueueInfo (dict) --
Information on queued dataset SPICE ingestion.
WaitingOnIngestion (string) --
The ID of the queued ingestion.
QueuedIngestion (string) --
The ID of the ongoing ingestion. The queued ingestion is waiting for the ongoing ingestion to complete.
CreatedTime (datetime) --
The time this ingestion started.
IngestionTimeInSeconds (integer) --
The time this ingestion took, measured in seconds.
IngestionSizeInBytes (integer) --
Size of the data ingested in bytes.
RequestSource (string) --
Event source for this ingestion.
RequestType (string) --
Type of this ingestion.
NextToken (string) --
The token for the next set of results, or null if there are no more results.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Updates the permissions to a data source.
The permissions resource is arn:aws:quicksight:region:aws-account-id:datasource/data-source-id
CLI syntax:
aws quicksight update-data-source-permissions \
--aws-account-id=111122223333 \
--data-source-id=unique-data-source-id \
--name='My Data Source' \
--grant-permissions='[{"Principal":"arn:aws:quicksight:us-east-1:111122223333:user/default/user1","Actions":["quicksight:DescribeDataSource","quicksight:DescribeDataSourcePermissions","quicksight:PassDataSource"]}]' \
--revoke-permissions='[{"Principal":"arn:aws:quicksight:us-east-1:111122223333:user/default/user2","Actions":["quicksight:UpdateDataSource","quicksight:DeleteDataSource","quicksight:UpdateDataSourcePermissions"]}]'
See also: AWS API Documentation
Request Syntax
client.update_data_source_permissions(
AwsAccountId='string',
DataSourceId='string',
GrantPermissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
RevokePermissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
]
)
string
[REQUIRED]
The AWS account ID.
string
[REQUIRED]
The ID of the data source. This is unique per AWS Region per AWS account.
list
A list of resource permissions that you want to grant on the data source.
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
list
A list of resource permissions that you want to revoke on the data source.
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
dict
Response Syntax
{
'DataSourceArn': 'string',
'DataSourceId': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
DataSourceArn (string) --
The ARN of the data source.
DataSourceId (string) --
The ID of the data source. This is unique per AWS Region per AWS account.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Deletes an existing assignment.
CLI syntax:
aws quicksight delete-iam-policy-assignment --aws-account-id=111122223333 --assignment-name=testtest --region=us-east-1 --namespace=default
See also: AWS API Documentation
Request Syntax
client.delete_iam_policy_assignment(
AwsAccountId='string',
AssignmentName='string',
Namespace='string'
)
string
[REQUIRED]
The AWS account ID where you want to delete an IAM policy assignment.
string
[REQUIRED]
The name of the assignment.
string
[REQUIRED]
The namespace that contains the assignment.
dict
Response Syntax
{
'AssignmentName': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
AssignmentName (string) --
The name of the assignment.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Creates a dataset.
CLI syntax:
aws quicksight create-data-set \
--aws-account-id=111122223333 \
--data-set-id=unique-data-set-id \
--name='My dataset' \
--import-mode=SPICE \
--physical-table-map='{
"physical-table-id": {
"RelationalTable": {
"DataSourceArn": "arn:aws:quicksight:us-west-2:111111111111:datasource/data-source-id",
"Name": "table1",
"InputColumns": [
{
"Name": "column1",
"Type": "STRING"
}
]
}
}'
See also: AWS API Documentation
Request Syntax
client.create_data_set(
AwsAccountId='string',
DataSetId='string',
Name='string',
PhysicalTableMap={
'string': {
'RelationalTable': {
'DataSourceArn': 'string',
'Schema': 'string',
'Name': 'string',
'InputColumns': [
{
'Name': 'string',
'Type': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME'|'BIT'|'BOOLEAN'|'JSON'
},
]
},
'CustomSql': {
'DataSourceArn': 'string',
'Name': 'string',
'SqlQuery': 'string',
'Columns': [
{
'Name': 'string',
'Type': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME'|'BIT'|'BOOLEAN'|'JSON'
},
]
},
'S3Source': {
'DataSourceArn': 'string',
'UploadSettings': {
'Format': 'CSV'|'TSV'|'CLF'|'ELF'|'XLSX'|'JSON',
'StartFromRow': 123,
'ContainsHeader': True|False,
'TextQualifier': 'DOUBLE_QUOTE'|'SINGLE_QUOTE',
'Delimiter': 'string'
},
'InputColumns': [
{
'Name': 'string',
'Type': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME'|'BIT'|'BOOLEAN'|'JSON'
},
]
}
}
},
LogicalTableMap={
'string': {
'Alias': 'string',
'DataTransforms': [
{
'ProjectOperation': {
'ProjectedColumns': [
'string',
]
},
'FilterOperation': {
'ConditionExpression': 'string'
},
'CreateColumnsOperation': {
'Columns': [
{
'ColumnName': 'string',
'ColumnId': 'string',
'Expression': 'string'
},
]
},
'RenameColumnOperation': {
'ColumnName': 'string',
'NewColumnName': 'string'
},
'CastColumnTypeOperation': {
'ColumnName': 'string',
'NewColumnType': 'STRING'|'INTEGER'|'DECIMAL'|'DATETIME',
'Format': 'string'
},
'TagColumnOperation': {
'ColumnName': 'string',
'Tags': [
{
'ColumnGeographicRole': 'COUNTRY'|'STATE'|'COUNTY'|'CITY'|'POSTCODE'|'LONGITUDE'|'LATITUDE'
},
]
}
},
],
'Source': {
'JoinInstruction': {
'LeftOperand': 'string',
'RightOperand': 'string',
'Type': 'INNER'|'OUTER'|'LEFT'|'RIGHT',
'OnClause': 'string'
},
'PhysicalTableId': 'string'
}
}
},
ImportMode='SPICE'|'DIRECT_QUERY',
ColumnGroups=[
{
'GeoSpatialColumnGroup': {
'Name': 'string',
'CountryCode': 'US',
'Columns': [
'string',
]
}
},
],
Permissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
RowLevelPermissionDataSet={
'Arn': 'string',
'PermissionPolicy': 'GRANT_ACCESS'|'DENY_ACCESS'
},
Tags=[
{
'Key': 'string',
'Value': 'string'
},
]
)
string
[REQUIRED]
The AWS Account ID.
string
[REQUIRED]
An ID for the dataset you want to create. This is unique per region per AWS account.
string
[REQUIRED]
The display name for the dataset.
dict
[REQUIRED]
Declares the physical tables that are available in the underlying data sources.
(string) --
(dict) --
A view of a data source. Contains information on the shape of the data in the underlying source. This is a variant type structure. No more than one of the attributes can be non-null for this structure to be valid.
RelationalTable (dict) --
A physical table type for relational data sources.
DataSourceArn (string) -- [REQUIRED]
Data source ARN.
Schema (string) --
The schema name. Applies to certain relational database engines.
Name (string) -- [REQUIRED]
Name of the relational table.
InputColumns (list) -- [REQUIRED]
The column schema of the table.
(dict) --
Metadata on a column that is used as the input of a transform operation.
Name (string) -- [REQUIRED]
The name of this column in the underlying data source.
Type (string) -- [REQUIRED]
The data type of the column.
CustomSql (dict) --
A physical table type built from the results of the custom SQL query.
DataSourceArn (string) -- [REQUIRED]
The ARN of the data source.
Name (string) -- [REQUIRED]
A display name for the SQL query result.
SqlQuery (string) -- [REQUIRED]
The SQL query.
Columns (list) --
The column schema from the SQL query result set.
(dict) --
Metadata on a column that is used as the input of a transform operation.
Name (string) -- [REQUIRED]
The name of this column in the underlying data source.
Type (string) -- [REQUIRED]
The data type of the column.
S3Source (dict) --
A physical table type for as S3 data source.
DataSourceArn (string) -- [REQUIRED]
Data source ARN.
UploadSettings (dict) --
Information on the S3 source file(s) format.
Format (string) --
File format.
StartFromRow (integer) --
A row number to start reading data from.
ContainsHeader (boolean) --
Whether or not the file(s) has a header row.
TextQualifier (string) --
Text qualifier.
Delimiter (string) --
The delimiter between values in the file.
InputColumns (list) -- [REQUIRED]
A physical table type for as S3 data source.
(dict) --
Metadata on a column that is used as the input of a transform operation.
Name (string) -- [REQUIRED]
The name of this column in the underlying data source.
Type (string) -- [REQUIRED]
The data type of the column.
dict
Configures the combination and transformation of the data from the physical tables.
(string) --
(dict) --
A unit that joins and data transformations operate on. A logical table has a source, which can be either a physical table or result of a join. When it points to a physical table, a logical table acts as a mutable copy of that table through transform operations.
Alias (string) -- [REQUIRED]
A display name for the logical table.
DataTransforms (list) --
Transform operations that act on this logical table.
(dict) --
A data transformation on a logical table. This is a variant type structure. No more than one of the attributes should be non-null for this structure to be valid.
ProjectOperation (dict) --
An operation that projects columns. Operations that come after a projection can only refer to projected columns.
ProjectedColumns (list) -- [REQUIRED]
Projected columns.
(string) --
FilterOperation (dict) --
An operation that filters rows based on some condition.
ConditionExpression (string) -- [REQUIRED]
An expression that must evaluate to a boolean value. Rows for which the expression is evaluated to true are kept in the dataset.
CreateColumnsOperation (dict) --
An operation that creates calculated columns. Columns created in one such operation form a lexical closure.
Columns (list) -- [REQUIRED]
Calculated columns to create.
(dict) --
A calculated column for a dataset.
ColumnName (string) -- [REQUIRED]
Column name.
ColumnId (string) -- [REQUIRED]
A unique ID to identify a calculated column. During dataset update, if the column ID of a calculated column matches that of an existing calculated column, QuickSight preserves the existing calculated column.
Expression (string) -- [REQUIRED]
An expression that defines the calculated column.
RenameColumnOperation (dict) --
An operation that renames a column.
ColumnName (string) -- [REQUIRED]
Name of the column to be renamed.
NewColumnName (string) -- [REQUIRED]
New name for the column.
CastColumnTypeOperation (dict) --
A transform operation that casts a column to a different type.
ColumnName (string) -- [REQUIRED]
Column name.
NewColumnType (string) -- [REQUIRED]
New column data type.
Format (string) --
When casting a column from string to datetime type, you can supply a QuickSight supported format string to denote the source data format.
TagColumnOperation (dict) --
An operation that tags a column with additional information.
ColumnName (string) -- [REQUIRED]
The column that this operation acts on.
Tags (list) -- [REQUIRED]
The dataset column tag, currently only used for geospatial type tagging. .
Note
This is not tags for the AWS tagging feature. .
(dict) --
A tag for a column in a TagColumnOperation. This is a variant type structure. No more than one of the attributes should be non-null for this structure to be valid.
ColumnGeographicRole (string) --
A geospatial role for a column.
Source (dict) -- [REQUIRED]
Source of this logical table.
JoinInstruction (dict) --
Specifies the result of a join of two logical tables.
LeftOperand (string) -- [REQUIRED]
Left operand.
RightOperand (string) -- [REQUIRED]
Right operand.
Type (string) -- [REQUIRED]
Type.
OnClause (string) -- [REQUIRED]
On Clause.
PhysicalTableId (string) --
Physical table ID.
string
[REQUIRED]
Indicates whether or not you want to import the data into SPICE.
list
Groupings of columns that work together in certain QuickSight features. Currently only geospatial hierarchy is supported.
(dict) --
Groupings of columns that work together in certain QuickSight features. This is a variant type structure. No more than one of the attributes should be non-null for this structure to be valid.
GeoSpatialColumnGroup (dict) --
Geospatial column group that denotes a hierarchy.
Name (string) -- [REQUIRED]
A display name for the hierarchy.
CountryCode (string) -- [REQUIRED]
Country code.
Columns (list) -- [REQUIRED]
Columns in this hierarchy.
(string) --
list
A list of resource permissions on the dataset.
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
dict
Row-level security configuration on the data you want to create.
Arn (string) -- [REQUIRED]
The Amazon Resource name (ARN) of the permission dataset.
PermissionPolicy (string) -- [REQUIRED]
Permission policy.
list
Contains a map of the key-value pairs for the resource tag or tags assigned to the dataset.
(dict) --
The keys of the key-value pairs for the resource tag or tags assigned to the resource.
Key (string) -- [REQUIRED]
Tag key.
Value (string) -- [REQUIRED]
Tag value.
dict
Response Syntax
{
'Arn': 'string',
'DataSetId': 'string',
'IngestionArn': 'string',
'IngestionId': 'string',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
Arn (string) --
The ARN of the dataset.
DataSetId (string) --
The ID for the dataset you want to create. This is unique per region per AWS account.
IngestionArn (string) --
The Amazon Resource Name (ARN) for the ingestion, which is triggered as a result of dataset creation if the import mode is SPICE
IngestionId (string) --
The ID of the ingestion, which is triggered as a result of dataset creation if the import mode is SPICE
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Describes an existing IAMPolicy Assignment by specified assignment name.
CLI syntax:
aws quicksight describe-iam-policy-assignment --aws-account-id=111122223333 --assignment-name=testtest --namespace=default --region=us-east-1
See also: AWS API Documentation
Request Syntax
client.describe_iam_policy_assignment(
AwsAccountId='string',
AssignmentName='string',
Namespace='string'
)
string
[REQUIRED]
The AWS account ID that contains the assignment you want to describe.
string
[REQUIRED]
The name of the assignment.
string
[REQUIRED]
The namespace that contains the assignment.
dict
Response Syntax
{
'IAMPolicyAssignment': {
'AwsAccountId': 'string',
'AssignmentId': 'string',
'AssignmentName': 'string',
'PolicyArn': 'string',
'Identities': {
'string': [
'string',
]
},
'AssignmentStatus': 'ENABLED'|'DRAFT'|'DISABLED'
},
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
IAMPolicyAssignment (dict) --
Information describing the IAM policy assignment.
AwsAccountId (string) --
AWS account ID.
AssignmentId (string) --
Assignment ID.
AssignmentName (string) --
Assignment name.
PolicyArn (string) --
Policy ARN.
Identities (dict) --
Identities.
(string) --
(list) --
(string) --
AssignmentStatus (string) --
Assignment status.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Updates an existing assignment. This operation updates only the optional parameter or parameters that are specified in the request.
CLI syntax:
aws quicksight update-iam-policy-assignment --aws-account-id=111122223333 --assignment-name=FullAccessAssignment --assignment-status=DRAFT --policy-arns=arn:aws:iam::aws:policy/AdministratorAccess --identities="user=user-1,user-2,group=admin" --namespace=default --region=us-east-1
See also: AWS API Documentation
Request Syntax
client.update_iam_policy_assignment(
AwsAccountId='string',
AssignmentName='string',
Namespace='string',
AssignmentStatus='ENABLED'|'DRAFT'|'DISABLED',
PolicyArn='string',
Identities={
'string': [
'string',
]
}
)
string
[REQUIRED]
The AWS account ID that contains the IAM policy assignment.
string
[REQUIRED]
The name of the assignment. It must be unique within an AWS account.
string
[REQUIRED]
The namespace of the assignment.
string
The status of an assignment:
ENABLED - Anything specified in this assignment is used while creating the data source.
DISABLED - This assignment isn't used while creating the data source.
DRAFT - Assignment is an unfinished draft and isn't used while creating the data source.
string
An IAM policy ARN that will be applied to specified QuickSight users and groups in this assignment.
dict
QuickSight users and/or groups that you want to assign to the specified IAM policy.
(string) --
(list) --
(string) --
dict
Response Syntax
{
'AssignmentName': 'string',
'AssignmentId': 'string',
'PolicyArn': 'string',
'Identities': {
'string': [
'string',
]
},
'AssignmentStatus': 'ENABLED'|'DRAFT'|'DISABLED',
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
AssignmentName (string) --
The name of the assignment.
AssignmentId (string) --
The ID of the assignment.
PolicyArn (string) --
The IAM policy ARN assigned to the QuickSight users and groups specified in this request.
Identities (dict) --
QuickSight users and/or groups that are assigned to this IAM policy.
(string) --
(list) --
(string) --
AssignmentStatus (string) --
The status of the assignment:
ENABLED - Anything specified in this assignment is used while creating the data source.
DISABLED - This assignment isn't used while creating the data source.
DRAFT - Assignment is an unfinished draft and isn't used while creating the data source.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Updates the permissions on a template.
CLI syntax:
aws quicksight describe-template-permissions —aws-account-id 111122223333 —template-id reports_test_template
aws quicksight update-template-permissions —cli-input-json file://update-permission.json
The structure of update-permissions.json to add permissions: { "AwsAccountId": "111122223333", "DashboardId": "reports_test_template", "GrantPermissions": [ { "Principal": "arn:aws:quicksight:us-east-1:196359894473:user/default/user3", "Actions": [ "quicksight:DescribeTemplate", "quicksight:ListTemplateVersions" ] } ] } The structure of update-permissions.json to add permissions: { "AwsAccountId": "111122223333", "DashboardId": "reports_test_template", "RevokePermissions": [ { "Principal": "arn:aws:quicksight:us-east-1:196359894473:user/default/user3", "Actions": [ "quicksight:DescribeTemplate", "quicksight:ListTemplateVersions" ] } ] } To obtain the principal name of a QuickSight group or user, use user describe-group or describe-user. For example: aws quicksight describe-user --aws-account-id 111122223333 --namespace default --user-name user2 --region us-east-1 { "User": { "Arn": "arn:aws:quicksight:us-east-1:111122223333:user/default/user2", "Active": true, "Email": "user2@example.com", "Role": "ADMIN", "UserName": "user2", "PrincipalId": "federated/iam/abcd2abcdabcdeabc5ab5" }, "RequestId": "8f74bb31-6291-448a-a71c-a765a44bae31", "Status": 200 }
See also: AWS API Documentation
Request Syntax
client.update_template_permissions(
AwsAccountId='string',
TemplateId='string',
GrantPermissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
RevokePermissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
]
)
string
[REQUIRED]
AWS account ID that contains the template.
string
[REQUIRED]
The ID for the template.
list
A list of resource permissions to be granted on the template. The following example shows the shorthand syntax:
Shorthand Syntax: Principal=string,Actions=string,string ...
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
list
A list of resource permissions to be revoked from the template. Shorthand syntax: Shorthand Syntax: Principal=string,Actions=string,string ...
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
dict
Response Syntax
{
'TemplateId': 'string',
'TemplateArn': 'string',
'Permissions': [
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
TemplateId (string) --
The ID for the template.
TemplateArn (string) --
The ARN of the template.
Permissions (list) --
A list of resource permissions to be set on the template.
(dict) --
Permission for the resource.
Principal (string) --
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) --
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Creates a dashboard from a template. To first create a template, see the CreateTemplate API.
A dashboard is an entity in QuickSight which identifies Quicksight reports, created from analyses. QuickSight dashboards are sharable. With the right permissions, you can create scheduled email reports from them. The CreateDashboard , DescribeDashboard and ListDashboardsByUser APIs act on the dashboard entity. If you have the correct permissions, you can create a dashboard from a template that exists in a different AWS account.
CLI syntax:
aws quicksight create-dashboard --cli-input-json file://create-dashboard.json
See also: AWS API Documentation
Request Syntax
client.create_dashboard(
AwsAccountId='string',
DashboardId='string',
Name='string',
Parameters={
'StringParameters': [
{
'Name': 'string',
'Values': [
'string',
]
},
],
'IntegerParameters': [
{
'Name': 'string',
'Values': [
123,
]
},
],
'DecimalParameters': [
{
'Name': 'string',
'Values': [
123.0,
]
},
],
'DateTimeParameters': [
{
'Name': 'string',
'Values': [
datetime(2015, 1, 1),
]
},
]
},
Permissions=[
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
SourceEntity={
'SourceTemplate': {
'DataSetReferences': [
{
'DataSetPlaceholder': 'string',
'DataSetArn': 'string'
},
],
'Arn': 'string'
}
},
Tags=[
{
'Key': 'string',
'Value': 'string'
},
],
VersionDescription='string',
DashboardPublishOptions={
'AdHocFilteringOption': {
'AvailabilityStatus': 'ENABLED'|'DISABLED'
},
'ExportToCSVOption': {
'AvailabilityStatus': 'ENABLED'|'DISABLED'
},
'SheetControlsOption': {
'VisibilityState': 'EXPANDED'|'COLLAPSED'
}
}
)
string
[REQUIRED]
AWS account ID where you want to create the dashboard.
string
[REQUIRED]
The ID for the dashboard, also added to IAM policy.
string
[REQUIRED]
The display name of the dashboard.
dict
A structure that contains the parameters of the dashboard. These are parameter overrides for a dashboard. A dashboard can have any type of parameters and some parameters might accept multiple values. You could use the following structure to override two string parameters that accept multiple values:
StringParameters (list) --
String parameters.
(dict) --
String parameter.
Name (string) -- [REQUIRED]
A display name for the dataset.
Values (list) -- [REQUIRED]
Values.
(string) --
IntegerParameters (list) --
Integer parameters.
(dict) --
Integer parameter.
Name (string) -- [REQUIRED]
A display name for the dataset.
Values (list) -- [REQUIRED]
Values.
(integer) --
DecimalParameters (list) --
Decimal parameters.
(dict) --
Decimal parameter.
Name (string) -- [REQUIRED]
A display name for the dataset.
Values (list) -- [REQUIRED]
Values.
(float) --
DateTimeParameters (list) --
DateTime parameters.
(dict) --
Date time parameter.
Name (string) -- [REQUIRED]
A display name for the dataset.
Values (list) -- [REQUIRED]
Values.
(datetime) --
list
A structure that contains the permissions of the dashboard. You can use this for granting permissions with principal and action information.
(dict) --
Permission for the resource.
Principal (string) -- [REQUIRED]
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) -- [REQUIRED]
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
dict
[REQUIRED]
Source entity from which the dashboard is created. The souce entity accepts the ARN of the source template or analysis and also references the replacement datasets for the placeholders set when creating the template. The replacement datasets need to follow the same schema as the datasets for which placeholders were created when creating the template.
If you are creating a dashboard from a source entity in a different AWS account, use the ARN of the source template.
SourceTemplate (dict) --
Source template.
DataSetReferences (list) -- [REQUIRED]
Dataset references.
(dict) --
Dataset reference.
DataSetPlaceholder (string) -- [REQUIRED]
Dataset placeholder.
DataSetArn (string) -- [REQUIRED]
Dataset ARN.
Arn (string) -- [REQUIRED]
The Amazon Resource name (ARN) of the resource.
list
Contains a map of the key-value pairs for the resource tag or tags assigned to the dashboard.
(dict) --
The keys of the key-value pairs for the resource tag or tags assigned to the resource.
Key (string) -- [REQUIRED]
Tag key.
Value (string) -- [REQUIRED]
Tag value.
string
A description for the first version of the dashboard being created.
dict
Publishing options when creating dashboard.
AvailabilityStatus for AdHocFilteringOption - This can be either ENABLED or DISABLED . When This is set to set to DISABLED , QuickSight disables the left filter pane on the published dashboard, which can be used for AdHoc filtering. Enabled by default.
AvailabilityStatus for ExportToCSVOption - This can be either ENABLED or DISABLED . The visual option to export data to CSV is disabled when this is set to DISABLED . Enabled by default.
VisibilityState for SheetControlsOption - This can be either COLLAPSED or EXPANDED . The sheet controls pane is collapsed by default when set to true. Collapsed by default.
Shorthand Syntax:
AdHocFilteringDisabled=boolean,ExportToCSVDisabled=boolean,SheetControlsCollapsed=boolean
AdHocFilteringOption (dict) --
Ad hoc filtering option.
AvailabilityStatus (string) --
Availability status.
ExportToCSVOption (dict) --
Export to CSV option.
AvailabilityStatus (string) --
Availability status.
SheetControlsOption (dict) --
Sheet controls option.
VisibilityState (string) --
Visibility state.
dict
Response Syntax
{
'Arn': 'string',
'VersionArn': 'string',
'DashboardId': 'string',
'CreationStatus': 'CREATION_IN_PROGRESS'|'CREATION_SUCCESSFUL'|'CREATION_FAILED'|'UPDATE_IN_PROGRESS'|'UPDATE_SUCCESSFUL'|'UPDATE_FAILED',
'Status': 123,
'RequestId': 'string'
}
Response Structure
(dict) --
Arn (string) --
The ARN of the dashboard.
VersionArn (string) --
The ARN of the dashboard, including the version number of the first version that is created.
DashboardId (string) --
The ID for the dashboard.
CreationStatus (string) --
The creation status of the dashboard create request.
Status (integer) --
The http status of the request.
RequestId (string) --
The AWS request ID for this operation.
Update template alias of given template.
CLI syntax:
aws quicksight delete-template-alias --aws-account-id 111122223333 --template-id 'reports_test_template' --alias-name 'STAGING'
See also: AWS API Documentation
Request Syntax
client.delete_template_alias(
AwsAccountId='string',
TemplateId='string',
AliasName='string'
)
string
[REQUIRED]
AWS account ID that contains the template alias you are deleting.
string
[REQUIRED]
An ID for the template.
string
[REQUIRED]
The alias of the template. If alias-name is provided, the version that the alias-name points to is deleted. Alias names that start with $ are reserved by QuickSight and can't be deleted.”
dict
Response Syntax
{
'Status': 123,
'TemplateId': 'string',
'AliasName': 'string',
'Arn': 'string',
'RequestId': 'string'
}
Response Structure
(dict) --
Status (integer) --
The http status of the request.
TemplateId (string) --
An ID for the template.
AliasName (string) --
The name of the alias.
Arn (string) --
The ARN of the resource.
RequestId (string) --
The AWS request ID for this operation.
Assigns a tag or tags to a resource.
Assigns one or more tags (key-value pairs) to the specified QuickSight resource. Tags can help you organize and categorize your resources. You can also use them to scope user permissions, by granting a user permission to access or change only resources with certain tag values. You can use the TagResource action with a resource that already has tags. If you specify a new tag key for the resource, this tag is appended to the list of tags associated with the resource. If you specify a tag key that is already associated with the resource, the new tag value that you specify replaces the previous value for that tag.
You can associate as many as 50 tags with a resource. QuickSight supports tagging on data-set, data-source, dashboard, template.
Tagging for QuickSight works in a similar was to tagging for other AWS services, except for the following:
You can't use tags to track AWS costs for QuickSight, because QuickSight costs are based on users and SPICE capacity, which aren't taggable resources.
QuickSight doesn't currently support the Tag Editor for AWS Resource Groups.
CLI syntax to tag a resource:
aws quicksight tag-resource --resource-arn arn:aws:quicksight:us-east-1:111111111111:dataset/dataset1 --tags Key=K1,Value=V1 Key=K2,Value=V2 --region us-east-1
See also: AWS API Documentation
Request Syntax
client.tag_resource(
ResourceArn='string',
Tags=[
{
'Key': 'string',
'Value': 'string'
},
]
)
string
[REQUIRED]
The ARN of the resource you want to tag.
list
[REQUIRED]
Contains a map of the key-value pairs for the resource tag or tags assigned to the resource.
(dict) --
The keys of the key-value pairs for the resource tag or tags assigned to the resource.
Key (string) -- [REQUIRED]
Tag key.
Value (string) -- [REQUIRED]
Tag value.
dict
Response Syntax
{
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Describes the resource permissions for a data source.
The permissions resource is aws:quicksight:region:aws-account-id:datasource/data-source-id
See also: AWS API Documentation
Request Syntax
client.describe_data_source_permissions(
AwsAccountId='string',
DataSourceId='string'
)
string
[REQUIRED]
The AWS account ID.
string
[REQUIRED]
The ID of the data source. This is unique per AWS Region per AWS account.
dict
Response Syntax
{
'DataSourceArn': 'string',
'DataSourceId': 'string',
'Permissions': [
{
'Principal': 'string',
'Actions': [
'string',
]
},
],
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
DataSourceArn (string) --
The ARN of the data source.
DataSourceId (string) --
The ID of the data source. This is unique per AWS Region per AWS account.
Permissions (list) --
A list of resource permissions on the data source.
(dict) --
Permission for the resource.
Principal (string) --
The ARN of a QuickSight user or group, or an IAM ARN. If you are using cross-account resource sharing, this is the IAM ARN of an account root. Otherwise, it is the ARN of a QuickSight user or group. .
Actions (list) --
The action to grant or revoke permissions on. For example, "quicksight:DescribeDashboard".
(string) --
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.
Lists the tags assigned to a resource.
CLI syntax:
aws quicksight list-tags-for-resource --resource-arn arn:aws:quicksight:us-east-1:111111111111:dataset/dataset1 --region us-east-1
See also: AWS API Documentation
Request Syntax
client.list_tags_for_resource(
ResourceArn='string'
)
string
[REQUIRED]
The ARN of the resource you want a list of tags for.
dict
Response Syntax
{
'Tags': [
{
'Key': 'string',
'Value': 'string'
},
],
'RequestId': 'string',
'Status': 123
}
Response Structure
(dict) --
Tags (list) --
Contains a map of the key-value pairs for the resource tag or tags assigned to the resource.
(dict) --
The keys of the key-value pairs for the resource tag or tags assigned to the resource.
Key (string) --
Tag key.
Value (string) --
Tag value.
RequestId (string) --
The AWS request ID for this operation.
Status (integer) --
The http status of the request.