Create or alter continuous export
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
Creates or alters a continuous export job.
Permissions
You must have at least Database Admin permissions to run this command.
Syntax
.create-or-alter continuous-export continuousExportName [over (T1, T2 )] to table externalTableName [with (propertyName = propertyValue [, ...])] <| query
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| continuousExportName | string |
✔️ | The name of the continuous export. Must be unique within the database. |
| externalTableName | string |
✔️ | The name of the external table export target. |
| query | string |
✔️ | The query to export. |
| T1, T2 | string |
A 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 won't be scoped, so all records will participate in all exports. See continuous data export overview for details. | |
| propertyName, propertyValue | string |
A comma-separated list of optional properties. |
Note
If the target external table uses impersonation authentication, you must specify a managed identity to run the continuous export. For more information, see Use a managed identity to run a continuous export job.
Supported properties
| Property | Type | Description |
|---|---|---|
intervalBetweenRuns |
Timespan |
The time span between continuous export executions. Must be greater than 1 minute. |
forcedLatency |
Timespan |
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. |
sizeLimit |
long |
The size limit in bytes of a single storage artifact being written (prior to compression). Valid range: 100 MB (default) to 1 GB. |
distributed |
bool |
Disable/enable distributed export. Setting to false is equivalent to single distribution hint. Default is true. |
parquetRowGroupSize |
int |
Relevant only when data format is Parquet. Controls the row group size in the exported files. Default row group size is 100,000 records. |
managedIdentity |
string |
The managed identity on behalf of which the continuous export job will run. The managed identity can be an object ID, or the system reserved word. For more information, see Use a managed identity to run a continuous export job. |
isDisabled |
bool |
Disable/enable the continuous export. Default is false. |
Example
.create-or-alter continuous-export MyExport
over (T)
to table ExternalBlob
with
(intervalBetweenRuns=1h,
forcedLatency=10m,
sizeLimit=104857600)
<| T
| Name | ExternalTableName | Query | ForcedLatency | IntervalBetweenRuns | CursorScopedTables | ExportProperties |
|---|---|---|---|---|---|---|
| MyExport | ExternalBlob | S | 00:10:00 | 01:00:00 | [ "['DB'].['S']" ] |
{ "SizeLimit": 104857600 } |