Class: Aws::QuickSight::Types::UpdateDataSetRequest

Inherits:
Struct
  • Object
show all
Defined in:
gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb

Overview

Note:

When making an API call, you may pass UpdateDataSetRequest data as a hash:

{
  aws_account_id: "AwsAccountId", # required
  data_set_id: "ResourceId", # required
  name: "ResourceName", # required
  physical_table_map: { # required
    "PhysicalTableId" => {
      relational_table: {
        data_source_arn: "Arn", # required
        schema: "RelationalTableSchema",
        name: "RelationalTableName", # required
        input_columns: [ # required
          {
            name: "ColumnName", # required
            type: "STRING", # required, accepts STRING, INTEGER, DECIMAL, DATETIME, BIT, BOOLEAN, JSON
          },
        ],
      },
      custom_sql: {
        data_source_arn: "Arn", # required
        name: "CustomSqlName", # required
        sql_query: "SqlQuery", # required
        columns: [
          {
            name: "ColumnName", # required
            type: "STRING", # required, accepts STRING, INTEGER, DECIMAL, DATETIME, BIT, BOOLEAN, JSON
          },
        ],
      },
      s3_source: {
        data_source_arn: "Arn", # required
        upload_settings: {
          format: "CSV", # accepts CSV, TSV, CLF, ELF, XLSX, JSON
          start_from_row: 1,
          contains_header: false,
          text_qualifier: "DOUBLE_QUOTE", # accepts DOUBLE_QUOTE, SINGLE_QUOTE
          delimiter: "Delimiter",
        },
        input_columns: [ # required
          {
            name: "ColumnName", # required
            type: "STRING", # required, accepts STRING, INTEGER, DECIMAL, DATETIME, BIT, BOOLEAN, JSON
          },
        ],
      },
    },
  },
  logical_table_map: {
    "LogicalTableId" => {
      alias: "LogicalTableAlias", # required
      data_transforms: [
        {
          project_operation: {
            projected_columns: ["String"], # required
          },
          filter_operation: {
            condition_expression: "Expression", # required
          },
          create_columns_operation: {
            columns: [ # required
              {
                column_name: "ColumnName", # required
                column_id: "ColumnId", # required
                expression: "Expression", # required
              },
            ],
          },
          rename_column_operation: {
            column_name: "ColumnName", # required
            new_column_name: "ColumnName", # required
          },
          cast_column_type_operation: {
            column_name: "ColumnName", # required
            new_column_type: "STRING", # required, accepts STRING, INTEGER, DECIMAL, DATETIME
            format: "TypeCastFormat",
          },
          tag_column_operation: {
            column_name: "ColumnName", # required
            tags: [ # required
              {
                column_geographic_role: "COUNTRY", # accepts COUNTRY, STATE, COUNTY, CITY, POSTCODE, LONGITUDE, LATITUDE
              },
            ],
          },
        },
      ],
      source: { # required
        join_instruction: {
          left_operand: "LogicalTableId", # required
          right_operand: "LogicalTableId", # required
          type: "INNER", # required, accepts INNER, OUTER, LEFT, RIGHT
          on_clause: "OnClause", # required
        },
        physical_table_id: "PhysicalTableId",
      },
    },
  },
  import_mode: "SPICE", # required, accepts SPICE, DIRECT_QUERY
  column_groups: [
    {
      geo_spatial_column_group: {
        name: "ColumnGroupName", # required
        country_code: "US", # required, accepts US
        columns: ["ColumnName"], # required
      },
    },
  ],
  row_level_permission_data_set: {
    arn: "Arn", # required
    permission_policy: "GRANT_ACCESS", # required, accepts GRANT_ACCESS, DENY_ACCESS
  },
}

Constant Summary collapse

SENSITIVE =
[]

Instance Attribute Summary collapse

Instance Attribute Details

#aws_account_idString

The AWS account ID.

Returns:

  • (String)


8209
8210
8211
8212
8213
8214
8215
8216
8217
8218
8219
8220
# File 'gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb', line 8209

class UpdateDataSetRequest < Struct.new(
  :aws_account_id,
  :data_set_id,
  :name,
  :physical_table_map,
  :logical_table_map,
  :import_mode,
  :column_groups,
  :row_level_permission_data_set)
  SENSITIVE = []
  include Aws::Structure
end

#column_groupsArray<Types::ColumnGroup>

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

Returns:



8209
8210
8211
8212
8213
8214
8215
8216
8217
8218
8219
8220
# File 'gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb', line 8209

class UpdateDataSetRequest < Struct.new(
  :aws_account_id,
  :data_set_id,
  :name,
  :physical_table_map,
  :logical_table_map,
  :import_mode,
  :column_groups,
  :row_level_permission_data_set)
  SENSITIVE = []
  include Aws::Structure
end

#data_set_idString

The ID for the dataset that you want to update. This ID is unique per AWS Region for each AWS account.

Returns:

  • (String)


8209
8210
8211
8212
8213
8214
8215
8216
8217
8218
8219
8220
# File 'gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb', line 8209

class UpdateDataSetRequest < Struct.new(
  :aws_account_id,
  :data_set_id,
  :name,
  :physical_table_map,
  :logical_table_map,
  :import_mode,
  :column_groups,
  :row_level_permission_data_set)
  SENSITIVE = []
  include Aws::Structure
end

#import_modeString

Indicates whether you want to import the data into SPICE.

Returns:

  • (String)


8209
8210
8211
8212
8213
8214
8215
8216
8217
8218
8219
8220
# File 'gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb', line 8209

class UpdateDataSetRequest < Struct.new(
  :aws_account_id,
  :data_set_id,
  :name,
  :physical_table_map,
  :logical_table_map,
  :import_mode,
  :column_groups,
  :row_level_permission_data_set)
  SENSITIVE = []
  include Aws::Structure
end

#logical_table_mapHash<String,Types::LogicalTable>

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

Returns:



8209
8210
8211
8212
8213
8214
8215
8216
8217
8218
8219
8220
# File 'gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb', line 8209

class UpdateDataSetRequest < Struct.new(
  :aws_account_id,
  :data_set_id,
  :name,
  :physical_table_map,
  :logical_table_map,
  :import_mode,
  :column_groups,
  :row_level_permission_data_set)
  SENSITIVE = []
  include Aws::Structure
end

#nameString

The display name for the dataset.

Returns:

  • (String)


8209
8210
8211
8212
8213
8214
8215
8216
8217
8218
8219
8220
# File 'gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb', line 8209

class UpdateDataSetRequest < Struct.new(
  :aws_account_id,
  :data_set_id,
  :name,
  :physical_table_map,
  :logical_table_map,
  :import_mode,
  :column_groups,
  :row_level_permission_data_set)
  SENSITIVE = []
  include Aws::Structure
end

#physical_table_mapHash<String,Types::PhysicalTable>

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

Returns:



8209
8210
8211
8212
8213
8214
8215
8216
8217
8218
8219
8220
# File 'gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb', line 8209

class UpdateDataSetRequest < Struct.new(
  :aws_account_id,
  :data_set_id,
  :name,
  :physical_table_map,
  :logical_table_map,
  :import_mode,
  :column_groups,
  :row_level_permission_data_set)
  SENSITIVE = []
  include Aws::Structure
end

#row_level_permission_data_setTypes::RowLevelPermissionDataSet

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



8209
8210
8211
8212
8213
8214
8215
8216
8217
8218
8219
8220
# File 'gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb', line 8209

class UpdateDataSetRequest < Struct.new(
  :aws_account_id,
  :data_set_id,
  :name,
  :physical_table_map,
  :logical_table_map,
  :import_mode,
  :column_groups,
  :row_level_permission_data_set)
  SENSITIVE = []
  include Aws::Structure
end