Create Data Set

quicksight_create_data_set

R Documentation

Creates a dataset

Description

Creates a dataset. This operation doesn't support datasets that include uploaded files as a source.

Usage

quicksight_create_data_set(AwsAccountId, DataSetId, Name,
  PhysicalTableMap, LogicalTableMap, ImportMode, ColumnGroups,
  FieldFolders, Permissions, RowLevelPermissionDataSet,
  RowLevelPermissionTagConfiguration, ColumnLevelPermissionRules, Tags,
  DataSetUsageConfiguration, DatasetParameters, FolderArns)

Arguments

AwsAccountId

[required] The Amazon Web Services account ID.

DataSetId

[required] An ID for the dataset that you want to create. 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.

Permissions

A list of resource permissions on the dataset.

RowLevelPermissionDataSet

The row-level security configuration for the data that 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.

Tags

Contains a map of the key-value pairs for the resource tag or tags assigned to the dataset.

DataSetUsageConfiguration

DatasetParameters

The parameter declarations of the dataset.

FolderArns

When you create the dataset, Amazon QuickSight adds the dataset to these folders.

Value

A list with the following syntax:

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

Request syntax

svc$create_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"
      )
    )
  ),
  Permissions = list(
    list(
      Principal = "string",
      Actions = 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"
      )
    )
  ),
  Tags = list(
    list(
      Key = "string",
      Value = "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"
            )
          )
        )
      )
    )
  ),
  FolderArns = list(
    "string"
  )
)