aws-cdk-lib.aws_cleanrooms.CfnConfiguredTable.ConfiguredTableAnalysisRulePolicyV1Property

ConfiguredTableAnalysisRulePolicyV1Property Struct

Controls on the query specifications that can be run on a configured table.

Source

Generated code

Type last changed

v2.95.0 · 7 Sep 2023

Example

// The code below shows an example of how to instantiate this type.
// The values are placeholders you should change.
import { aws_cleanrooms as cleanrooms } from 'aws-cdk-lib';
const configuredTableAnalysisRulePolicyV1Property: cleanrooms.CfnConfiguredTable.ConfiguredTableAnalysisRulePolicyV1Property = {
  aggregation: {
    aggregateColumns: [{
      columnNames: ['columnNames'],
      function: 'function',
    }],
    dimensionColumns: ['dimensionColumns'],
    joinColumns: ['joinColumns'],
    outputConstraints: [{
      columnName: 'columnName',
      minimum: 123,
      type: 'type',
    }],
    scalarFunctions: ['scalarFunctions'],

    // the properties below are optional
    additionalAnalyses: 'additionalAnalyses',
    allowedJoinOperators: ['allowedJoinOperators'],
    joinRequired: 'joinRequired',
  },
  custom: {
    allowedAnalyses: ['allowedAnalyses'],

    // the properties below are optional
    additionalAnalyses: 'additionalAnalyses',
    aggregationThresholds: [{
      allowedAggregateExpressionType: 'allowedAggregateExpressionType',
      identityColumns: ['identityColumns'],
      minimumIdentityCount: 123,
      type: 'type',

      // the properties below are optional
      outputColumnThresholds: [{
        minimumIdentityCount: 123,
        outputColumnName: 'outputColumnName',
      }],
    }],
    allowedAnalysisProviders: ['allowedAnalysisProviders'],
    comparisonControls: {
      allowedColumnComparisonColumns: ['allowedColumnComparisonColumns'],
      allowedLiteralComparisonColumns: ['allowedLiteralComparisonColumns'],
    },
    differentialPrivacy: {
      columns: [{
        name: 'name',
      }],
    },
    disallowedOutputColumns: ['disallowedOutputColumns'],
  },
  list: {
    joinColumns: ['joinColumns'],
    listColumns: ['listColumns'],

    // the properties below are optional
    additionalAnalyses: 'additionalAnalyses',
    allowedJoinOperators: ['allowedJoinOperators'],
  },
};

Properties

aggregation?optionalIResolvable | CfnConfiguredTable.AnalysisRuleAggregationPropertyaggregation?optionaltyping.Union[IResolvable, AnalysisRuleAggregationProperty]aggregation?optionalIResolvableAggregation?optionalIResolvableAggregation?optionalinterface{}#

Analysis rule type that enables only aggregation queries on a configured table.

custom?optionalIResolvable | CfnConfiguredTable.AnalysisRuleCustomPropertycustom?optionaltyping.Union[IResolvable, AnalysisRuleCustomProperty]custom?optionalIResolvableCustom?optionalIResolvableCustom?optionalinterface{}#

Analysis rule type that enables custom SQL queries on a configured table.

list?optionalIResolvable | CfnConfiguredTable.AnalysisRuleListPropertylist?optionaltyping.Union[IResolvable, AnalysisRuleListProperty]list?optionalIResolvableList?optionalIResolvableList?optionalinterface{}#

Analysis rule type that enables only list queries on a configured table.