Class: Aws::QuickSight::Types::PhysicalTable

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 PhysicalTable data as a hash:

{
  relational_table: {
    data_source_arn: "Arn", # required
    catalog: "RelationalTableCatalog",
    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
      },
    ],
  },
}

A view of a data source that contains information about the shape of the data in the underlying source. This is a variant type structure. For this structure to be valid, only one of the attributes can be non-null.

See Also:

Constant Summary collapse

SENSITIVE = 
[]

Instance Attribute Summary collapse

Instance Attribute Details

#custom_sql ⇒ Types::CustomSql

A physical table type built from the results of the custom SQL query.

Returns:



10426
10427
10428
10429
10430
10431
10432
 
# File 'gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb', line 10426

class PhysicalTable < Struct.new(
  :relational_table,
  :custom_sql,
  :s3_source)
  SENSITIVE = []
  include Aws::Structure
end

#relational_table ⇒ Types::RelationalTable

A physical table type for relational data sources.

Returns:



10426
10427
10428
10429
10430
10431
10432
 
# File 'gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb', line 10426

class PhysicalTable < Struct.new(
  :relational_table,
  :custom_sql,
  :s3_source)
  SENSITIVE = []
  include Aws::Structure
end

#s3_source ⇒ Types::S3Source

A physical table type for as S3 data source.

Returns:



10426
10427
10428
10429
10430
10431
10432
 
# File 'gems/aws-sdk-quicksight/lib/aws-sdk-quicksight/types.rb', line 10426

class PhysicalTable < Struct.new(
  :relational_table,
  :custom_sql,
  :s3_source)
  SENSITIVE = []
  include Aws::Structure
end