CfnDataSetProps

class aws_cdk.aws_quicksight.CfnDataSetProps(*, aws_account_id=None, column_groups=None, column_level_permission_rules=None, data_set_id=None, dataset_parameters=None, data_set_refresh_properties=None, data_set_usage_configuration=None, field_folders=None, import_mode=None, ingestion_wait_policy=None, logical_table_map=None, name=None, permissions=None, physical_table_map=None, row_level_permission_data_set=None, row_level_permission_tag_configuration=None, tags=None)

Bases: object

Properties for defining a CfnDataSet.

Parameters:

aws_account_id (Optional[str]) – The AWS account ID.
column_groups (Union[IResolvable, Sequence[Union[IResolvable, ColumnGroupProperty, Dict[str, Any]]], None]) – Groupings of columns that work together in certain Amazon QuickSight features. Currently, only geospatial hierarchy is supported.
column_level_permission_rules (Union[IResolvable, Sequence[Union[IResolvable, ColumnLevelPermissionRuleProperty, Dict[str, Any]]], None]) – A set of one or more definitions of a ColumnLevelPermissionRule .
data_set_id (Optional[str]) – An ID for the dataset that you want to create. This ID is unique per AWS Region for each AWS account.
dataset_parameters (Union[IResolvable, Sequence[Union[IResolvable, DatasetParameterProperty, Dict[str, Any]]], None]) – AWS::QuickSight::DataSet.DatasetParameters.
data_set_refresh_properties (Union[IResolvable, DataSetRefreshPropertiesProperty, Dict[str, Any], None]) – AWS::QuickSight::DataSet.DataSetRefreshProperties.
data_set_usage_configuration (Union[IResolvable, DataSetUsageConfigurationProperty, Dict[str, Any], None]) – The usage configuration to apply to child datasets that reference this dataset as a source.
field_folders (Union[IResolvable, Mapping[str, Union[IResolvable, FieldFolderProperty, Dict[str, Any]]], None]) – The folder that contains fields and nested subfolders for your dataset.
import_mode (Optional[str]) – Indicates whether you want to import the data into SPICE.
ingestion_wait_policy (Union[IResolvable, IngestionWaitPolicyProperty, Dict[str, Any], None]) – 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.
logical_table_map (Union[IResolvable, Mapping[str, Union[IResolvable, LogicalTableProperty, Dict[str, Any]]], None]) – Configures the combination and transformation of the data from the physical tables.
name (Optional[str]) – The display name for the dataset.
permissions (Union[IResolvable, Sequence[Union[IResolvable, ResourcePermissionProperty, Dict[str, Any]]], None]) – A list of resource permissions on the dataset.
physical_table_map (Union[IResolvable, Mapping[str, Union[IResolvable, PhysicalTableProperty, Dict[str, Any]]], None]) – Declares the physical tables that are available in the underlying data sources.
row_level_permission_data_set (Union[IResolvable, RowLevelPermissionDataSetProperty, Dict[str, Any], None]) – The row-level security configuration for the data that you want to create.
row_level_permission_tag_configuration (Union[IResolvable, RowLevelPermissionTagConfigurationProperty, Dict[str, Any], None]) – The element you can use to define tags for row-level security.
tags (Optional[Sequence[Union[CfnTag, Dict[str, Any]]]]) – Contains a map of the key-value pairs for the resource tag or tags assigned to the dataset.

Link:

http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-quicksight-dataset.html

ExampleMetadata:

fixture=_generated

Example:

# The code below shows an example of how to instantiate this type.
# The values are placeholders you should change.
import aws_cdk.aws_quicksight as quicksight

# tag_rule_configurations: Any

cfn_data_set_props = quicksight.CfnDataSetProps(
    aws_account_id="awsAccountId",
    column_groups=[quicksight.CfnDataSet.ColumnGroupProperty(
        geo_spatial_column_group=quicksight.CfnDataSet.GeoSpatialColumnGroupProperty(
            columns=["columns"],
            name="name",

            # the properties below are optional
            country_code="countryCode"
        )
    )],
    column_level_permission_rules=[quicksight.CfnDataSet.ColumnLevelPermissionRuleProperty(
        column_names=["columnNames"],
        principals=["principals"]
    )],
    data_set_id="dataSetId",
    dataset_parameters=[quicksight.CfnDataSet.DatasetParameterProperty(
        date_time_dataset_parameter=quicksight.CfnDataSet.DateTimeDatasetParameterProperty(
            id="id",
            name="name",
            value_type="valueType",

            # the properties below are optional
            default_values=quicksight.CfnDataSet.DateTimeDatasetParameterDefaultValuesProperty(
                static_values=["staticValues"]
            ),
            time_granularity="timeGranularity"
        ),
        decimal_dataset_parameter=quicksight.CfnDataSet.DecimalDatasetParameterProperty(
            id="id",
            name="name",
            value_type="valueType",

            # the properties below are optional
            default_values=quicksight.CfnDataSet.DecimalDatasetParameterDefaultValuesProperty(
                static_values=[123]
            )
        ),
        integer_dataset_parameter=quicksight.CfnDataSet.IntegerDatasetParameterProperty(
            id="id",
            name="name",
            value_type="valueType",

            # the properties below are optional
            default_values=quicksight.CfnDataSet.IntegerDatasetParameterDefaultValuesProperty(
                static_values=[123]
            )
        ),
        string_dataset_parameter=quicksight.CfnDataSet.StringDatasetParameterProperty(
            id="id",
            name="name",
            value_type="valueType",

            # the properties below are optional
            default_values=quicksight.CfnDataSet.StringDatasetParameterDefaultValuesProperty(
                static_values=["staticValues"]
            )
        )
    )],
    data_set_refresh_properties=quicksight.CfnDataSet.DataSetRefreshPropertiesProperty(
        refresh_configuration=quicksight.CfnDataSet.RefreshConfigurationProperty(
            incremental_refresh=quicksight.CfnDataSet.IncrementalRefreshProperty(
                lookback_window=quicksight.CfnDataSet.LookbackWindowProperty(
                    column_name="columnName",
                    size=123,
                    size_unit="sizeUnit"
                )
            )
        )
    ),
    data_set_usage_configuration=quicksight.CfnDataSet.DataSetUsageConfigurationProperty(
        disable_use_as_direct_query_source=False,
        disable_use_as_imported_source=False
    ),
    field_folders={
        "field_folders_key": quicksight.CfnDataSet.FieldFolderProperty(
            columns=["columns"],
            description="description"
        )
    },
    import_mode="importMode",
    ingestion_wait_policy=quicksight.CfnDataSet.IngestionWaitPolicyProperty(
        ingestion_wait_time_in_hours=123,
        wait_for_spice_ingestion=False
    ),
    logical_table_map={
        "logical_table_map_key": quicksight.CfnDataSet.LogicalTableProperty(
            alias="alias",
            source=quicksight.CfnDataSet.LogicalTableSourceProperty(
                data_set_arn="dataSetArn",
                join_instruction=quicksight.CfnDataSet.JoinInstructionProperty(
                    left_operand="leftOperand",
                    on_clause="onClause",
                    right_operand="rightOperand",
                    type="type",

                    # the properties below are optional
                    left_join_key_properties=quicksight.CfnDataSet.JoinKeyPropertiesProperty(
                        unique_key=False
                    ),
                    right_join_key_properties=quicksight.CfnDataSet.JoinKeyPropertiesProperty(
                        unique_key=False
                    )
                ),
                physical_table_id="physicalTableId"
            ),

            # the properties below are optional
            data_transforms=[quicksight.CfnDataSet.TransformOperationProperty(
                cast_column_type_operation=quicksight.CfnDataSet.CastColumnTypeOperationProperty(
                    column_name="columnName",
                    new_column_type="newColumnType",

                    # the properties below are optional
                    format="format"
                ),
                create_columns_operation=quicksight.CfnDataSet.CreateColumnsOperationProperty(
                    columns=[quicksight.CfnDataSet.CalculatedColumnProperty(
                        column_id="columnId",
                        column_name="columnName",
                        expression="expression"
                    )]
                ),
                filter_operation=quicksight.CfnDataSet.FilterOperationProperty(
                    condition_expression="conditionExpression"
                ),
                override_dataset_parameter_operation=quicksight.CfnDataSet.OverrideDatasetParameterOperationProperty(
                    parameter_name="parameterName",

                    # the properties below are optional
                    new_default_values=quicksight.CfnDataSet.NewDefaultValuesProperty(
                        date_time_static_values=["dateTimeStaticValues"],
                        decimal_static_values=[123],
                        integer_static_values=[123],
                        string_static_values=["stringStaticValues"]
                    ),
                    new_parameter_name="newParameterName"
                ),
                project_operation=quicksight.CfnDataSet.ProjectOperationProperty(
                    projected_columns=["projectedColumns"]
                ),
                rename_column_operation=quicksight.CfnDataSet.RenameColumnOperationProperty(
                    column_name="columnName",
                    new_column_name="newColumnName"
                ),
                tag_column_operation=quicksight.CfnDataSet.TagColumnOperationProperty(
                    column_name="columnName",
                    tags=[quicksight.CfnDataSet.ColumnTagProperty(
                        column_description=quicksight.CfnDataSet.ColumnDescriptionProperty(
                            text="text"
                        ),
                        column_geographic_role="columnGeographicRole"
                    )]
                )
            )]
        )
    },
    name="name",
    permissions=[quicksight.CfnDataSet.ResourcePermissionProperty(
        actions=["actions"],
        principal="principal"
    )],
    physical_table_map={
        "physical_table_map_key": quicksight.CfnDataSet.PhysicalTableProperty(
            custom_sql=quicksight.CfnDataSet.CustomSqlProperty(
                columns=[quicksight.CfnDataSet.InputColumnProperty(
                    name="name",
                    type="type"
                )],
                data_source_arn="dataSourceArn",
                name="name",
                sql_query="sqlQuery"
            ),
            relational_table=quicksight.CfnDataSet.RelationalTableProperty(
                data_source_arn="dataSourceArn",
                input_columns=[quicksight.CfnDataSet.InputColumnProperty(
                    name="name",
                    type="type"
                )],
                name="name",

                # the properties below are optional
                catalog="catalog",
                schema="schema"
            ),
            s3_source=quicksight.CfnDataSet.S3SourceProperty(
                data_source_arn="dataSourceArn",
                input_columns=[quicksight.CfnDataSet.InputColumnProperty(
                    name="name",
                    type="type"
                )],

                # the properties below are optional
                upload_settings=quicksight.CfnDataSet.UploadSettingsProperty(
                    contains_header=False,
                    delimiter="delimiter",
                    format="format",
                    start_from_row=123,
                    text_qualifier="textQualifier"
                )
            )
        )
    },
    row_level_permission_data_set=quicksight.CfnDataSet.RowLevelPermissionDataSetProperty(
        arn="arn",
        permission_policy="permissionPolicy",

        # the properties below are optional
        format_version="formatVersion",
        namespace="namespace",
        status="status"
    ),
    row_level_permission_tag_configuration=quicksight.CfnDataSet.RowLevelPermissionTagConfigurationProperty(
        tag_rules=[quicksight.CfnDataSet.RowLevelPermissionTagRuleProperty(
            column_name="columnName",
            tag_key="tagKey",

            # the properties below are optional
            match_all_value="matchAllValue",
            tag_multi_value_delimiter="tagMultiValueDelimiter"
        )],

        # the properties below are optional
        status="status",
        tag_rule_configurations=tag_rule_configurations
    ),
    tags=[CfnTag(
        key="key",
        value="value"
    )]
)