Skip to content

Update Data Set

quicksight_update_data_set R Documentation

Updates a dataset

Description

Updates a dataset. This operation doesn't support datasets that include uploaded files as a source. Partial updates are not supported by this operation.

Usage

quicksight_update_data_set(AwsAccountId, DataSetId, Name,
  PhysicalTableMap, LogicalTableMap, ImportMode, ColumnGroups,
  FieldFolders, RowLevelPermissionDataSet,
  RowLevelPermissionTagConfiguration, ColumnLevelPermissionRules,
  DataSetUsageConfiguration, DatasetParameters)

Arguments

AwsAccountId

[required] The Amazon Web Services account ID.

DataSetId

[required] The ID for the dataset that you want to update. This ID is unique per Amazon Web Services Region for each Amazon Web Services account.

Name

[required] The display name for the dataset.

PhysicalTableMap

[required] Declares the physical tables that are available in the underlying data sources.

LogicalTableMap

Configures the combination and transformation of the data from the physical tables.

ImportMode

[required] Indicates whether you want to import the data into SPICE.

ColumnGroups

Groupings of columns that work together in certain Amazon QuickSight features. Currently, only geospatial hierarchy is supported.

FieldFolders

The folder that contains fields and nested subfolders for your dataset.

RowLevelPermissionDataSet

The row-level security configuration for the data you want to create.

RowLevelPermissionTagConfiguration

The configuration of tags on a dataset to set row-level security. Row-level security tags are currently supported for anonymous embedding only.

ColumnLevelPermissionRules

A set of one or more definitions of a ColumnLevelPermissionRule.

DataSetUsageConfiguration
DatasetParameters

The parameter declarations of the dataset.

Value

A list with the following syntax:

list(
  Arn = "string",
  DataSetId = "string",
  IngestionArn = "string",
  IngestionId = "string",
  RequestId = "string",
  Status = 123
)

Request syntax

svc$update_data_set(
  AwsAccountId = "string",
  DataSetId = "string",
  Name = "string",
  PhysicalTableMap = list(
    list(
      RelationalTable = list(
        DataSourceArn = "string",
        Catalog = "string",
        Schema = "string",
        Name = "string",
        InputColumns = list(
          list(
            Name = "string",
            Type = "STRING"|"INTEGER"|"DECIMAL"|"DATETIME"|"BIT"|"BOOLEAN"|"JSON",
            SubType = "FLOAT"|"FIXED"
          )
        )
      ),
      CustomSql = list(
        DataSourceArn = "string",
        Name = "string",
        SqlQuery = "string",
        Columns = list(
          list(
            Name = "string",
            Type = "STRING"|"INTEGER"|"DECIMAL"|"DATETIME"|"BIT"|"BOOLEAN"|"JSON",
            SubType = "FLOAT"|"FIXED"
          )
        )
      ),
      S3Source = list(
        DataSourceArn = "string",
        UploadSettings = list(
          Format = "CSV"|"TSV"|"CLF"|"ELF"|"XLSX"|"JSON",
          StartFromRow = 123,
          ContainsHeader = TRUE|FALSE,
          TextQualifier = "DOUBLE_QUOTE"|"SINGLE_QUOTE",
          Delimiter = "string"
        ),
        InputColumns = list(
          list(
            Name = "string",
            Type = "STRING"|"INTEGER"|"DECIMAL"|"DATETIME"|"BIT"|"BOOLEAN"|"JSON",
            SubType = "FLOAT"|"FIXED"
          )
        )
      )
    )
  ),
  LogicalTableMap = list(
    list(
      Alias = "string",
      DataTransforms = list(
        list(
          ProjectOperation = list(
            ProjectedColumns = list(
              "string"
            )
          ),
          FilterOperation = list(
            ConditionExpression = "string"
          ),
          CreateColumnsOperation = list(
            Columns = list(
              list(
                ColumnName = "string",
                ColumnId = "string",
                Expression = "string"
              )
            )
          ),
          RenameColumnOperation = list(
            ColumnName = "string",
            NewColumnName = "string"
          ),
          CastColumnTypeOperation = list(
            ColumnName = "string",
            NewColumnType = "STRING"|"INTEGER"|"DECIMAL"|"DATETIME",
            SubType = "FLOAT"|"FIXED",
            Format = "string"
          ),
          TagColumnOperation = list(
            ColumnName = "string",
            Tags = list(
              list(
                ColumnGeographicRole = "COUNTRY"|"STATE"|"COUNTY"|"CITY"|"POSTCODE"|"LONGITUDE"|"LATITUDE",
                ColumnDescription = list(
                  Text = "string"
                )
              )
            )
          ),
          UntagColumnOperation = list(
            ColumnName = "string",
            TagNames = list(
              "COLUMN_GEOGRAPHIC_ROLE"|"COLUMN_DESCRIPTION"
            )
          ),
          OverrideDatasetParameterOperation = list(
            ParameterName = "string",
            NewParameterName = "string",
            NewDefaultValues = list(
              StringStaticValues = list(
                "string"
              ),
              DecimalStaticValues = list(
                123.0
              ),
              DateTimeStaticValues = list(
                as.POSIXct(
                  "2015-01-01"
                )
              ),
              IntegerStaticValues = list(
                123
              )
            )
          )
        )
      ),
      Source = list(
        JoinInstruction = list(
          LeftOperand = "string",
          RightOperand = "string",
          LeftJoinKeyProperties = list(
            UniqueKey = TRUE|FALSE
          ),
          RightJoinKeyProperties = list(
            UniqueKey = TRUE|FALSE
          ),
          Type = "INNER"|"OUTER"|"LEFT"|"RIGHT",
          OnClause = "string"
        ),
        PhysicalTableId = "string",
        DataSetArn = "string"
      )
    )
  ),
  ImportMode = "SPICE"|"DIRECT_QUERY",
  ColumnGroups = list(
    list(
      GeoSpatialColumnGroup = list(
        Name = "string",
        CountryCode = "US",
        Columns = list(
          "string"
        )
      )
    )
  ),
  FieldFolders = list(
    list(
      description = "string",
      columns = list(
        "string"
      )
    )
  ),
  RowLevelPermissionDataSet = list(
    Namespace = "string",
    Arn = "string",
    PermissionPolicy = "GRANT_ACCESS"|"DENY_ACCESS",
    FormatVersion = "VERSION_1"|"VERSION_2",
    Status = "ENABLED"|"DISABLED"
  ),
  RowLevelPermissionTagConfiguration = list(
    Status = "ENABLED"|"DISABLED",
    TagRules = list(
      list(
        TagKey = "string",
        ColumnName = "string",
        TagMultiValueDelimiter = "string",
        MatchAllValue = "string"
      )
    ),
    TagRuleConfigurations = list(
      list(
        "string"
      )
    )
  ),
  ColumnLevelPermissionRules = list(
    list(
      Principals = list(
        "string"
      ),
      ColumnNames = list(
        "string"
      )
    )
  ),
  DataSetUsageConfiguration = list(
    DisableUseAsDirectQuerySource = TRUE|FALSE,
    DisableUseAsImportedSource = TRUE|FALSE
  ),
  DatasetParameters = list(
    list(
      StringDatasetParameter = list(
        Id = "string",
        Name = "string",
        ValueType = "MULTI_VALUED"|"SINGLE_VALUED",
        DefaultValues = list(
          StaticValues = list(
            "string"
          )
        )
      ),
      DecimalDatasetParameter = list(
        Id = "string",
        Name = "string",
        ValueType = "MULTI_VALUED"|"SINGLE_VALUED",
        DefaultValues = list(
          StaticValues = list(
            123.0
          )
        )
      ),
      IntegerDatasetParameter = list(
        Id = "string",
        Name = "string",
        ValueType = "MULTI_VALUED"|"SINGLE_VALUED",
        DefaultValues = list(
          StaticValues = list(
            123
          )
        )
      ),
      DateTimeDatasetParameter = list(
        Id = "string",
        Name = "string",
        ValueType = "MULTI_VALUED"|"SINGLE_VALUED",
        TimeGranularity = "YEAR"|"QUARTER"|"MONTH"|"WEEK"|"DAY"|"HOUR"|"MINUTE"|"SECOND"|"MILLISECOND",
        DefaultValues = list(
          StaticValues = list(
            as.POSIXct(
              "2015-01-01"
            )
          )
        )
      )
    )
  )
)