TabularSource interface
Kopiera aktivitetskällor av tabelltyp.
- Extends
Egenskaper
| additional |
Anger de ytterligare kolumner som ska läggas till i källdata. Typ: matris med objekt (AdditionalColumns) (eller Uttryck med resultType-matris med objekt). |
| query |
Tidsgräns för frågor. Typ: sträng (eller uttryck med resultType-sträng), mönster: ((\d+).)? (\d\d):(60|( [0-5][0-9]))):(60|( [0-5][0-9])). |
| type | De diskriminerande möjliga värdena: AvroSource, ExcelSource, ParquetSource, DelimitedTextSource, JsonSource, XmlSource, OrcSource, BinarySource, TabularSource, AzureTableSource, BlobSource, DocumentDbCollectionSource, CosmosDbSqlApiSource, DynamicsSource, DynamicsCrmSource, CommonDataServiceForAppsSource, RelationalSource, InformixSource, MicrosoftAccessSource, Db2Source, OdbcSource, MySqlSource, PostgreSqlSource, PostgreSqlV2Source, SybaseSource, SapBwSource, ODataSource, SalesforceSource, SalesforceServiceCloudSource, SapCloudForCustomerSource, SapEccSource, SapHanaSource, SapOpenHubSource, SapOdpSource, SapTableSource, RestSource, SqlSource, SqlServerSource, AmazonRdsForSqlServerSource, AzureSqlSource, SqlMISource, SqlDWSource, FileSystemSource, HdfsSource, AzureMySqlSource, AzureDataExplorerSource, OracleSource, AmazonRdsForOracleSource, TeradataSource, WebSource, CassandraSource, MongoDbSource, MongoDbAtlasSource, MongoDbV2Source, CosmosDbMongoDbApiSource, Office365Source, AzureDataLakeStoreStoreSource, AzureBlobFSSource, HttpSource, AmazonMWSSource, AzurePostgreSqlSource, ConcurSource, CouchbaseSource, DrillSource, EloquaSource, GoogleBigQuerySource, GoogleBigQueryV2Source, GreenplumSource, HBaseSource, HiveSource, HubspotSource, ImpalaSource, JiraSource, MagentoSource, MariaDBSource, AzureMariaDBSource, MarketoSource, PaypalSource, PhoenixSource, PrestoSource, QuickBooksSource, ServiceNowSource, ShopifySource, SparkSource, SquareSource, XeroSource, ZohoSource, NetezzaSource, VerticaSource, SalesforceMarketingCloudSource, ResponsysSource, DynamicsAXSource, OracleServiceCloudSource, GoogleAdWordsSource, AmazonRedshiftSource, LakeHouseTableSource, SnowflakeSource, SnowflakeV2Source, AzureDatabricksDeltaLakeSource, WarehouseSource, SharePointOnlineListSource, SalesforceV2Source, SalesforceServiceCloudV2Source, ServiceNowV2Source |
Ärvda egenskaper
| additional |
Ytterligare egenskaper |
| disable |
Om det är sant inaktiverar du insamling av datalagermått. Standardvärdet är falskt. Typ: booleskt (eller uttryck med resultType booleskt värde). |
| max |
Maximalt antal samtidiga anslutningar för källdatalagret. Typ: heltal (eller uttryck med resultType-heltal). |
| source |
Antal återförsök av källa. Typ: heltal (eller uttryck med resultType-heltal). |
| source |
Källförsök väntar igen. Typ: sträng (eller uttryck med resultType-sträng), mönster: ((\d+).)? (\d\d):(60|( [0-5][0-9]))):(60|( [0-5][0-9])). |
Egenskapsinformation
additionalColumns
Anger de ytterligare kolumner som ska läggas till i källdata. Typ: matris med objekt (AdditionalColumns) (eller Uttryck med resultType-matris med objekt).
additionalColumns?: any
Egenskapsvärde
any
queryTimeout
Tidsgräns för frågor. Typ: sträng (eller uttryck med resultType-sträng), mönster: ((\d+).)? (\d\d):(60|( [0-5][0-9]))):(60|( [0-5][0-9])).
queryTimeout?: any
Egenskapsvärde
any
type
De diskriminerande möjliga värdena: AvroSource, ExcelSource, ParquetSource, DelimitedTextSource, JsonSource, XmlSource, OrcSource, BinarySource, TabularSource, AzureTableSource, BlobSource, DocumentDbCollectionSource, CosmosDbSqlApiSource, DynamicsSource, DynamicsCrmSource, CommonDataServiceForAppsSource, RelationalSource, InformixSource, MicrosoftAccessSource, Db2Source, OdbcSource, MySqlSource, PostgreSqlSource, PostgreSqlV2Source, SybaseSource, SapBwSource, ODataSource, SalesforceSource, SalesforceServiceCloudSource, SapCloudForCustomerSource, SapEccSource, SapHanaSource, SapOpenHubSource, SapOdpSource, SapTableSource, RestSource, SqlSource, SqlServerSource, AmazonRdsForSqlServerSource, AzureSqlSource, SqlMISource, SqlDWSource, FileSystemSource, HdfsSource, AzureMySqlSource, AzureDataExplorerSource, OracleSource, AmazonRdsForOracleSource, TeradataSource, WebSource, CassandraSource, MongoDbSource, MongoDbAtlasSource, MongoDbV2Source, CosmosDbMongoDbApiSource, Office365Source, AzureDataLakeStoreStoreSource, AzureBlobFSSource, HttpSource, AmazonMWSSource, AzurePostgreSqlSource, ConcurSource, CouchbaseSource, DrillSource, EloquaSource, GoogleBigQuerySource, GoogleBigQueryV2Source, GreenplumSource, HBaseSource, HiveSource, HubspotSource, ImpalaSource, JiraSource, MagentoSource, MariaDBSource, AzureMariaDBSource, MarketoSource, PaypalSource, PhoenixSource, PrestoSource, QuickBooksSource, ServiceNowSource, ShopifySource, SparkSource, SquareSource, XeroSource, ZohoSource, NetezzaSource, VerticaSource, SalesforceMarketingCloudSource, ResponsysSource, DynamicsAXSource, OracleServiceCloudSource, GoogleAdWordsSource, AmazonRedshiftSource, LakeHouseTableSource, SnowflakeSource, SnowflakeV2Source, AzureDatabricksDeltaLakeSource, WarehouseSource, SharePointOnlineListSource, SalesforceV2Source, SalesforceServiceCloudV2Source, ServiceNowV2Source
type: "TabularSource" | "AzureTableSource" | "InformixSource" | "Db2Source" | "OdbcSource" | "MySqlSource" | "PostgreSqlSource" | "PostgreSqlV2Source" | "SybaseSource" | "SapBwSource" | "SalesforceSource" | "SapCloudForCustomerSource" | "SapEccSource" | "SapHanaSource" | "SapOpenHubSource" | "SapOdpSource" | "SapTableSource" | "SqlSource" | "SqlServerSource" | "AmazonRdsForSqlServerSource" | "AzureSqlSource" | "SqlMISource" | "SqlDWSource" | "AzureMySqlSource" | "TeradataSource" | "CassandraSource" | "AmazonMWSSource" | "AzurePostgreSqlSource" | "ConcurSource" | "CouchbaseSource" | "DrillSource" | "EloquaSource" | "GoogleBigQuerySource" | "GoogleBigQueryV2Source" | "GreenplumSource" | "HBaseSource" | "HiveSource" | "HubspotSource" | "ImpalaSource" | "JiraSource" | "MagentoSource" | "MariaDBSource" | "AzureMariaDBSource" | "MarketoSource" | "PaypalSource" | "PhoenixSource" | "PrestoSource" | "QuickBooksSource" | "ServiceNowSource" | "ShopifySource" | "SparkSource" | "SquareSource" | "XeroSource" | "ZohoSource" | "NetezzaSource" | "VerticaSource" | "SalesforceMarketingCloudSource" | "ResponsysSource" | "DynamicsAXSource" | "OracleServiceCloudSource" | "GoogleAdWordsSource" | "AmazonRedshiftSource" | "WarehouseSource" | "SalesforceV2Source" | "ServiceNowV2Source"
Egenskapsvärde
"TabularSource" | "AzureTableSource" | "InformixSource" | "Db2Source" | "OdbcSource" | "MySqlSource" | "PostgreSqlSource" | "PostgreSqlV2Source" | "SybaseSource" | "SapBwSource" | "SalesforceSource" | "SapCloudForCustomerSource" | "SapEccSource" | "SapHanaSource" | "SapOpenHubSource" | "SapOdpSource" | "SapTableSource" | "SqlSource" | "SqlServerSource" | "AmazonRdsForSqlServerSource" | "AzureSqlSource" | "SqlMISource" | "SqlDWSource" | "AzureMySqlSource" | "TeradataSource" | "CassandraSource" | "AmazonMWSSource" | "AzurePostgreSqlSource" | "ConcurSource" | "CouchbaseSource" | "DrillSource" | "EloquaSource" | "GoogleBigQuerySource" | "GoogleBigQueryV2Source" | "GreenplumSource" | "HBaseSource" | "HiveSource" | "HubspotSource" | "ImpalaSource" | "JiraSource" | "MagentoSource" | "MariaDBSource" | "AzureMariaDBSource" | "MarketoSource" | "PaypalSource" | "PhoenixSource" | "PrestoSource" | "QuickBooksSource" | "ServiceNowSource" | "ShopifySource" | "SparkSource" | "SquareSource" | "XeroSource" | "ZohoSource" | "NetezzaSource" | "VerticaSource" | "SalesforceMarketingCloudSource" | "ResponsysSource" | "DynamicsAXSource" | "OracleServiceCloudSource" | "GoogleAdWordsSource" | "AmazonRedshiftSource" | "WarehouseSource" | "SalesforceV2Source" | "ServiceNowV2Source"
Information om ärvda egenskaper
additionalProperties
Ytterligare egenskaper
additionalProperties?: Record<string, any>
Egenskapsvärde
Record<string, any>
Ärvt frånCopySource.additionalProperties
disableMetricsCollection
Om det är sant inaktiverar du insamling av datalagermått. Standardvärdet är falskt. Typ: booleskt (eller uttryck med resultType booleskt värde).
disableMetricsCollection?: any
Egenskapsvärde
any
Ärvd frånCopySource.disableMetricsCollection
maxConcurrentConnections
Maximalt antal samtidiga anslutningar för källdatalagret. Typ: heltal (eller uttryck med resultType-heltal).
maxConcurrentConnections?: any
Egenskapsvärde
any
Ärvd frånCopySource.maxConcurrentConnections
sourceRetryCount
Antal återförsök av källa. Typ: heltal (eller uttryck med resultType-heltal).
sourceRetryCount?: any
Egenskapsvärde
any
Ärvd frånCopySource.sourceRetryCount
sourceRetryWait
Källförsök väntar igen. Typ: sträng (eller uttryck med resultType-sträng), mönster: ((\d+).)? (\d\d):(60|( [0-5][0-9]))):(60|( [0-5][0-9])).
sourceRetryWait?: any
Egenskapsvärde
any
Ärvd frånCopySource.sourceRetryWait