LookupActivity Class

Definition

Lookup activity.

[System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.LookupActivity+LookupActivityConverter))]
public class LookupActivity : Azure.Analytics.Synapse.Artifacts.Models.ExecutionActivity
[<System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.LookupActivity+LookupActivityConverter))>]
type LookupActivity = class
    inherit ExecutionActivity
Public Class LookupActivity
Inherits ExecutionActivity
Inheritance
Attributes

Constructors

LookupActivity(String, CopySource, DatasetReference)

Initializes a new instance of LookupActivity.

Properties

AdditionalProperties

Additional Properties.

(Inherited from Activity)
Dataset

Lookup activity dataset reference.

DependsOn

Activity depends on condition.

(Inherited from Activity)
Description

Activity description.

(Inherited from Activity)
FirstRowOnly

Whether to return first row or all rows. Default value is true. Type: boolean (or Expression with resultType boolean).

LinkedServiceName

Linked service reference.

(Inherited from ExecutionActivity)
Name

Activity name.

(Inherited from Activity)
OnInactiveMarkAs

Status result of the activity when the state is set to Inactive. This is an optional property and if not provided when the activity is inactive, the status will be Succeeded by default.

(Inherited from Activity)
Policy

Activity policy.

(Inherited from ExecutionActivity)
Source

Dataset-specific source properties, same as copy activity source. Please note CopySource is the base class. According to the scenario, a derived class of the base class might need to be assigned here, or this property needs to be casted to one of the possible derived classes. The available derived classes include AmazonMWSSource, AmazonRdsForOracleSource, AmazonRdsForSqlServerSource, AmazonRedshiftSource, AvroSource, AzureBlobFSSource, AzureDataExplorerSource, AzureDataLakeStoreSource, AzureDatabricksDeltaLakeSource, AzureMariaDBSource, AzureMySqlSource, AzurePostgreSqlSource, AzureSqlSource, AzureTableSource, BinarySource, BlobSource, CassandraSource, CommonDataServiceForAppsSource, ConcurSource, CosmosDbMongoDbApiSource, CosmosDbSqlApiSource, CouchbaseSource, Db2Source, DelimitedTextSource, DocumentDbCollectionSource, DrillSource, DynamicsAXSource, DynamicsCrmSource, DynamicsSource, EloquaSource, ExcelSource, FileSystemSource, GoogleAdWordsSource, GoogleBigQuerySource, GreenplumSource, HBaseSource, HdfsSource, HiveSource, HttpSource, HubspotSource, ImpalaSource, InformixSource, JiraSource, JsonSource, MagentoSource, MariaDBSource, MarketoSource, MicrosoftAccessSource, MongoDbAtlasSource, MongoDbSource, MongoDbV2Source, MySqlSource, NetezzaSource, ODataSource, OdbcSource, Office365Source, OracleServiceCloudSource, OracleSource, OrcSource, ParquetSource, PaypalSource, PhoenixSource, PostgreSqlSource, PrestoSource, QuickBooksSource, RelationalSource, ResponsysSource, RestSource, SalesforceMarketingCloudSource, SalesforceServiceCloudSource, SalesforceSource, SapBwSource, SapCloudForCustomerSource, SapEccSource, SapHanaSource, SapOdpSource, SapOpenHubSource, SapTableSource, ServiceNowSource, SharePointOnlineListSource, ShopifySource, SnowflakeSource, SparkSource, SqlDWSource, SqlMISource, SqlServerSource, SqlSource, SquareSource, SybaseSource, TabularSource, TeradataSource, VerticaSource, WebSource, XeroSource, XmlSource and ZohoSource.

State

Activity state. This is an optional property and if not provided, the state will be Active by default.

(Inherited from Activity)
UserProperties

Activity user properties.

(Inherited from Activity)

Applies to