NAME
Paws::Quicksight::UpdateDataSet - Arguments for method UpdateDataSet on Paws::Quicksight
DESCRIPTION
This class represents the parameters used for calling the method UpdateDataSet on the Amazon QuickSight service. Use the attributes of this class as arguments to method UpdateDataSet.
You shouldn't make instances of this class. Each attribute should be used as a named argument in the call to UpdateDataSet.
SYNOPSIS
my $quicksight = Paws->service('Quicksight');
my $UpdateDataSetResponse = $quicksight->UpdateDataSet(
AwsAccountId => 'MyAwsAccountId',
DataSetId => 'MyResourceId',
ImportMode => 'SPICE',
Name => 'MyResourceName',
PhysicalTableMap => {
'MyPhysicalTableId' => {
CustomSql => {
DataSourceArn => 'MyArn',
Name => 'MyCustomSqlName', # min: 1, max: 64
SqlQuery => 'MySqlQuery', # min: 1, max: 65536
Columns => [
{
Name => 'MyColumnName', # min: 1, max: 128
Type => 'STRING'
, # values: STRING, INTEGER, DECIMAL, DATETIME, BIT, BOOLEAN, JSON
},
...
], # min: 1, max: 2048; OPTIONAL
}, # OPTIONAL
RelationalTable => {
DataSourceArn => 'MyArn',
InputColumns => [
{
Name => 'MyColumnName', # min: 1, max: 128
Type => 'STRING'
, # values: STRING, INTEGER, DECIMAL, DATETIME, BIT, BOOLEAN, JSON
},
...
], # min: 1, max: 2048; OPTIONAL
Name => 'MyRelationalTableName', # min: 1, max: 64
Catalog => 'MyRelationalTableCatalog', # max: 256; OPTIONAL
Schema => 'MyRelationalTableSchema', # max: 64; OPTIONAL
}, # OPTIONAL
S3Source => {
DataSourceArn => 'MyArn',
InputColumns => [
{
Name => 'MyColumnName', # min: 1, max: 128
Type => 'STRING'
, # values: STRING, INTEGER, DECIMAL, DATETIME, BIT, BOOLEAN, JSON
},
...
], # min: 1, max: 2048; OPTIONAL
UploadSettings => {
ContainsHeader => 1, # OPTIONAL
Delimiter => 'MyDelimiter', # min: 1, max: 1; OPTIONAL
Format =>
'CSV', # values: CSV, TSV, CLF, ELF, XLSX, JSON; OPTIONAL
StartFromRow => 1, # min: 1; OPTIONAL
TextQualifier =>
'DOUBLE_QUOTE', # values: DOUBLE_QUOTE, SINGLE_QUOTE; OPTIONAL
}, # OPTIONAL
}, # OPTIONAL
}, # key: min: 1, max: 64
},
ColumnGroups => [
{
GeoSpatialColumnGroup => {
Columns => [
'MyColumnName', ... # min: 1, max: 128
], # min: 1, max: 16
CountryCode => 'US', # values: US
Name => 'MyColumnGroupName', # min: 1, max: 64
}, # OPTIONAL
},
...
], # OPTIONAL
ColumnLevelPermissionRules => [
{
ColumnNames => [ 'MyString', ... ], # min: 1; OPTIONAL
Principals => [ 'MyString', ... ], # min: 1, max: 100; OPTIONAL
},
...
], # OPTIONAL
FieldFolders => {
'MyFieldFolderPath' => {
Columns => [ 'MyString', ... ], # max: 5000; OPTIONAL
Description => 'MyFieldFolderDescription', # max: 500; OPTIONAL
}, # key: min: 1, max: 1000
}, # OPTIONAL
LogicalTableMap => {
'MyLogicalTableId' => {
Alias => 'MyLogicalTableAlias', # min: 1, max: 64
Source => {
JoinInstruction => {
LeftOperand => 'MyLogicalTableId', # min: 1, max: 64
OnClause => 'MyOnClause', # min: 1, max: 512
RightOperand => 'MyLogicalTableId', # min: 1, max: 64
Type => 'INNER', # values: INNER, OUTER, LEFT, RIGHT
LeftJoinKeyProperties => {
UniqueKey => 1, # OPTIONAL
}, # OPTIONAL
RightJoinKeyProperties => {
UniqueKey => 1, # OPTIONAL
}, # OPTIONAL
}, # OPTIONAL
PhysicalTableId => 'MyPhysicalTableId', # min: 1, max: 64
},
DataTransforms => [
{
CastColumnTypeOperation => {
ColumnName => 'MyColumnName', # min: 1, max: 128
NewColumnType =>
'STRING', # values: STRING, INTEGER, DECIMAL, DATETIME
Format => 'MyTypeCastFormat', # max: 32; OPTIONAL
}, # OPTIONAL
CreateColumnsOperation => {
Columns => [
{
ColumnId => 'MyColumnId', # min: 1, max: 64
ColumnName => 'MyColumnName', # min: 1, max: 128
Expression => 'MyExpression', # min: 1, max: 4096
},
...
], # min: 1, max: 128
}, # OPTIONAL
FilterOperation => {
ConditionExpression => 'MyExpression', # min: 1, max: 4096
}, # OPTIONAL
ProjectOperation => {
ProjectedColumns => [ 'MyString', ... ], # min: 1, max: 2000
}, # OPTIONAL
RenameColumnOperation => {
ColumnName => 'MyColumnName', # min: 1, max: 128
NewColumnName => 'MyColumnName', # min: 1, max: 128
}, # OPTIONAL
TagColumnOperation => {
ColumnName => 'MyColumnName', # min: 1, max: 128
Tags => [
{
ColumnDescription => {
Text => 'MyColumnDescriptiveText', # max: 500; OPTIONAL
}, # OPTIONAL
ColumnGeographicRole => 'COUNTRY'
, # values: COUNTRY, STATE, COUNTY, CITY, POSTCODE, LONGITUDE, LATITUDE; OPTIONAL
},
...
], # min: 1, max: 16
}, # OPTIONAL
},
...
], # min: 1, max: 2048; OPTIONAL
}, # key: min: 1, max: 64
}, # OPTIONAL
RowLevelPermissionDataSet => {
Arn => 'MyArn',
PermissionPolicy => 'GRANT_ACCESS', # values: GRANT_ACCESS, DENY_ACCESS
FormatVersion => 'VERSION_1', # values: VERSION_1, VERSION_2; OPTIONAL
Namespace => 'MyNamespace', # max: 64; OPTIONAL
}, # OPTIONAL
);
# Results:
my $Arn = $UpdateDataSetResponse->Arn;
my $DataSetId = $UpdateDataSetResponse->DataSetId;
my $IngestionArn = $UpdateDataSetResponse->IngestionArn;
my $IngestionId = $UpdateDataSetResponse->IngestionId;
my $RequestId = $UpdateDataSetResponse->RequestId;
my $Status = $UpdateDataSetResponse->Status;
# Returns a L<Paws::Quicksight::UpdateDataSetResponse> object.Values for attributes that are native types (Int, String, Float, etc) can passed as-is (scalar values). Values for complex Types (objects) can be passed as a HashRef. The keys and values of the hashref will be used to instance the underlying object. For the AWS API documentation, see https://docs.aws.amazon.com/goto/WebAPI/quicksight/UpdateDataSet
ATTRIBUTES
REQUIRED AwsAccountId => Str
The AWS account ID.
ColumnGroups => ArrayRef[Paws::Quicksight::ColumnGroup]
Groupings of columns that work together in certain QuickSight features. Currently, only geospatial hierarchy is supported.
ColumnLevelPermissionRules => ArrayRef[Paws::Quicksight::ColumnLevelPermissionRule]
A set of one or more definitions of a ColumnLevelPermissionRule .
REQUIRED DataSetId => Str
The ID for the dataset that you want to update. This ID is unique per AWS Region for each AWS account.
FieldFolders => Paws::Quicksight::FieldFolderMap
The folder that contains fields and nested subfolders for your dataset.
REQUIRED ImportMode => Str
Indicates whether you want to import the data into SPICE.
Valid values are: "SPICE", "DIRECT_QUERY"
LogicalTableMap => Paws::Quicksight::LogicalTableMap
Configures the combination and transformation of the data from the physical tables.
REQUIRED Name => Str
The display name for the dataset.
REQUIRED PhysicalTableMap => Paws::Quicksight::PhysicalTableMap
Declares the physical tables that are available in the underlying data sources.
RowLevelPermissionDataSet => Paws::Quicksight::RowLevelPermissionDataSet
The row-level security configuration for the data you want to create.
SEE ALSO
This class forms part of Paws, documenting arguments for method UpdateDataSet in Paws::Quicksight
BUGS and CONTRIBUTIONS
The source code is located here: https://github.com/pplu/aws-sdk-perl
Please report bugs to: https://github.com/pplu/aws-sdk-perl/issues