This is the new *CloudFormation Template Reference Guide*. Please update your bookmarks and links. For help getting started with CloudFormation, see the [AWS CloudFormation User Guide](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/Welcome.html).

# AWS::IoTAnalytics::Dataset QueryAction
<a name="aws-properties-iotanalytics-dataset-queryaction"></a>

An "SqlQueryDatasetAction" object that uses an SQL query to automatically create data set contents.

## Syntax
<a name="aws-properties-iotanalytics-dataset-queryaction-syntax"></a>

To declare this entity in your CloudFormation template, use the following syntax:

### JSON
<a name="aws-properties-iotanalytics-dataset-queryaction-syntax.json"></a>

```
{
  "[Filters](#cfn-iotanalytics-dataset-queryaction-filters)" : [ Filter, ... ],
  "[SqlQuery](#cfn-iotanalytics-dataset-queryaction-sqlquery)" : String
}
```

### YAML
<a name="aws-properties-iotanalytics-dataset-queryaction-syntax.yaml"></a>

```
  [Filters](#cfn-iotanalytics-dataset-queryaction-filters): 
    - Filter
  [SqlQuery](#cfn-iotanalytics-dataset-queryaction-sqlquery): String
```

## Properties
<a name="aws-properties-iotanalytics-dataset-queryaction-properties"></a>

`Filters`  <a name="cfn-iotanalytics-dataset-queryaction-filters"></a>
Pre-filters applied to message data.  
*Required*: No  
*Type*: Array of [Filter](aws-properties-iotanalytics-dataset-filter.md)  
*Minimum*: `0`  
*Maximum*: `1`  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)

`SqlQuery`  <a name="cfn-iotanalytics-dataset-queryaction-sqlquery"></a>
An "SqlQueryDatasetAction" object that uses an SQL query to automatically create data set contents.  
*Required*: Yes  
*Type*: String  
*Update requires*: [No interruption](https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/using-cfn-updating-stacks-update-behaviors.html#update-no-interrupt)