class CfnDataSet (construct)

Language	Type name
.NET	`Amazon.CDK.AWS.QuickSight.CfnDataSet`
Java	`software.amazon.awscdk.services.quicksight.CfnDataSet`
Python	`aws_cdk.aws_quicksight.CfnDataSet`
TypeScript	`@aws-cdk/aws-quicksight` » `CfnDataSet`

Implements IConstruct, IConstruct, IDependable, IInspectable

A CloudFormation AWS::QuickSight::DataSet.

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

Example

// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import * as quicksight from '@aws-cdk/aws-quicksight';

declare const tagRuleConfigurations: any;
const cfnDataSet = new quicksight.CfnDataSet(this, 'MyCfnDataSet', /* all optional props */ {
  awsAccountId: 'awsAccountId',
  columnGroups: [{
    geoSpatialColumnGroup: {
      columns: ['columns'],
      name: 'name',

      // the properties below are optional
      countryCode: 'countryCode',
    },
  }],
  columnLevelPermissionRules: [{
    columnNames: ['columnNames'],
    principals: ['principals'],
  }],
  dataSetId: 'dataSetId',
  datasetParameters: [{
    dateTimeDatasetParameter: {
      id: 'id',
      name: 'name',
      valueType: 'valueType',

      // the properties below are optional
      defaultValues: {
        staticValues: ['staticValues'],
      },
      timeGranularity: 'timeGranularity',
    },
    decimalDatasetParameter: {
      id: 'id',
      name: 'name',
      valueType: 'valueType',

      // the properties below are optional
      defaultValues: {
        staticValues: [123],
      },
    },
    integerDatasetParameter: {
      id: 'id',
      name: 'name',
      valueType: 'valueType',

      // the properties below are optional
      defaultValues: {
        staticValues: [123],
      },
    },
    stringDatasetParameter: {
      id: 'id',
      name: 'name',
      valueType: 'valueType',

      // the properties below are optional
      defaultValues: {
        staticValues: ['staticValues'],
      },
    },
  }],
  dataSetRefreshProperties: {
    refreshConfiguration: {
      incrementalRefresh: {
        lookbackWindow: {
          columnName: 'columnName',
          size: 123,
          sizeUnit: 'sizeUnit',
        },
      },
    },
  },
  dataSetUsageConfiguration: {
    disableUseAsDirectQuerySource: false,
    disableUseAsImportedSource: false,
  },
  fieldFolders: {
    fieldFoldersKey: {
      columns: ['columns'],
      description: 'description',
    },
  },
  importMode: 'importMode',
  ingestionWaitPolicy: {
    ingestionWaitTimeInHours: 123,
    waitForSpiceIngestion: false,
  },
  logicalTableMap: {
    logicalTableMapKey: {
      alias: 'alias',
      source: {
        dataSetArn: 'dataSetArn',
        joinInstruction: {
          leftOperand: 'leftOperand',
          onClause: 'onClause',
          rightOperand: 'rightOperand',
          type: 'type',

          // the properties below are optional
          leftJoinKeyProperties: {
            uniqueKey: false,
          },
          rightJoinKeyProperties: {
            uniqueKey: false,
          },
        },
        physicalTableId: 'physicalTableId',
      },

      // the properties below are optional
      dataTransforms: [{
        castColumnTypeOperation: {
          columnName: 'columnName',
          newColumnType: 'newColumnType',

          // the properties below are optional
          format: 'format',
        },
        createColumnsOperation: {
          columns: [{
            columnId: 'columnId',
            columnName: 'columnName',
            expression: 'expression',
          }],
        },
        filterOperation: {
          conditionExpression: 'conditionExpression',
        },
        overrideDatasetParameterOperation: {
          parameterName: 'parameterName',

          // the properties below are optional
          newDefaultValues: {
            dateTimeStaticValues: ['dateTimeStaticValues'],
            decimalStaticValues: [123],
            integerStaticValues: [123],
            stringStaticValues: ['stringStaticValues'],
          },
          newParameterName: 'newParameterName',
        },
        projectOperation: {
          projectedColumns: ['projectedColumns'],
        },
        renameColumnOperation: {
          columnName: 'columnName',
          newColumnName: 'newColumnName',
        },
        tagColumnOperation: {
          columnName: 'columnName',
          tags: [{
            columnDescription: {
              text: 'text',
            },
            columnGeographicRole: 'columnGeographicRole',
          }],
        },
      }],
    },
  },
  name: 'name',
  permissions: [{
    actions: ['actions'],
    principal: 'principal',
  }],
  physicalTableMap: {
    physicalTableMapKey: {
      customSql: {
        columns: [{
          name: 'name',
          type: 'type',
        }],
        dataSourceArn: 'dataSourceArn',
        name: 'name',
        sqlQuery: 'sqlQuery',
      },
      relationalTable: {
        dataSourceArn: 'dataSourceArn',
        inputColumns: [{
          name: 'name',
          type: 'type',
        }],
        name: 'name',

        // the properties below are optional
        catalog: 'catalog',
        schema: 'schema',
      },
      s3Source: {
        dataSourceArn: 'dataSourceArn',
        inputColumns: [{
          name: 'name',
          type: 'type',
        }],

        // the properties below are optional
        uploadSettings: {
          containsHeader: false,
          delimiter: 'delimiter',
          format: 'format',
          startFromRow: 123,
          textQualifier: 'textQualifier',
        },
      },
    },
  },
  rowLevelPermissionDataSet: {
    arn: 'arn',
    permissionPolicy: 'permissionPolicy',

    // the properties below are optional
    formatVersion: 'formatVersion',
    namespace: 'namespace',
    status: 'status',
  },
  rowLevelPermissionTagConfiguration: {
    tagRules: [{
      columnName: 'columnName',
      tagKey: 'tagKey',

      // the properties below are optional
      matchAllValue: 'matchAllValue',
      tagMultiValueDelimiter: 'tagMultiValueDelimiter',
    }],

    // the properties below are optional
    status: 'status',
    tagRuleConfigurations: tagRuleConfigurations,
  },
  tags: [{
    key: 'key',
    value: 'value',
  }],
});

Initializer

new CfnDataSet(scope: Construct, id: string, props?: CfnDataSetProps)

Parameters

scope Construct — - scope in which this resource is defined.
id string — - scoped id of the resource.
props CfnDataSetProps — - resource properties.

Create a new AWS::QuickSight::DataSet.

Construct Props

Name	Type	Description
awsAccountId?	`string`	The AWS account ID.
columnGroups?	`IResolvable` `\|` `IResolvable` `\|` `ColumnGroupProperty[]`	Groupings of columns that work together in certain Amazon QuickSight features.
columnLevelPermissionRules?	`IResolvable` `\|` `IResolvable` `\|` `ColumnLevelPermissionRuleProperty[]`	A set of one or more definitions of a `ColumnLevelPermissionRule` .
dataSetId?	`string`	An ID for the dataset that you want to create.
dataSetRefreshProperties?	`IResolvable` `\|` `DataSetRefreshPropertiesProperty`	`AWS::QuickSight::DataSet.DataSetRefreshProperties`.
dataSetUsageConfiguration?	`IResolvable` `\|` `DataSetUsageConfigurationProperty`	The usage configuration to apply to child datasets that reference this dataset as a source.
datasetParameters?	`IResolvable` `\|` `IResolvable` `\|` `DatasetParameterProperty[]`	`AWS::QuickSight::DataSet.DatasetParameters`.
fieldFolders?	`IResolvable` `\| { [string]:` `IResolvable` `\|` `FieldFolderProperty` `}`	The folder that contains fields and nested subfolders for your dataset.
importMode?	`string`	Indicates whether you want to import the data into SPICE.
ingestionWaitPolicy?	`IResolvable` `\|` `IngestionWaitPolicyProperty`	The wait policy to use when creating or updating a Dataset.
logicalTableMap?	`IResolvable` `\| { [string]:` `IResolvable` `\|` `LogicalTableProperty` `}`	Configures the combination and transformation of the data from the physical tables.
name?	`string`	The display name for the dataset.
permissions?	`IResolvable` `\|` `IResolvable` `\|` `ResourcePermissionProperty[]`	A list of resource permissions on the dataset.
physicalTableMap?	`IResolvable` `\| { [string]:` `IResolvable` `\|` `PhysicalTableProperty` `}`	Declares the physical tables that are available in the underlying data sources.
rowLevelPermissionDataSet?	`IResolvable` `\|` `RowLevelPermissionDataSetProperty`	The row-level security configuration for the data that you want to create.
rowLevelPermissionTagConfiguration?	`IResolvable` `\|` `RowLevelPermissionTagConfigurationProperty`	The element you can use to define tags for row-level security.
tags?	`CfnTag[]`	Contains a map of the key-value pairs for the resource tag or tags assigned to the dataset.

awsAccountId?

Type: string (optional)

The AWS account ID.

columnGroups?

Type: IResolvable | IResolvable | ColumnGroupProperty[] (optional)

Groupings of columns that work together in certain Amazon QuickSight features.

Currently, only geospatial hierarchy is supported.

columnLevelPermissionRules?

Type: IResolvable | IResolvable | ColumnLevelPermissionRuleProperty[] (optional)

A set of one or more definitions of a ColumnLevelPermissionRule .

dataSetId?

Type: string (optional)

An ID for the dataset that you want to create.

This ID is unique per AWS Region for each AWS account.

dataSetRefreshProperties?

Type: IResolvable | DataSetRefreshPropertiesProperty (optional)

AWS::QuickSight::DataSet.DataSetRefreshProperties.

dataSetUsageConfiguration?

Type: IResolvable | DataSetUsageConfigurationProperty (optional)

The usage configuration to apply to child datasets that reference this dataset as a source.

datasetParameters?

Type: IResolvable | IResolvable | DatasetParameterProperty[] (optional)

AWS::QuickSight::DataSet.DatasetParameters.

fieldFolders?

Type: IResolvable | { [string]: IResolvable | FieldFolderProperty } (optional)

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

importMode?

Type: string (optional)

Indicates whether you want to import the data into SPICE.

ingestionWaitPolicy?

Type: IResolvable | IngestionWaitPolicyProperty (optional)

The wait policy to use when creating or updating a Dataset.

The default is to wait for SPICE ingestion to finish with timeout of 36 hours.

logicalTableMap?

Type: IResolvable | { [string]: IResolvable | LogicalTableProperty } (optional)

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

name?

Type: string (optional)

The display name for the dataset.

permissions?

Type: IResolvable | IResolvable | ResourcePermissionProperty[] (optional)

A list of resource permissions on the dataset.

physicalTableMap?

Type: IResolvable | { [string]: IResolvable | PhysicalTableProperty } (optional)

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

rowLevelPermissionDataSet?

Type: IResolvable | RowLevelPermissionDataSetProperty (optional)

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

rowLevelPermissionTagConfiguration?

Type: IResolvable | RowLevelPermissionTagConfigurationProperty (optional)

The element you can use to define tags for row-level security.

tags?

Type: CfnTag[] (optional)

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

Properties

Name	Type	Description
attrArn	`string`	The Amazon Resource Name (ARN) of the dataset.
attrConsumedSpiceCapacityInBytes	`IResolvable`
attrCreatedTime	`string`	The time this dataset version was created.
attrLastUpdatedTime	`string`	The time this dataset version was last updated.
attrOutputColumns	`IResolvable`
cfnOptions	`ICfnResourceOptions`	Options for this resource, such as condition, update policy etc.
cfnProperties	`{ [string]: any }`
cfnResourceType	`string`	AWS resource type.
creationStack	`string[]`
logicalId	`string`	The logical ID for this CloudFormation stack element.
node	`ConstructNode`	The construct tree node associated with this construct.
ref	`string`	Return a string that will be resolved to a CloudFormation `{ Ref }` for this element.
stack	`Stack`	The stack in which this element is defined.
tags	`TagManager`	Contains a map of the key-value pairs for the resource tag or tags assigned to the dataset.
awsAccountId?	`string`	The AWS account ID.
columnGroups?	`IResolvable` `\|` `IResolvable` `\|` `ColumnGroupProperty[]`	Groupings of columns that work together in certain Amazon QuickSight features.
columnLevelPermissionRules?	`IResolvable` `\|` `IResolvable` `\|` `ColumnLevelPermissionRuleProperty[]`	A set of one or more definitions of a `ColumnLevelPermissionRule` .
dataSetId?	`string`	An ID for the dataset that you want to create.
dataSetRefreshProperties?	`IResolvable` `\|` `DataSetRefreshPropertiesProperty`	`AWS::QuickSight::DataSet.DataSetRefreshProperties`.
dataSetUsageConfiguration?	`IResolvable` `\|` `DataSetUsageConfigurationProperty`	The usage configuration to apply to child datasets that reference this dataset as a source.
datasetParameters?	`IResolvable` `\|` `IResolvable` `\|` `DatasetParameterProperty[]`	`AWS::QuickSight::DataSet.DatasetParameters`.
fieldFolders?	`IResolvable` `\| { [string]:` `IResolvable` `\|` `FieldFolderProperty` `}`	The folder that contains fields and nested subfolders for your dataset.
importMode?	`string`	Indicates whether you want to import the data into SPICE.
ingestionWaitPolicy?	`IResolvable` `\|` `IngestionWaitPolicyProperty`	The wait policy to use when creating or updating a Dataset.
logicalTableMap?	`IResolvable` `\| { [string]:` `IResolvable` `\|` `LogicalTableProperty` `}`	Configures the combination and transformation of the data from the physical tables.
name?	`string`	The display name for the dataset.
permissions?	`IResolvable` `\|` `IResolvable` `\|` `ResourcePermissionProperty[]`	A list of resource permissions on the dataset.
physicalTableMap?	`IResolvable` `\| { [string]:` `IResolvable` `\|` `PhysicalTableProperty` `}`	Declares the physical tables that are available in the underlying data sources.
rowLevelPermissionDataSet?	`IResolvable` `\|` `RowLevelPermissionDataSetProperty`	The row-level security configuration for the data that you want to create.
rowLevelPermissionTagConfiguration?	`IResolvable` `\|` `RowLevelPermissionTagConfigurationProperty`	The element you can use to define tags for row-level security.
static CFN_RESOURCE_TYPE_NAME	`string`	The CloudFormation resource type name for this resource class.

attrArn

Type: string

The Amazon Resource Name (ARN) of the dataset.

attrConsumedSpiceCapacityInBytes

Type: IResolvable

attrCreatedTime

Type: string

The time this dataset version was created.

attrLastUpdatedTime

Type: string

The time this dataset version was last updated.

attrOutputColumns

Type: IResolvable

cfnOptions

Type: ICfnResourceOptions

Options for this resource, such as condition, update policy etc.

cfnProperties

Type: { [string]: any }

cfnResourceType

Type: string

AWS resource type.

creationStack

Type: string[]

logicalId

Type: string

The logical ID for this CloudFormation stack element.

The logical ID of the element is calculated from the path of the resource node in the construct tree.

To override this value, use overrideLogicalId(newLogicalId).

node

Type: ConstructNode

The construct tree node associated with this construct.

ref

Type: string

Return a string that will be resolved to a CloudFormation { Ref } for this element.

If, by any chance, the intrinsic reference of a resource is not a string, you could coerce it to an IResolvable through Lazy.any({ produce: resource.ref }).

stack

Type: Stack

The stack in which this element is defined.

CfnElements must be defined within a stack scope (directly or indirectly).

awsAccountId?

Type: string (optional)

The AWS account ID.

columnGroups?

Type: IResolvable | IResolvable | ColumnGroupProperty[] (optional)

Groupings of columns that work together in certain Amazon QuickSight features.

Currently, only geospatial hierarchy is supported.

columnLevelPermissionRules?

Type: IResolvable | IResolvable | ColumnLevelPermissionRuleProperty[] (optional)

A set of one or more definitions of a ColumnLevelPermissionRule .

dataSetId?

Type: string (optional)

An ID for the dataset that you want to create.

This ID is unique per AWS Region for each AWS account.

dataSetRefreshProperties?

Type: IResolvable | DataSetRefreshPropertiesProperty (optional)

AWS::QuickSight::DataSet.DataSetRefreshProperties.

dataSetUsageConfiguration?

Type: IResolvable | DataSetUsageConfigurationProperty (optional)

The usage configuration to apply to child datasets that reference this dataset as a source.

datasetParameters?

Type: IResolvable | IResolvable | DatasetParameterProperty[] (optional)

AWS::QuickSight::DataSet.DatasetParameters.

fieldFolders?

Type: IResolvable | { [string]: IResolvable | FieldFolderProperty } (optional)

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

importMode?

Type: string (optional)

Indicates whether you want to import the data into SPICE.

ingestionWaitPolicy?

Type: IResolvable | IngestionWaitPolicyProperty (optional)

The wait policy to use when creating or updating a Dataset.

The default is to wait for SPICE ingestion to finish with timeout of 36 hours.

logicalTableMap?

Type: IResolvable | { [string]: IResolvable | LogicalTableProperty } (optional)

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

name?

Type: string (optional)

The display name for the dataset.

permissions?

Type: IResolvable | IResolvable | ResourcePermissionProperty[] (optional)

A list of resource permissions on the dataset.

physicalTableMap?

Type: IResolvable | { [string]: IResolvable | PhysicalTableProperty } (optional)

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

rowLevelPermissionDataSet?

Type: IResolvable | RowLevelPermissionDataSetProperty (optional)

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

rowLevelPermissionTagConfiguration?

Type: IResolvable | RowLevelPermissionTagConfigurationProperty (optional)

The element you can use to define tags for row-level security.

static CFN_RESOURCE_TYPE_NAME

Type: string

The CloudFormation resource type name for this resource class.

Methods

Name	Description
addDeletionOverride(path)	Syntactic sugar for `addOverride(path, undefined)`.
addDependsOn(target)	Indicates that this resource depends on another resource and cannot be provisioned unless the other resource has been successfully provisioned.
addMetadata(key, value)	Add a value to the CloudFormation Resource Metadata.
addOverride(path, value)	Adds an override to the synthesized CloudFormation resource.
addPropertyDeletionOverride(propertyPath)	Adds an override that deletes the value of a property from the resource definition.
addPropertyOverride(propertyPath, value)	Adds an override to a resource property.
applyRemovalPolicy(policy?, options?)	Sets the deletion policy of the resource based on the removal policy specified.
getAtt(attributeName)	Returns a token for an runtime attribute of this resource.
getMetadata(key)	Retrieve a value value from the CloudFormation Resource Metadata.
inspect(inspector)	Examines the CloudFormation resource and discloses attributes.
overrideLogicalId(newLogicalId)	Overrides the auto-generated logical ID with a specific ID.
toString()	Returns a string representation of this construct.
protected renderProperties(props)

addDeletionOverride(path)

public addDeletionOverride(path: string): void

Parameters

path string — The path of the value to delete.

Syntactic sugar for addOverride(path, undefined).

addDependsOn(target)

public addDependsOn(target: CfnResource): void

Parameters

target CfnResource

Indicates that this resource depends on another resource and cannot be provisioned unless the other resource has been successfully provisioned.

This can be used for resources across stacks (or nested stack) boundaries and the dependency will automatically be transferred to the relevant scope.

addMetadata(key, value)

public addMetadata(key: string, value: any): void

Parameters

key string
value any

Add a value to the CloudFormation Resource Metadata.

Note that this is a different set of metadata from CDK node metadata; this metadata ends up in the stack template under the resource, whereas CDK node metadata ends up in the Cloud Assembly.](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/metadata-section-structure.html

Note that this is a different set of metadata from CDK node metadata; this metadata ends up in the stack template under the resource, whereas CDK node metadata ends up in the Cloud Assembly.)

addOverride(path, value)

public addOverride(path: string, value: any): void

Parameters

path string — - The path of the property, you can use dot notation to override values in complex types.
value any — - The value.

Adds an override to the synthesized CloudFormation resource.

To add a property override, either use addPropertyOverride or prefix path with "Properties." (i.e. Properties.TopicName).

If the override is nested, separate each nested level using a dot (.) in the path parameter. If there is an array as part of the nesting, specify the index in the path.

To include a literal . in the property name, prefix with a \. In most programming languages you will need to write this as "\\." because the \ itself will need to be escaped.

For example,

cfnResource.addOverride('Properties.GlobalSecondaryIndexes.0.Projection.NonKeyAttributes', ['myattribute']);
cfnResource.addOverride('Properties.GlobalSecondaryIndexes.1.ProjectionType', 'INCLUDE');

would add the overrides

"Properties": {
   "GlobalSecondaryIndexes": [
     {
       "Projection": {
         "NonKeyAttributes": [ "myattribute" ]
         ...
       }
       ...
     },
     {
       "ProjectionType": "INCLUDE"
       ...
     },
   ]
   ...
}

The value argument to addOverride will not be processed or translated in any way. Pass raw JSON values in here with the correct capitalization for CloudFormation. If you pass CDK classes or structs, they will be rendered with lowercased key names, and CloudFormation will reject the template.

addPropertyDeletionOverride(propertyPath)

public addPropertyDeletionOverride(propertyPath: string): void

Parameters

propertyPath string — The path to the property.

Adds an override that deletes the value of a property from the resource definition.

addPropertyOverride(propertyPath, value)

public addPropertyOverride(propertyPath: string, value: any): void

Parameters

propertyPath string — The path of the property.
value any — The value.

Adds an override to a resource property.

Syntactic sugar for addOverride("Properties.<...>", value).

applyRemovalPolicy(policy?, options?)

public applyRemovalPolicy(policy?: RemovalPolicy, options?: RemovalPolicyOptions): void

Parameters

policy RemovalPolicy
options RemovalPolicyOptions

Sets the deletion policy of the resource based on the removal policy specified.

The Removal Policy controls what happens to this resource when it stops being managed by CloudFormation, either because you've removed it from the CDK application or because you've made a change that requires the resource to be replaced.

The resource can be deleted (RemovalPolicy.DESTROY), or left in your AWS account for data recovery and cleanup later (RemovalPolicy.RETAIN).

getAtt(attributeName)

public getAtt(attributeName: string): Reference

Parameters

attributeName string — The name of the attribute.

Returns

Reference

Returns a token for an runtime attribute of this resource.

Ideally, use generated attribute accessors (e.g. resource.arn), but this can be used for future compatibility in case there is no generated attribute.

getMetadata(key)

public getMetadata(key: string): any

Parameters

key string

Returns

any

Retrieve a value value from the CloudFormation Resource Metadata.

Note that this is a different set of metadata from CDK node metadata; this metadata ends up in the stack template under the resource, whereas CDK node metadata ends up in the Cloud Assembly.)

inspect(inspector)

public inspect(inspector: TreeInspector): void

Parameters

inspector TreeInspector — - tree inspector to collect and process attributes.

Examines the CloudFormation resource and discloses attributes.

overrideLogicalId(newLogicalId)

public overrideLogicalId(newLogicalId: string): void

Parameters

newLogicalId string — The new logical ID to use for this stack element.

Overrides the auto-generated logical ID with a specific ID.

toString()

public toString(): string

Returns

string

Returns a string representation of this construct.

protected renderProperties(props)

protected renderProperties(props: { [string]: any }): { [string]: any }

Parameters

props { [string]: any }

Returns

{ [string]: any }