创建或更改连续导出Create or alter continuous export

创建或更改连续导出作业。Creates or alters a continuous export job.

语法Syntax

.create-or-alter continuous-export ContinuousExportName.create-or-alter continuous-export ContinuousExportName
[ over (T1 , T2 )][ over (T1 , T2 )]
to table ExternalTableNameto table ExternalTableName
[ with (PropertyName = PropertyValue,...)][ with (PropertyName = PropertyValue,...)]
<| Query<| Query

属性Properties

propertiesProperty 类型Type 说明Description
ContinuousExportNameContinuousExportName StringString 连续导出的名称。Name of continuous export. 该名称在数据库中必须独一无二,用于定期运行连续导出。Name must be unique within the database and is used to periodically run the continuous export.
ExternalTableNameExternalTableName StringString 要导出到的外部表的名称。Name of external table to export to.
查询Query StringString 要导出的查询。Query to export.
over (T1, T2)over (T1, T2) StringString 查询中可选的以逗号分隔的事实数据表列表。An optional comma-separated list of fact tables in the query. 如果不指定此项,将假定查询中引用的所有表都是事实数据表。If not specified, all tables referenced in the query are assumed to be fact tables. 如果指定此项,则不在此列表中的表将被视为维度表,并且将没有作用域(所有记录都将参与所有导出)。If specified, tables not in this list are treated as dimension tables and will not be scoped (all records will participate in all exports). 有关详细信息,请参阅连续数据导出概述See continuous data export overview for details.
intervalBetweenRunsintervalBetweenRuns TimespanTimespan 连续导出执行之间的时间跨度。The time span between continuous export executions. 必须大于 1 分钟。Must be greater than 1 minute.
forcedLatencyforcedLatency TimespanTimespan 一个可选的时间段,将查询范围限定为在此时间段之前(相对于当前时间)引入的记录。An optional period of time to limit the query to records that were ingested only prior to this period (relative to current time). 例如,如果查询执行一些聚合/联接操作,而你想要确保在运行导出之前已引入所有相关记录,则此属性很有用。This property is useful if, for example, the query performs some aggregations/joins and you would like to make sure all relevant records have already been ingested before running the export.

除此之外,连续导出的创建命令支持导出到外部表命令支持的所有属性。In addition to the above, all properties supported in export to external table command are supported in the continuous export create command.

示例Example

.create-or-alter continuous-export MyExport
over (T)
to table ExternalBlob
with
(intervalBetweenRuns=1h, 
 forcedLatency=10m, 
 sizeLimit=104857600)
<| T
名称Name ExternalTableNameExternalTableName 查询Query ForcedLatencyForcedLatency IntervalBetweenRunsIntervalBetweenRuns CursorScopedTablesCursorScopedTables ExportPropertiesExportProperties
MyExportMyExport ExternalBlobExternalBlob SS 00:10:0000:10:00 01:00:0001:00:00 [[
"['DB'].['S']""['DB'].['S']"
]]
{{
"SizeLimit":104857600"SizeLimit": 104857600
}}